【翻译自mos文章】当控制文件的备份丢失时，怎么restoredatabase - 数据库编程

3/1.ctl CREATE CONTROLFILE REUSE DATABASE "ORA102" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/u01/app/oracle/oradata/ora102/ORA102/onlinelog/o1_mf_1_7lqq1m62_.log' SIZE 50M, GROUP 2 '/u01/app/oracle/oradata/ora102/ORA102/onlinelog/o1_mf_2_7lqq1myr_.log' SIZE 50M, GROUP 3 '/u01/app/oracle/oradata/ora102/ORA102/onlinelog/o1_mf_3_7lqq1nr0_.log' SIZE 50M DATAFILE '/u03/datafile1.dbf', '/u03/datafile4.dbf', '/u03/datafile2.dbf', '/u03/datafile3.dbf', '/u03/datafile5.dbf' CHARACTER SET WE8ISO8859P1 ; SQL> @/u03/1.ctl Control file created. SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u03/datafile1.dbf /u03/datafile2.dbf /u03/datafile3.dbf /u03/datafile4.dbf /u03/datafile5.dbf

6.若是该备份不是冷备份，那么我们需要recover database，我们需要catalog 包括archivelog的backuppiece，然后restore archivelog，然后在recover

SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>

7. 一旦数据库处于一致性状态，我们可以用resetlogs的方式 open database

SQL>alter database open resetlogs;
Database altered.
SQL>

注意：
在multisection backup 的情况下，我们需要考虑所有的backuppiece（也就是所有的section）,使用initmsr函数来restore datafile

DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype := dbms_backup_restore.DeviceAllocate(type=>null, ident=>'d1');   
dbms_backup_restore.RestoreSetDatafile;
dbms_backup_restore.initmsr(1,'/ud1001/PROD/oradata/system01-test.dbf');
dbms_backup_restore.RestoreDatafileTo(dfnumber => 1,toname => '/ud1001/PROD/oradata/system01-test.dbf');
dbms_backup_restore.RestoreBackupPiece(done => done,handle =>'/backup/Oracle-DB-8-7-2014/db_L0_PROD_e6pf7too_1_1.rman', params => null);
dbms_backup_restore.RestoreBackupPiece(done => done,handle =>'/backup/Oracle-DB-8-7-2014/db_L0_PROD_e6pf7too_2_1.rman', params => null);
END;
/

【翻译自mos文章】当控制文件的备份丢失时，怎么restoredatabase(三)