• RMAN 与control文件的关系


    试验:

    SQL> oradebug setmypid;
    Statement processed.
    SQL>

    接着,进行backup:

    RMAN> list backup;    

    using target database control file instead of recovery catalog
    specification does not match any backup in the repository

    RMAN> backup database;

    Starting backup at 02-APR-14
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=41 device type=DISK
    channel ORA_DISK_1: starting full datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
    input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
    input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
    input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
    input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
    channel ORA_DISK_1: starting piece 1 at 02-APR-14
    channel ORA_DISK_1: finished piece 1 at 02-APR-14
    piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T164749_9mqmorj0_.bkp tag=TAG20140402T164749 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:02:17
    channel ORA_DISK_1: starting full datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    including current control file in backup set
    including current SPFILE in backup set
    channel ORA_DISK_1: starting piece 1 at 02-APR-14
    channel ORA_DISK_1: finished piece 1 at 02-APR-14
    piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T164749_9mqmt1w2_.bkp tag=TAG20140402T164749 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
    Finished backup at 02-APR-14

    RMAN> list backup;


    List of Backup Sets
    ===================


    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1       Full    1.10G      DISK        00:02:13     02-APR-14      
            BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20140402T164749
            Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T164749_9mqmorj0_.bkp
      List of Datafiles in backup set 1
      File LV Type Ckp SCN    Ckp Time  Name
      ---- -- ---- ---------- --------- ----
      1       Full 1059075    02-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
      2       Full 1059075    02-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
      3       Full 1059075    02-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
      4       Full 1059075    02-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
      5       Full 1059075    02-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2       Full    9.36M      DISK        00:00:05     02-APR-14      
            BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20140402T164749
            Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T164749_9mqmt1w2_.bkp
      SPFILE Included: Modification time: 02-APR-14
      SPFILE db_unique_name: ORCL
      Control File Included: Ckp SCN: 1059260      Ckp time: 02-APR-14

    RMAN>

    此时,看controlfile的dump:

    SQL> oradebug dump controlf 4;
    Statement processed.
    SQL>

    查看目录 下的 trc文件

    [oracle@localhost trace]$ pwd
    /u01/app/oracle/diag/rdbms/orcl/orcl/trace
    [oracle@localhost trace]$
    看到最新生成的文件名:orcl_ora_13835.trc


    查看此文件内容,确实可以看到backup的metada 反映在其中。

    Earliest record:
     RECID #1 Recno 1 Record timestamp  04/02/14 16:47:52 piece #1  copy #1 pool 0
      Backup set key: stamp=843842869, count=1
      V$RMAN_STATUS: recid=140735352737336, stamp=140735352737328
      Flags: <concurrent access>
      Device: DISK
      Handle: /u01/app/oracle/fast_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T164749_9mqmorj0_.bkp
      Media-Handle:
      Comment:
      Tag: TAG20140402T164749
      Completion time  04/02/14 16:50:01
    Latest record:
     RECID #2 Recno 2 Record timestamp  04/02/14 16:50:09 piece #1  copy #1 pool 0
      Backup set key: stamp=843843006, count=2
      V$RMAN_STATUS: recid=140735352737336, stamp=140735352737328
      Flags: <concurrent access>
      Device: DISK
      Handle: /u01/app/oracle/fast_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T164749_9mqmt1w2_.bkp
      Media-Handle:
      Comment:
      Tag: TAG20140402T164749
      Completion time  04/02/14 16:50:11
     RECID #1 Recno 1 Record timestamp  04/02/14 16:47:52 piece #1  copy #1 pool 0
      Backup set key: stamp=843842869, count=1
      V$RMAN_STATUS: recid=140735352737336, stamp=140735352737328
      Flags: <concurrent access>
      Device: DISK
      Handle: /u01/app/oracle/fast_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T164749_9mqmorj0_.bkp
      Media-Handle:
      Comment:
      Tag: TAG20140402T164749
      Completion time  04/02/14 16:50:01


  • 相关阅读:
    停机文件[Warning] Unsafe statement written to the binary log using statement format since 错误
    生成class关于使用javah生成头文件时无法访问class文件的问题
    NTLM
    openssl多线程实例
    GetProcessIDByName
    wmi事件
    web service远程测试(.net)
    NTpassword(MD4)
    [转载]win下实现切换帐号的方法
    fstoyou.com改了域名
  • 原文地址:https://www.cnblogs.com/gaojian/p/3641158.html
Copyright © 2020-2023  润新知