ITPub博客

首页 > 数据库 > Oracle > 重建控制文件后将备份信息注册

重建控制文件后将备份信息注册

Oracle 作者:lsfzly 时间:2013-12-02 21:39:29 0 删除 编辑

查看备份:
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/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2013-12-02

  • 博文量
    122
  • 访问量
    97508