首页 > 数据库 > Oracle > 重建控制文件后将备份信息注册
查看备份:
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博客 ” ,链接:https://blog.itpub.net/29362142/viewspace-1061909/ ,如需转载,请注明出处,否则将追究法律责任。