模拟控制文件丢失测试
SQL> alter database backup controlfile to trace;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area135338868 bytes
Fixed Size
453492 bytes
Variable Size
109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers
667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
SQL> CREATE CONTROLFILE REUSE DATABASE "GISTEST" NORESETLOGSARCHIVELOG
2--SET STANDBY TO MAXIMIZE PERFORMANCE
3MAXLOGFILES 5
4MAXLOGMEMBERS 3
5MAXDATAFILES 100
6MAXINSTANCES 1
7MAXLOGHISTORY 226
8LOGFILE
9GROUP 1 'D:\ORACLE\ORADATA\GISTEST\REDO01.LOG'SIZE 100M,
10GROUP 2 'D:\ORACLE\ORADATA\GISTEST\REDO02.LOG'SIZE 100M,
11GROUP 3 'D:\ORACLE\ORADATA\GISTEST\REDO03.LOG'SIZE 100M
12-- STANDBY LOGFILE
13DATAFILE
14'D:\ORACLE\ORADATA\GISTEST\SYSTEM01.DBF',
15'D:\ORACLE\ORADATA\GISTEST\UNDOTBS01.DBF',
16'D:\ORACLE\ORADATA\GISTEST\DRSYS01.DBF',
17'D:\ORACLE\ORADATA\GISTEST\INDX01.DBF',
18'D:\ORACLE\ORADATA\GISTEST\ODM01.DBF',
19'D:\ORACLE\ORADATA\GISTEST\TOOLS01.DBF',
20'D:\ORACLE\ORADATA\GISTEST\USERS01.DBF',
21'D:\ORACLE\ORADATA\GISTEST\XDB01.DBF',
22'D:\ORACLE\ORADATA\GISTEST\TSGIS_DATA.ORA'
23CHARACTER SET ZHT16BIG5
Control file created.
SQL> recover database using backup controlfile
ORA-00279: change 205390 generated at 09/21/2014 15:00:10 needed for thread 1
ORA-00289: suggestion : D:\ARCHIVED\ARC00006.001
ORA-00280: change 205390 for thread 1 is in sequence #6
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'D:\ARCHIVED\ARC00006.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00308: cannot open archived log 'D:\ARCHIVED\ARC00006.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL> recover database using backup controlfile
ORA-00279: change 205390 generated at 09/21/2014 15:00:10 needed for thread 1
ORA-00289: suggestion : D:\ARCHIVED\ARC00006.001
ORA-00280: change 205390 for thread 1 is in sequence #6
Specify log: {=suggested | filename | AUTO | CANCEL}
D:\oracle\oradata\gistest\REDO02.LOG
Log applied.
Media recovery complete.
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
|