Oracle恢复测试

jgugugiug

用隐含参数_allow_resetlogs_corruption和重建undo tablespace 问题：　　某个现场做数据库恢复的时侯有一个问题：DB恢复需要这个归档日志文件1_33160.dbf，但是在备份中没有。
　　SQL> recover database using backup controlfile until cancel;
　　ORA-00279: change 4207433305 generated at 04/23/2008 02:00:33 needed for thread 1
　　ORA-00289: suggestion :
　　/opt/oracle/db02/app/oracle/oradata/ORCL/archive/1_33160.dbf
　　ORA-00280: change 4207433305 for thread 1 is in sequence #33160
　　Specify log: {=suggested | filename | AUTO | CANCEL}
　　ORA-00308: cannot open archived log
　　'/opt/oracle/db02/app/oracle/oradata/ORCL/archive/1_33160.dbf'
　　ORA-27037: unable to obtain file status
　　SVR4 Error: 2: No such file or directory
　　Additional information: 3
　　ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
　　ORA-01195: online backup of file 1 needs more recovery to be consistent
　　ORA-01110: data file 1: '/opt/oracle/db02/app/oracle/oradata/ORCL/system01.dbf'
　　解决过程：
　　SunOS 5.8
　　login: oracle
　　Password:
　　Last login: Sun May 4 10:39:57 from 172.19.136.49
　　Sun Microsystems Inc. SunOS 5.8 Generic Patch February 2004
　　$ ls
　　db01 db02 db03 db04 lost+found
　　$ sqlplus '/as sysdba'

　　SQL*Plus:>　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
　　Connected to:

　　Oracle9i Enterprise Edition>　　With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options

　　JServer>　　SQL> archive log list;
　　Database log mode Archive Mode
　　Automatic archival Enabled
　　Archive destination /opt/oracle/db02/app/oracle/oradata/ORCL/archive
　　Oldest online log sequence 33159
　　Next log sequence to archive 33161
　　Current log sequence 33161

　　SQL>>　　alter database open
　　*
　　ERROR at line 1:
　　ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

　　SQL>>　　alter database open resetlogs
　　*
　　ERROR at line 1:
　　ORA-01195: online backup of file 1 needs more recovery to be consistent
　　ORA-01110: data file 1: '/opt/oracle/db02/app/oracle/oradata/ORCL/system01.dbf'
　　resetlogs的字面意思是重置重做日志。在创建控制文件的时候如果不需要在线重做日志的话可以用resetlogs选项，第二种情况是在做不完全恢复后，数据文件和重做日志的内容不同步了，这个时候打开数据库一定要用resetlogs选项。resetlogs 的时候数据库其实做了很多事，最主要的还是清空重做日志的内容，选定一个重做日志作为当前日志并将日志序列号重置为1，把resetlogs count和resetlogs scn写入控制文件、数据文件头部和重做日志的头部，当然还会做很多其它的事情。
　　SQL> shutdown immediate
　　ORA-01109: database not open
　　Database dismounted.
　　ORACLE instance shut down.
　　SQL> startup mount
　　ORACLE instance started.
　　Total System Global Area 826248288 bytes

　　Fixed>
　　Variable>　　Database Buffers 318767104 bytes
　　Redo Buffers 3432448 bytes
　　Database mounted.
　　尝试一下基于时间点的不完全恢复：
　　SQL> recover database using backup controlfile until time '2008-04-30 01:00:00';
　　ORA-00279: change 4207433305 generated at 04/23/2008 02:00:33 needed for thread 1
　　ORA-00289: suggestion :
　　/opt/oracle/db02/app/oracle/oradata/ORCL/archive/1_33160.dbf
　　ORA-00280: change 4207433305 for thread 1 is in sequence #33160
　　Specify log: {=suggested | filename | AUTO | CANCEL}
　　ORA-00308: cannot open archived log
　　'/opt/oracle/db02/app/oracle/oradata/ORCL/archive/1_33160.dbf'
　　ORA-27037: unable to obtain file status
　　SVR4 Error: 2: No such file or directory
　　Additional information: 3
　　ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
　　ORA-01195: online backup of file 1 needs more recovery to be consistent
　　ORA-01110: data file 1: '/opt/oracle/db02/app/oracle/oradata/ORCL/system01.dbf'

　　SQL>>　　alter database open resetlogs
　　*
　　ERROR at line 1:
　　ORA-01195: online backup of file 1 needs more recovery to be consistent
　　ORA-01110: data file 1: '/opt/oracle/db02/app/oracle/oradata/ORCL/system01.dbf'