oracle从归档日志恢复数据,备份与恢复--从备份的归档日志中恢复数据

在恢复过程中，Oracle利用归档日志进行恢复，默认情况下，Oracle会在归档日志的产生目录来寻找归档日志文件。

如果在恢复时发现归档日志被备份并从归档目录删除，则Oracle在恢复过程中无法找到指定的归档日志文件。[@more@]

SQL> alter tablespace users offline;

Tablespace altered.

备份当前的归档日志

SQL> host cp /u01/app/oracle/admin/orcl/archive/*.* /u01/backup/archive

移除当前的归档日志

SQL> host rm /u01/app/oracle/admin/orcl/archive/*.*

用备份的datafile替换当前的

SQL> host cp /u01/backup/users01.dbf /u01/app/oracle/oradata/orcl

SQL> recover tablespace users;

ORA-00279: change 685260 generated at 01/13/2009 09:45:47 needed for thread 1

ORA-00289: suggestion : /u01/app/oracle/admin/orcl/archive/1_23_675592897.dbf

ORA-00280: change 685260 for thread 1 is in sequence #23

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

AUTO

ORA-00308: cannot open archived log '/u01/app/oracle/admin/orcl/archive/1_23_675592897.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log '/u01/app/oracle/admin/orcl/archive/1_23_675592897.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

这时做recovery时提示找不到归档日志。

SQL> host cp /u01/backup/archive/*.* /u01/app/oracle/admin/orcl/archive

SQL> recover tablespace users;

ORA-00279: change 685260 generated at 01/13/2009 09:45:47 needed for thread 1

ORA-00289: suggestion : /u01/app/oracle/admin/orcl/archive/1_23_675592897.dbf

ORA-00280: change 685260 for thread 1 is in sequence #23

Specify log: {=suggested | filename | AUTO | CA