[oracle@test ora9i]$ ll
total 3329552
drwxr-xr-x 2 oracle oinstall 4096 Jun 23 13:15 arch
-rw-r----- 1 oracle oinstall 2023424 Jun 23 13:28 control01.ctl
-rw-r----- 1 oracle oinstall 2023424 Jun 23 13:28 control02.ctl
-rw-r----- 1 oracle oinstall 2023424 Jun 23 13:28 control03.ctl
-rw-r--r-- 1 oracle oinstall 20979712 Jun 23 13:28 cwmlite01.dbf
-rw-r--r-- 1 oracle oinstall 20979712 Jun 23 13:28 drsys01.dbf
-rw-r--r-- 1 oracle oinstall 156639232 Jun 23 13:28 example01.dbf
-rw-r----- 1 oracle oinstall 2147491840 Jun 23 13:28 gree.dbf
-rw-r--r-- 1 oracle oinstall 26222592 Jun 23 13:28 indx01.dbf
-rw-r--r-- 1 oracle oinstall 20979712 Jun 23 13:28 odm01.dbf
-rw-r----- 1 oracle oinstall 1536 Jun 23 12:06 orapwora9i
-rw-r----- 1 oracle oinstall 104858112 Jun 23 13:28 redo01.log
-rw-r----- 1 oracle oinstall 104858112 Jun 23 13:25 redo02.log
-rw-r----- 1 oracle oinstall 104858112 Jun 23 13:25 redo03.log
[oracle@test ora9i]$ rm redo0*
[oracle@test ora9i]$
[oracle@test ora9i]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on 6 23 13:30:53 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 235999648 bytes
Fixed Size 450976 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 17999986 generated at 06/23/2012 13:28:31 needed for thread 1
ORA-00289: suggestion : /u01/Oracle/oradata/ora9i/arch/1_77.dbf
ORA-00280: change 17999986 for thread 1 is in sequence #77
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
Database altered.
SQL>
阅读(1133) | 评论(0) | 转发(0) |
