冷备+归档恢复数据库

一、 SQL>connect internal; /password

二、SQL> shutdown immediate;

数据库已经关闭。

已经卸载数据库。

ORACLE 例程已经关闭。

三、还原数据文件冷备份+冷备后的归档日志文件(注意:无需还原冷备份备份的控制文件和联机重做日志文件)

四、startup nomount;

五、创建控制裁文件（脚本如下）可以这样获得:alter database backup controlfile to trace;

然后查看alter.log

SQL> CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS ARCHIVELOG

2 MAXLOGFILES 32

3 MAXLOGMEMBERS 2

4 MAXDATAFILES 32

5 MAXINSTANCES 16

6 MAXLOGHISTORY 1600

7 LOGFILE

8 GROUP 1 'E:ORANT_LOGLOG1ORCL.ORA' SIZE 5M,

9 GROUP 2 'E:ORANT_LOGLOG2ORCL.ORA' SIZE 5M,

10 GROUP 3 'E:ORANT_LOGLOG3ORCL.ORA' SIZE 5M,

11 DATAFILE

12 'D:ORANTDATABASESYS1ORCL.ORA',

13 'D:ORANTDATABASEUSR1ORCL.ORA',

14 'D:ORANTDATABASERBS1ORCL.ORA',

15 'D:ORANTDATABASETMP1ORCL.ORA',

16 'D:ORANTDATABASEWSHIS1ORCL.ORA',

17 'D:ORANTDATABASEORACLE2ORCL.ORA',

18 'D:ORANTDATABASEWSHIS3ORCL.ORA',

19 'D:ORANTDATABASETMP2ORCL.ORA',

20 'D:ORANTDATABASERBS2ORCL.ORA',

21 'D:ORANTDATABASEWSHISINDEX1ORCL.ORA',

22 'D:ORANTDATABASETMP3ORCL.ORA';

Control file created.

六、 执行数据库恢复（最后一个归档文件的时间点后一分）

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE until time '2004-10-21 14:08:00';

ORA-00279: change 423708 generated at 10/21/2004 14:00:53 needed for thread 1

ORA-00289: suggestion : E:ARCHIVETESTTEST_18_1_539975300.ARC

ORA-00280: change 423708 for thread 1 is in sequence #18

Specify log: {=suggested | filename | AUTO | CANCEL}

七、auto

Log applied.

Media recovery complete.

八、SQL> alter database open resetlogs;

Database altered.

九、 检验恢复是否成功（数据点）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8362857/viewspace-709875/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8362857/viewspace-709875/