重建控制檔案後將備份資訊註冊

檢視備份：
RMAN> list backup;
List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69      Full    1.21G      DISK        00:01:04     27-NOV-13     
        BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: TAG20131127T110314
        Piece Name: /home/oracle/11271103full832590194
  List of Datafiles in backup set 69
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/system01.dbf
  2       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/sysaux01.dbf
  3       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/undotbs01.dbf
  4       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/users01.dbf
  5       Full 1297899    25-NOV-13 /u01/app/oracle/oradata/dong/ff.dbf
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
70      Full    9.70M      DISK        00:00:03     29-NOV-13     
        BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: TAG20131129T165807
        Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2075447482-20131129-00
  Control File Included: Ckp SCN: 1385405      Ckp time: 29-NOV-13

重建控制檔案：
SQL> startup nomount
ORACLE instance started.

Total System Global Area 2092498944 bytes
Fixed Size                  1337604 bytes
Variable Size             268437244 bytes
Database Buffers         1811939328 bytes
Redo Buffers               10784768 bytes
CREATE CONTROLFILE REUSE DATABASE "DONG" NORESETLOGS  ARCHIVELOG
        MAXLOGMEMBERS 3
    MAXLOGFILES 16
  3          MAXLOGMEMBERS 3
  4          MAXDATAFILES 100
  5          MAXINSTANCES 8
  6         MAXLOGHISTORY 292
  7      LOGFILE
  8         GROUP 2 '/u01/app/oracle/oradata/dong/redo02.log'  SIZE 50M BLOCKSIZE 512,
     GROUP 1 '/u01/app/oracle/oradata/dong/redo01.log'  SIZE 50M BLOCKSIZE 512,
       GROUP 2 '/u01/app/oracle/oradata/dong/redo02.log'  SIZE 50M BLOCKSIZE 512,
 10       GROUP 3 '/u01/app/oracle/oradata/dong/redo03.log'  SIZE 50M BLOCKSIZE 512
 11     -- STANDBY LOGFILE
 12      DATAFILE
 13        '/u01/app/oracle/oradata/dong/system01.dbf',
 14        '/u01/app/oracle/oradata/dong/sysaux01.dbf',
 15       '/u01/app/oracle/oradata/dong/undotbs01.dbf',
 16      '/u01/app/oracle/oradata/dong/users01.dbf'
 17        CHARACTER SET WE8MSWIN1252 ;

Control file created.

檢視備份資訊：
RMAN> list backup;

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

將備份資訊註冊到控制檔案中：
RMAN> catalog backuppiece '/home/oracle/11271103full832590194';

cataloged backup piece
backup piece handle=/home/oracle/11271103full832590194 RECID=1 STAMP=832789303

RMAN> list backup;

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.21G      DISK        00:00:00     27-NOV-13     
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20131127T110314
        Piece Name: /home/oracle/11271103full832590194
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/system01.dbf
  2       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/sysaux01.dbf
  3       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/undotbs01.dbf
  4       Full 1384847    27-NOV-13 /u01/app/oracle/oradata/dong/users01.dbf
  5       Full 1297899    25-NOV-13
或者註冊目錄：

RMAN> catalog start with '/home/oracle/';
此時會將這個目錄下每個檔案進行掃描，然後問Do you really want to catalog the above files (enter YES or NO)? 輸入yes即可，然後list backup就可以看到備份資訊了。
RMAN> catalog start with '/u01/app/oracle/flash_recovery_area/DONG/autobackup';

searching for all files that match the pattern /u01/app/oracle/flash_recovery_area/DONG/autobackup

List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_27/o1_mf_s_832590765_99brsfxv_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_27/o1_mf_s_832590070_99br9o1s_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832524565_998r4ov1_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832541764_9998y4w8_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832514404_998g7563_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832514288_998g3jxb_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832542551_9999pr1m_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832508153_99883tn2_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_10_22/o1_mf_s_829490912_96d5m0oz_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_10_22/o1_mf_s_829491297_96d5z2c1_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_20/o1_mf_s_831950343_98q8yj09_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_20/o1_mf_s_831948245_98q5bopz_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_20/o1_mf_s_831947553_98q4o1ls_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_19/o1_mf_s_831940693_98pxypkq_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_19/o1_mf_s_831943382_98q0lppz_.bkp

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_27/o1_mf_s_832590765_99brsfxv_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_27/o1_mf_s_832590070_99br9o1s_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832524565_998r4ov1_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832541764_9998y4w8_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832514404_998g7563_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832514288_998g3jxb_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832542551_9999pr1m_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_26/o1_mf_s_832508153_99883tn2_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_10_22/o1_mf_s_829490912_96d5m0oz_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_10_22/o1_mf_s_829491297_96d5z2c1_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_20/o1_mf_s_831950343_98q8yj09_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_20/o1_mf_s_831948245_98q5bopz_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_20/o1_mf_s_831947553_98q4o1ls_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_19/o1_mf_s_831940693_98pxypkq_.bkp
File Name: /u01/app/oracle/flash_recovery_area/DONG/autobackup/2013_11_19/o1_mf_s_831943382_98q0lppz_.bkp

 

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24500180/viewspace-1061698/，如需轉載，請註明出處，否則將追究法律責任。