• 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


  • 相关阅读:
    Unix命令大全
    vs2008 与 IE8出现的兼容性问题
    Java 创建文件、文件夹以及临时文件
    如何修改Wamp中mysql默认空密码
    PAT 乙级真题 1003.数素数
    Tags support in htmlText flash as3
    DelphiXE4 FireMonkey 试玩记录,开发IOS应用 还是移植
    10 Great iphone App Review sites to Promote your Apps!
    HTML tags in textfield
    Delphi XE4 IOS 开发, "No eligible applications were found“
  • 原文地址:https://www.cnblogs.com/gaojian/p/3641158.html
Copyright © 2020-2023  润新知