用隐含参数强制打开了一个损坏的数据库！

SQL> recover database using backup controlfile;
ORA-00279: change 8432224659950 generated at 01/17/2010 19:27:30 needed for
thread 2
ORA-00289: suggestion : /oraarchive/RPTS/RPTS_T2_S50307_R627534239.dbf
ORA-00280: change 8432224659950 for thread 2 is in sequence #50307

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oradata4/RPTS/redo2/redo2_13.log
ORA-00279: change 8432224659950 generated at 01/17/2010 19:11:28 needed for
thread 1
ORA-00289: suggestion : /oraarchive/RPTS/RPTS_T1_S42412_R627534239.dbf
ORA-00280: change 8432224659950 for thread 1 is in sequence #42412

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
"/oradata1/RPTS/redo1/redo1_11.log "
ORA-00279: change 8432224659950 generated at 01/17/2010 19:19:40 needed for
thread 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oraredo3/RPTS/redo3_14.log
ORA-00328: archived log ends at change 8432223302787, need later change
8432224659950
ORA-00334: archived log: '/oraredo3/RPTS/redo3_14.log'

SQL> recover database using backup controlfile until scn 8432224659950;
ORA-00277: illegal option to the UNTIL recovery flag SCN

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 8432224659950 generated at 01/17/2010 19:27:30 needed for
thread 2
ORA-00289: suggestion : /oraarchive/RPTS/RPTS_T2_S50307_R627534239.dbf
ORA-00280: change 8432224659950 for thread 2 is in sequence #50307

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/oraarchive/RPTS/RPTS_T2_S50307_R627534239.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/oraarchive/RPTS/RPTS_T2_S50307_R627534239.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-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/RPTS/system01.dbf'

SQL> alter system set "_allow_resetlogs_corruption"=false scope=spfile;

System altered.

SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;

System altered.

SQL> shutdown imedaite
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1.0737E+10 bytes
Fixed Size 2047928 bytes
Variable Size 1493172296 bytes
Database Buffers 9227468800 bytes
Redo Buffers 14729216 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
$ ps -ef|grep ora_
oracle 16140 8069 0 03:40:53 pts/6 0:00 grep ora_
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jan 19 03:41:03 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1.0737E+10 bytes
Fixed Size 2047928 bytes
Variable Size 1493172296 bytes
Database Buffers 9227468800 bytes
Redo Buffers 14729216 bytes
SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /opt/app/oracle/product/10.2.0
/db_1/dbs/spfileRPTS3.ora
SQL> alter system set "_allow_resetlogs_corruption"=false scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1.0737E+10 bytes
Fixed Size 2047928 bytes
Variable Size 1493172296 bytes
Database Buffers 9227468800 bytes
Redo Buffers 14729216 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL>
SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
$