本文共 57650 字，大约阅读时间需要 192 分钟。
由于修改了隐含参数_DISABLE_LOGGING为TRUE：_disable_logging = TRUE 那么启动数据库后进行任何的操作，在关闭数据库后，就会发现数据库出现了损坏：
SQL> startupORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.ORA-19821: an intentionally corrupt log file was found
由于是将_disable_logging"=true造成的这个问题那么现在将_disable_logging"设置为false
SQL> alter system set "_disable_logging"=false scope=spfile;System altered.SQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.ORA-19821: an intentionally corrupt log file was found
还是报ORA-19821
由于错误提示是说日志文件有问题那么设置_allow_resetlogs_corruption来尝试恢复执行下面的sql语句来创建pfile参数文件
SQL>create pfile from spfile;
编辑/orac/orahome/11.2.0/db_1/dbs/spfiledbservice.ora
[root@gzybtest dbservice]vi /orac/orahome/11.2.0/db_1/dbs/spfiledbservice.oraSystem parameters with non-default values: processes = 150 memory_target = 12928M control_files = "/oradata/dbservice/control01.ctl" control_files = "/orac/flash_recovery_area/dbservice/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" _disable_logging = FALSE db_files = 500 db_recovery_file_dest = "/orac/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=dbserviceXDB)" audit_file_dest = "/orac/admin/dbservice/adump" audit_trail = "NONE" db_name = "dbservic" db_unique_name = "dbservice" open_cursors = 300 deferred_segment_creation= FALSE diagnostic_dest = "/orac"
然后使用pfile文件来启动实例
SQL> startup pfile=/orac/orahome/11.2.0/db_1/dbs/initdbservice.ora mountORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.SQL> recover database until cancel;ORA-00279: change 13480665044793 generated at 08/08/2013 16:36:47 needed forthread 1ORA-00289: suggestion :/orac/flash_recovery_area/DBSERVICE/archivelog/2013_08_08/o1_mf_1_1258_%u_.arcORA-00280: change 13480665044793 for thread 1 is in sequence #1258Specify log: {=suggested | filename | AUTO | CANCEL}ORA-00308: cannot open archived log'/orac/flash_recovery_area/DBSERVICE/archivelog/2013_08_08/o1_mf_1_1258_%u_.arc'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-10879: error signaled in parallel recovery slaveORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01194: file 1 needs more recovery to be consistentORA-01110: data file 1: '/oradata/dbservice/system01.dbf'SQL> recover datafile 1;ORA-00283: recovery session canceled due to errorsORA-01610: recovery using the BACKUP CONTROLFILE option must be doneSQL> alter database backup controlfile to trace;SQL> oradebug setmypid;SQL> oradebug TRACEFILE_NAME/orac/diag/rdbms/dbservice/dbservice/trace/dbservice_ora_6571.trc 找到跟踪文件中的
CREATE CONTROLFILE REUSE DATABASE "DBSERVIC" NORESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 800 MAXINSTANCES 8 MAXLOGHISTORY 2336LOGFILE GROUP 4 '/oradata/dbservice/redo04.log' SIZE 1000M BLOCKSIZE 512, GROUP 5 '/oradata/dbservice/redo05.log' SIZE 1000M BLOCKSIZE 512, GROUP 6 '/oradata/dbservice/redo07.log' SIZE 1000M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE '/oradata/dbservice/system01.dbf', '/oradata/dbservice/sysaux01.dbf', '/oradata/dbservice/undotbs01.dbf', '/oradata/dbservice/users01.dbf', '/oradata/dbservice/example01.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk01.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk02.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk03.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk04.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk05.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk06.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk07.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk08.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk09.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk10.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk11.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk12.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk13.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk14.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk15.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk16.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk17.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk18.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk19.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk20.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk21.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk22.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk23.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk24.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk25.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk26.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb01.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk01.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh01.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh02.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh03.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh04.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh05.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh06.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh07.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh08.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh09.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh10.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh11.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh12.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg01.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg02.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg03.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg04.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg05.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg06.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg07.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg08.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg09.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg10.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg11.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg12.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb02.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb03.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb04.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb05.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb06.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb07.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb08.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb09.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb10.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb11.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb12.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb13.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb14.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb15.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb16.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb17.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb18.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb19.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb20.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb21.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb22.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb23.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb24.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb25.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb26.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb27.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb28.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb29.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb30.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb31.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb32.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb33.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb34.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb35.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb36.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb37.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb38.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb39.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb40.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb41.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb42.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb43.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb44.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb45.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb46.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb47.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb48.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb49.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb50.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb51.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb52.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb53.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb54.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb55.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb56.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb57.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb58.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb59.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb60.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb61.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb62.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb63.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb64.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb65.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb66.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb67.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb68.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb69.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb70.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb71.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb72.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb73.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb74.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb75.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb76.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb77.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb78.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb79.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb80.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb81.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb82.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb83.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb84.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb85.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb86.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb87.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb88.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb89.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb90.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb91.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb92.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb93.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb94.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb95.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb96.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb97.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb98.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb99.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb100.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb101.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb102.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb103.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk02.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk03.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk04.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk05.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk06.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk07.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk08.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk09.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk10.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk11.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk12.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk13.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk14.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk15.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk16.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk17.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk18.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk19.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk20.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk21.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk22.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk23.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk24.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk25.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk26.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk27.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk28.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk29.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk30.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk31.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk32.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk33.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk34.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk35.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk36.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk37.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk38.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk39.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk40.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk41.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk42.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk43.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk44.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk45.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk46.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk47.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk48.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk49.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk50.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk51.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk52.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk53.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk54.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk55.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk56.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk57.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk58.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk59.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk60.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk61.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk62.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk63.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk64.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk65.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk66.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk67.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk68.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk69.dbf', '/oradata/dbservice/gzyb/gzyb01.dbf', '/oradata/dbservice/gzyb/gzyb02.dbf', '/oradata/dbservice/gzyb/gzyb03.dbf', '/oradata/dbservice/gzyb/gzyb04.dbf', '/oradata/dbservice/gzyb/gzyb05.dbf', '/oradata/dbservice/gzyb/gzyb06.dbf', '/oradata/dbservice/gzyb/gzyb07.dbf', '/oradata/dbservice/gzyb/gzyb08.dbf', '/oradata/dbservice/gzyb/gzyb09.dbf', '/oradata/dbservice/gzyb/gzyb10.dbf', '/oradata/dbservice/gzyb/gzyb11.dbf', '/oradata/dbservice/gzyb/gzyb12.dbf', '/oradata/dbservice/gzyb/gzyb13.dbf', '/oradata/dbservice/gzyb/gzyb14.dbf', '/oradata/dbservice/gzyb/gzyb15.dbf', '/oradata/dbservice/gzyb/gzyb16.dbf', '/oradata/dbservice/gzyb/gzyb17.dbf', '/oradata/dbservice/gzyb/gzyb18.dbf', '/oradata/dbservice/gzyb/gzyb19.dbf', '/oradata/dbservice/gzyb/gzyb20.dbf', '/oradata/dbservice/gzyb/gzyb21.dbf', '/oradata/dbservice/gzyb/gzyb22.dbf', '/oradata/dbservice/gzyb/gzyb23.dbf', '/oradata/dbservice/gzyb/gzyb24.dbf', '/oradata/dbservice/gzyb/gzyb25.dbf', '/oradata/dbservice/gzyb/gzyb26.dbf', '/oradata/dbservice/gzyb/gzyb27.dbf', '/oradata/dbservice/gzyb/gzyb28.dbf', '/oradata/dbservice/gzyb/gzyb29.dbf', '/oradata/dbservice/gzyb/gzyb30.dbf', '/oradata/dbservice/gzyb/gzyb31.dbf', '/oradata/dbservice/gzyb/gzyb32.dbf', '/oradata/dbservice/gzyb/gzyb33.dbf', '/oradata/dbservice/gzyb/gzyb34.dbf', '/oradata/dbservice/gzyb/gzyb35.dbf', '/oradata/dbservice/gzyb/gzyb36.dbf', '/oradata/dbservice/gzyb/gzyb37.dbf', '/oradata/dbservice/gzyb/gzyb38.dbf', '/oradata/dbservice/gzyb/gzyb39.dbf', '/oradata/dbservice/gzyb/gzyb40.dbf', '/oradata/dbservice/gzyb/gzyb41.dbf', '/oradata/dbservice/gzyb/gzyb42.dbf', '/oradata/dbservice/gzyb/gzyb43.dbf', '/oradata/dbservice/gzyb/gzyb44.dbf', '/oradata/dbservice/gzyb/gzyb45.dbf', '/oradata/dbservice/gzyb/gzyb46.dbf', '/oradata/dbservice/gzyb/gzyb47.dbf', '/oradata/dbservice/gzyb/gzyb48.dbf', '/oradata/dbservice/gzyb/gzyb49.dbf', '/oradata/dbservice/gzyb/gzyb50.dbf', '/oradata/dbservice/gzyb/gzyb51.dbf', '/oradata/dbservice/gzyb/gzyb52.dbf', '/oradata/dbservice/gzyb/gzyb53.dbf', '/oradata/dbservice/gzyb/gzyb54.dbf', '/oradata/dbservice/gzyb/gzyb55.dbf', '/oradata/dbservice/gzyb/gzyb56.dbf', '/oradata/dbservice/gzyb/gzyb57.dbf', '/oradata/dbservice/gzyb/gzyb58.dbf', '/oradata/dbservice/gzyb/gzyb59.dbf', '/oradata/dbservice/gzyb/gzyb60.dbf', '/oradata/dbservice/gzyb/gzyb61.dbf', '/oradata/dbservice/gzyb/gzyb62.dbf', '/oradata/dbservice/gzyb/gzyb63.dbf', '/oradata/dbservice/gzyb/gzyb64.dbf', '/oradata/dbservice/gzyb/gzyb65.dbf', '/oradata/dbservice/gzyb/gzyb66.dbf', '/oradata/dbservice/gzyb/gzyb67.dbf', '/oradata/dbservice/gzyb/gzyb68.dbf', '/oradata/dbservice/gzyb/gzyb69.dbf', '/oradata/dbservice/gzyb/gzyb70.dbf', '/oradata/dbservice/gzyb/gzyb71.dbf', '/oradata/dbservice/gzyb/gzyb72.dbf', '/oradata/dbservice/gzyb/gzyb73.dbf', '/oradata/dbservice/gzyb/gzyb74.dbf', '/oradata/dbservice/gzyb/gzyb75.dbf', '/oradata/dbservice/gzyb/gzyb76.dbf', '/oradata/dbservice/gzyb/gzyb77.dbf', '/oradata/dbservice/gzyb/gzyb78.dbf', '/oradata/dbservice/gzyb/gzyb79.dbf', '/oradata/dbservice/gzyb/gzyb80.dbf', '/oradata/dbservice/gzyb/gzyb81.dbf', '/oradata/dbservice/gzyb/gzyb82.dbf', '/oradata/dbservice/gzyb/gzyb83.dbf', '/oradata/dbservice/gzyb/gzyb84.dbf', '/oradata/dbservice/gzyb/gzyb85.dbf', '/oradata/dbservice/gzyb/gzyb86.dbf', '/oradata/dbservice/gzyb/gzyb87.dbf', '/oradata/dbservice/gzyb/gzyb88.dbf', '/oradata/dbservice/gzyb/gzyb89.dbf', '/oradata/dbservice/gzyb/gzyb90.dbf', '/oradata/dbservice/gzyb/gzyb91.dbf', '/oradata/dbservice/gzyb/gzyb92.dbf', '/oradata/dbservice/gzyb/gzyb93.dbf', '/oradata/dbservice/gzyb/gzyb94.dbf', '/oradata/dbservice/gzyb/gzyb95.dbf', '/oradata/dbservice/gzyb/gzyb96.dbf', '/oradata/dbservice/gzyb/gzyb97.dbf', '/oradata/dbservice/gzyb/gzyb98.dbf', '/oradata/dbservice/gzyb/gzyb99.dbf', '/oradata/dbservice/gzyb/gzyb100.dbf', '/oradata/dbservice/gzyb/gzyb101.dbf', '/oradata/dbservice/gzyb/gzyb102.dbf', '/oradata/dbservice/gzyb/gzyb103.dbf', '/oradata/dbservice/gzyb/gzyb104.dbf', '/oradata/dbservice/gzyb/gzyb105.dbf', '/oradata/dbservice/gzyb/gzyb106.dbf', '/oradata/dbservice/gzyb/gzyb107.dbf', '/oradata/dbservice/gzyb/gzyb108.dbf', '/oradata/dbservice/gzyb/gzyb109.dbf', '/oradata/dbservice/gzyb/gzyb110.dbf', '/oradata/dbservice/gzyb/gzyb111.dbf', '/oradata/dbservice/gzyb/gzyb112.dbf', '/oradata/dbservice/gzyb/gzyb113.dbf', '/oradata/dbservice/gzyb/gzyb114.dbf', '/oradata/dbservice/gzyb/gzyb115.dbf', '/oradata/dbservice/gzyb/gzyb116.dbf', '/oradata/dbservice/gzyb/gzyb117.dbf', '/oradata/dbservice/gzyb/gzyb118.dbf', '/oradata/dbservice/gzyb/gzyb119.dbf', '/oradata/dbservice/gzyb/gzyb120.dbf', '/oradata/dbservice/gzyb/gzyb121.dbf', '/oradata/dbservice/gzyb/gzyb122.dbf', '/oradata/dbservice/gzyb/gzyb123.dbf', '/oradata/dbservice/gzyb/gzyb124.dbf', '/oradata/dbservice/gzyb/gzyb125.dbf', '/oradata/dbservice/gzyb/gzyb126.dbf', '/oradata/dbservice/gzyb/gzyb127.dbf', '/oradata/dbservice/gzyb/gzyb128.dbf', '/oradata/dbservice/gzyb/gzyb129.dbf', '/oradata/dbservice/gzyb/gzyb130.dbf', '/oradata/dbservice/gzyb/gzyb131.dbf', '/oradata/dbservice/gzyb/gzyb132.dbf', '/oradata/dbservice/gzyb/gzyb133.dbf', '/oradata/dbservice/gzyb/gzyb134.dbf', '/oradata/dbservice/gzyb/gzyb135.dbf', '/oradata/dbservice/gzyb/gzyb136.dbf', '/oradata/dbservice/gzyb/gzyb137.dbf', '/oradata/dbservice/gzyb/gzyb138.dbf', '/oradata/dbservice/gzyb/gzyb139.dbf', '/oradata/dbservice/gzyb/gzyb140.dbf', '/oradata/dbservice/gzyb/gzyb141.dbf', '/oradata/dbservice/gzyb/gzyb142.dbf', '/oradata/dbservice/gzyb/gzyb143.dbf', '/oradata/dbservice/gzyb/gzyb144.dbf', '/oradata/dbservice/gzyb/gzyb145.dbf', '/oradata/dbservice/gzyb/gzyb146.dbf', '/oradata/dbservice/gzyb/gzyb147.dbf', '/oradata/dbservice/gzyb/gzyb148.dbf', '/oradata/dbservice/gzyb/gzyb149.dbf', '/oradata/dbservice/gzyb/gzyb150.dbf', '/oradata/dbservice/gzyb/gzyb151.dbf', '/oradata/dbservice/gzyb/gzyb152.dbf', '/oradata/dbservice/gzyb/gzyb153.dbf', '/oradata/dbservice/gzyb/gzyb154.dbf', '/oradata/dbservice/gzyb/gzyb155.dbf', '/oradata/dbservice/gzyb/gzyb156.dbf', '/oradata/dbservice/gzyb/gzyb157.dbf', '/oradata/dbservice/gzyb/gzyb158.dbf', '/oradata/dbservice/gzyb/gzyb159.dbf', '/oradata/dbservice/gzyb/gzyb160.dbf', '/oradata/dbservice/gzyb/gzyb161.dbf', '/oradata/dbservice/gzyb/gzyb162.dbf', '/oradata/dbservice/gzyb/gzyb163.dbf', '/oradata/dbservice/gzyb/gzyb164.dbf', '/oradata/dbservice/gzyb/gzyb165.dbf', '/oradata/dbservice/gzyb/gzyb166.dbf', '/oradata/dbservice/gzyb/gzyb167.dbf', '/oradata/dbservice/gzyb/gzyb168.dbf', '/oradata/dbservice/gzyb/gzyb169.dbf', '/oradata/dbservice/gzyb/gzyb170.dbf', '/oradata/dbservice/gzyb/gzyb171.dbf', '/oradata/dbservice/gzyb/gzyb172.dbf', '/oradata/dbservice/gzyb/gzyb173.dbf', '/oradata/dbservice/gzyb/gzyb174.dbf', '/oradata/dbservice/gzyb/gzyb175.dbf', '/oradata/dbservice/gzyb/gzyb176.dbf', '/oradata/dbservice/gzyb/gzyb177.dbf', '/oradata/dbservice/gzyb/gzyb178.dbf', '/oradata/dbservice/gzyb/gzyb179.dbf', '/oradata/dbservice/gzyb/gzyb180.dbf', '/oradata/dbservice/gzyb/gzyb181.dbf', '/oradata/dbservice/gzyb/gzyb182.dbf', '/oradata/dbservice/gzyb/gzyb183.dbf', '/oradata/dbservice/gzyb/gzyb184.dbf', '/oradata/dbservice/gzyb/gzyb185.dbf', '/oradata/dbservice/gzyb/gzyb186.dbf', '/oradata/dbservice/gzyb/gzyb187.dbf', '/oradata/dbservice/gzyb/gzyb188.dbf', '/oradata/dbservice/gzyb/gzyb189.dbf', '/oradata/dbservice/gzyb/gzyb190.dbf', '/oradata/dbservice/gzyb/gzyb191.dbf', '/oradata/dbservice/gzyb/gzyb192.dbf', '/oradata/dbservice/gzyb/gzyb193.dbf', '/oradata/dbservice/gzyb/gzyb194.dbf', '/oradata/dbservice/gzyb/gzyb195.dbf', '/oradata/dbservice/gzyb/gzyb196.dbf', '/oradata/dbservice/gzyb/gzyb197.dbf', '/oradata/dbservice/gzyb/gzyb198.dbf', '/oradata/dbservice/gzyb/gzyb199.dbf', '/oradata/dbservice/gzyb/gzyb200.dbf', '/oradata/dbservice/gzyb_sy.dbf'CHARACTER SET ZHS16GBK;
来创建控制文件,在创建新的控制文件前记得在操作系统级别来执行rm来删除原来的控制文件
SQL> startup nomountORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesSQL>CREATE CONTROLFILE REUSE DATABASE "DBSERVIC" NORESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 800 MAXINSTANCES 8 MAXLOGHISTORY 2336LOGFILE GROUP 4 '/oradata/dbservice/redo04.log' SIZE 1000M BLOCKSIZE 512, GROUP 5 '/oradata/dbservice/redo05.log' SIZE 1000M BLOCKSIZE 512, GROUP 6 '/oradata/dbservice/redo07.log' SIZE 1000M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE '/oradata/dbservice/system01.dbf', '/oradata/dbservice/sysaux01.dbf', '/oradata/dbservice/undotbs01.dbf', '/oradata/dbservice/users01.dbf', '/oradata/dbservice/example01.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk01.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk02.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk03.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk04.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk05.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk06.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk07.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk08.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk09.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk10.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk11.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk12.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk13.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk14.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk15.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk16.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk17.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk18.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk19.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk20.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk21.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk22.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk23.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk24.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk25.dbf', '/oradata/dbservice/sicp3_bbk/sicp3_bbk26.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb01.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk01.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh01.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh02.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh03.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh04.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh05.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh06.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh07.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh08.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh09.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh10.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh11.dbf', '/oradata/dbservice/sicp3_ybjh/sicp3_ybjh12.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg01.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg02.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg03.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg04.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg05.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg06.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg07.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg08.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg09.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg10.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg11.dbf', '/oradata/dbservice/sicp3_ydjg/sicp3_ydjg12.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb02.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb03.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb04.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb05.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb06.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb07.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb08.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb09.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb10.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb11.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb12.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb13.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb14.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb15.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb16.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb17.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb18.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb19.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb20.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb21.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb22.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb23.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb24.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb25.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb26.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb27.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb28.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb29.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb30.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb31.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb32.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb33.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb34.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb35.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb36.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb37.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb38.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb39.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb40.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb41.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb42.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb43.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb44.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb45.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb46.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb47.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb48.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb49.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb50.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb51.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb52.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb53.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb54.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb55.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb56.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb57.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb58.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb59.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb60.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb61.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb62.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb63.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb64.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb65.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb66.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb67.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb68.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb69.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb70.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb71.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb72.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb73.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb74.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb75.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb76.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb77.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb78.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb79.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb80.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb81.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb82.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb83.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb84.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb85.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb86.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb87.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb88.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb89.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb90.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb91.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb92.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb93.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb94.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb95.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb96.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb97.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb98.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb99.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb100.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb101.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb102.dbf', '/oradata/dbservice/sicp3_gzyb/sicp3_gzyb103.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk02.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk03.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk04.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk05.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk06.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk07.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk08.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk09.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk10.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk11.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk12.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk13.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk14.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk15.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk16.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk17.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk18.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk19.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk20.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk21.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk22.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk23.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk24.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk25.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk26.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk27.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk28.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk29.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk30.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk31.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk32.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk33.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk34.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk35.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk36.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk37.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk38.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk39.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk40.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk41.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk42.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk43.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk44.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk45.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk46.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk47.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk48.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk49.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk50.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk51.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk52.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk53.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk54.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk55.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk56.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk57.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk58.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk59.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk60.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk61.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk62.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk63.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk64.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk65.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk66.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk67.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk68.dbf', '/oradata/dbservice/sicp3_ybnk/sicp3_ybnk69.dbf', '/oradata/dbservice/gzyb/gzyb01.dbf', '/oradata/dbservice/gzyb/gzyb02.dbf', '/oradata/dbservice/gzyb/gzyb03.dbf', '/oradata/dbservice/gzyb/gzyb04.dbf', '/oradata/dbservice/gzyb/gzyb05.dbf', '/oradata/dbservice/gzyb/gzyb06.dbf', '/oradata/dbservice/gzyb/gzyb07.dbf', '/oradata/dbservice/gzyb/gzyb08.dbf', '/oradata/dbservice/gzyb/gzyb09.dbf', '/oradata/dbservice/gzyb/gzyb10.dbf', '/oradata/dbservice/gzyb/gzyb11.dbf', '/oradata/dbservice/gzyb/gzyb12.dbf', '/oradata/dbservice/gzyb/gzyb13.dbf', '/oradata/dbservice/gzyb/gzyb14.dbf', '/oradata/dbservice/gzyb/gzyb15.dbf', '/oradata/dbservice/gzyb/gzyb16.dbf', '/oradata/dbservice/gzyb/gzyb17.dbf', '/oradata/dbservice/gzyb/gzyb18.dbf', '/oradata/dbservice/gzyb/gzyb19.dbf', '/oradata/dbservice/gzyb/gzyb20.dbf', '/oradata/dbservice/gzyb/gzyb21.dbf', '/oradata/dbservice/gzyb/gzyb22.dbf', '/oradata/dbservice/gzyb/gzyb23.dbf', '/oradata/dbservice/gzyb/gzyb24.dbf', '/oradata/dbservice/gzyb/gzyb25.dbf', '/oradata/dbservice/gzyb/gzyb26.dbf', '/oradata/dbservice/gzyb/gzyb27.dbf', '/oradata/dbservice/gzyb/gzyb28.dbf', '/oradata/dbservice/gzyb/gzyb29.dbf', '/oradata/dbservice/gzyb/gzyb30.dbf', '/oradata/dbservice/gzyb/gzyb31.dbf', '/oradata/dbservice/gzyb/gzyb32.dbf', '/oradata/dbservice/gzyb/gzyb33.dbf', '/oradata/dbservice/gzyb/gzyb34.dbf', '/oradata/dbservice/gzyb/gzyb35.dbf', '/oradata/dbservice/gzyb/gzyb36.dbf', '/oradata/dbservice/gzyb/gzyb37.dbf', '/oradata/dbservice/gzyb/gzyb38.dbf', '/oradata/dbservice/gzyb/gzyb39.dbf', '/oradata/dbservice/gzyb/gzyb40.dbf', '/oradata/dbservice/gzyb/gzyb41.dbf', '/oradata/dbservice/gzyb/gzyb42.dbf', '/oradata/dbservice/gzyb/gzyb43.dbf', '/oradata/dbservice/gzyb/gzyb44.dbf', '/oradata/dbservice/gzyb/gzyb45.dbf', '/oradata/dbservice/gzyb/gzyb46.dbf', '/oradata/dbservice/gzyb/gzyb47.dbf', '/oradata/dbservice/gzyb/gzyb48.dbf', '/oradata/dbservice/gzyb/gzyb49.dbf', '/oradata/dbservice/gzyb/gzyb50.dbf', '/oradata/dbservice/gzyb/gzyb51.dbf', '/oradata/dbservice/gzyb/gzyb52.dbf', '/oradata/dbservice/gzyb/gzyb53.dbf', '/oradata/dbservice/gzyb/gzyb54.dbf', '/oradata/dbservice/gzyb/gzyb55.dbf', '/oradata/dbservice/gzyb/gzyb56.dbf', '/oradata/dbservice/gzyb/gzyb57.dbf', '/oradata/dbservice/gzyb/gzyb58.dbf', '/oradata/dbservice/gzyb/gzyb59.dbf', '/oradata/dbservice/gzyb/gzyb60.dbf', '/oradata/dbservice/gzyb/gzyb61.dbf', '/oradata/dbservice/gzyb/gzyb62.dbf', '/oradata/dbservice/gzyb/gzyb63.dbf', '/oradata/dbservice/gzyb/gzyb64.dbf', '/oradata/dbservice/gzyb/gzyb65.dbf', '/oradata/dbservice/gzyb/gzyb66.dbf', '/oradata/dbservice/gzyb/gzyb67.dbf', '/oradata/dbservice/gzyb/gzyb68.dbf', '/oradata/dbservice/gzyb/gzyb69.dbf', '/oradata/dbservice/gzyb/gzyb70.dbf', '/oradata/dbservice/gzyb/gzyb71.dbf', '/oradata/dbservice/gzyb/gzyb72.dbf', '/oradata/dbservice/gzyb/gzyb73.dbf', '/oradata/dbservice/gzyb/gzyb74.dbf', '/oradata/dbservice/gzyb/gzyb75.dbf', '/oradata/dbservice/gzyb/gzyb76.dbf', '/oradata/dbservice/gzyb/gzyb77.dbf', '/oradata/dbservice/gzyb/gzyb78.dbf', '/oradata/dbservice/gzyb/gzyb79.dbf', '/oradata/dbservice/gzyb/gzyb80.dbf', '/oradata/dbservice/gzyb/gzyb81.dbf', '/oradata/dbservice/gzyb/gzyb82.dbf', '/oradata/dbservice/gzyb/gzyb83.dbf', '/oradata/dbservice/gzyb/gzyb84.dbf', '/oradata/dbservice/gzyb/gzyb85.dbf', '/oradata/dbservice/gzyb/gzyb86.dbf', '/oradata/dbservice/gzyb/gzyb87.dbf', '/oradata/dbservice/gzyb/gzyb88.dbf', '/oradata/dbservice/gzyb/gzyb89.dbf', '/oradata/dbservice/gzyb/gzyb90.dbf', '/oradata/dbservice/gzyb/gzyb91.dbf', '/oradata/dbservice/gzyb/gzyb92.dbf', '/oradata/dbservice/gzyb/gzyb93.dbf', '/oradata/dbservice/gzyb/gzyb94.dbf', '/oradata/dbservice/gzyb/gzyb95.dbf', '/oradata/dbservice/gzyb/gzyb96.dbf', '/oradata/dbservice/gzyb/gzyb97.dbf', '/oradata/dbservice/gzyb/gzyb98.dbf', '/oradata/dbservice/gzyb/gzyb99.dbf', '/oradata/dbservice/gzyb/gzyb100.dbf', '/oradata/dbservice/gzyb/gzyb101.dbf', '/oradata/dbservice/gzyb/gzyb102.dbf', '/oradata/dbservice/gzyb/gzyb103.dbf', '/oradata/dbservice/gzyb/gzyb104.dbf', '/oradata/dbservice/gzyb/gzyb105.dbf', '/oradata/dbservice/gzyb/gzyb106.dbf', '/oradata/dbservice/gzyb/gzyb107.dbf', '/oradata/dbservice/gzyb/gzyb108.dbf', '/oradata/dbservice/gzyb/gzyb109.dbf', '/oradata/dbservice/gzyb/gzyb110.dbf', '/oradata/dbservice/gzyb/gzyb111.dbf', '/oradata/dbservice/gzyb/gzyb112.dbf', '/oradata/dbservice/gzyb/gzyb113.dbf', '/oradata/dbservice/gzyb/gzyb114.dbf', '/oradata/dbservice/gzyb/gzyb115.dbf', '/oradata/dbservice/gzyb/gzyb116.dbf', '/oradata/dbservice/gzyb/gzyb117.dbf', '/oradata/dbservice/gzyb/gzyb118.dbf', '/oradata/dbservice/gzyb/gzyb119.dbf', '/oradata/dbservice/gzyb/gzyb120.dbf', '/oradata/dbservice/gzyb/gzyb121.dbf', '/oradata/dbservice/gzyb/gzyb122.dbf', '/oradata/dbservice/gzyb/gzyb123.dbf', '/oradata/dbservice/gzyb/gzyb124.dbf', '/oradata/dbservice/gzyb/gzyb125.dbf', '/oradata/dbservice/gzyb/gzyb126.dbf', '/oradata/dbservice/gzyb/gzyb127.dbf', '/oradata/dbservice/gzyb/gzyb128.dbf', '/oradata/dbservice/gzyb/gzyb129.dbf', '/oradata/dbservice/gzyb/gzyb130.dbf', '/oradata/dbservice/gzyb/gzyb131.dbf', '/oradata/dbservice/gzyb/gzyb132.dbf', '/oradata/dbservice/gzyb/gzyb133.dbf', '/oradata/dbservice/gzyb/gzyb134.dbf', '/oradata/dbservice/gzyb/gzyb135.dbf', '/oradata/dbservice/gzyb/gzyb136.dbf', '/oradata/dbservice/gzyb/gzyb137.dbf', '/oradata/dbservice/gzyb/gzyb138.dbf', '/oradata/dbservice/gzyb/gzyb139.dbf', '/oradata/dbservice/gzyb/gzyb140.dbf', '/oradata/dbservice/gzyb/gzyb141.dbf', '/oradata/dbservice/gzyb/gzyb142.dbf', '/oradata/dbservice/gzyb/gzyb143.dbf', '/oradata/dbservice/gzyb/gzyb144.dbf', '/oradata/dbservice/gzyb/gzyb145.dbf', '/oradata/dbservice/gzyb/gzyb146.dbf', '/oradata/dbservice/gzyb/gzyb147.dbf', '/oradata/dbservice/gzyb/gzyb148.dbf', '/oradata/dbservice/gzyb/gzyb149.dbf', '/oradata/dbservice/gzyb/gzyb150.dbf', '/oradata/dbservice/gzyb/gzyb151.dbf', '/oradata/dbservice/gzyb/gzyb152.dbf', '/oradata/dbservice/gzyb/gzyb153.dbf', '/oradata/dbservice/gzyb/gzyb154.dbf', '/oradata/dbservice/gzyb/gzyb155.dbf', '/oradata/dbservice/gzyb/gzyb156.dbf', '/oradata/dbservice/gzyb/gzyb157.dbf', '/oradata/dbservice/gzyb/gzyb158.dbf', '/oradata/dbservice/gzyb/gzyb159.dbf', '/oradata/dbservice/gzyb/gzyb160.dbf', '/oradata/dbservice/gzyb/gzyb161.dbf', '/oradata/dbservice/gzyb/gzyb162.dbf', '/oradata/dbservice/gzyb/gzyb163.dbf', '/oradata/dbservice/gzyb/gzyb164.dbf', '/oradata/dbservice/gzyb/gzyb165.dbf', '/oradata/dbservice/gzyb/gzyb166.dbf', '/oradata/dbservice/gzyb/gzyb167.dbf', '/oradata/dbservice/gzyb/gzyb168.dbf', '/oradata/dbservice/gzyb/gzyb169.dbf', '/oradata/dbservice/gzyb/gzyb170.dbf', '/oradata/dbservice/gzyb/gzyb171.dbf', '/oradata/dbservice/gzyb/gzyb172.dbf', '/oradata/dbservice/gzyb/gzyb173.dbf', '/oradata/dbservice/gzyb/gzyb174.dbf', '/oradata/dbservice/gzyb/gzyb175.dbf', '/oradata/dbservice/gzyb/gzyb176.dbf', '/oradata/dbservice/gzyb/gzyb177.dbf', '/oradata/dbservice/gzyb/gzyb178.dbf', '/oradata/dbservice/gzyb/gzyb179.dbf', '/oradata/dbservice/gzyb/gzyb180.dbf', '/oradata/dbservice/gzyb/gzyb181.dbf', '/oradata/dbservice/gzyb/gzyb182.dbf', '/oradata/dbservice/gzyb/gzyb183.dbf', '/oradata/dbservice/gzyb/gzyb184.dbf', '/oradata/dbservice/gzyb/gzyb185.dbf', '/oradata/dbservice/gzyb/gzyb186.dbf', '/oradata/dbservice/gzyb/gzyb187.dbf', '/oradata/dbservice/gzyb/gzyb188.dbf', '/oradata/dbservice/gzyb/gzyb189.dbf', '/oradata/dbservice/gzyb/gzyb190.dbf', '/oradata/dbservice/gzyb/gzyb191.dbf', '/oradata/dbservice/gzyb/gzyb192.dbf', '/oradata/dbservice/gzyb/gzyb193.dbf', '/oradata/dbservice/gzyb/gzyb194.dbf', '/oradata/dbservice/gzyb/gzyb195.dbf', '/oradata/dbservice/gzyb/gzyb196.dbf', '/oradata/dbservice/gzyb/gzyb197.dbf', '/oradata/dbservice/gzyb/gzyb198.dbf', '/oradata/dbservice/gzyb/gzyb199.dbf', '/oradata/dbservice/gzyb/gzyb200.dbf', '/oradata/dbservice/gzyb_sy.dbf'CHARACTER SET ZHS16GBK;SQL>recover database;Media Recovery Complete SQL> alter database open;alter database openSQL> alter database open ERROR at line 1:ORA-01194: file 1 needs more recovery to be consistentORA-01110: data file 1: '/oradata/dbservice/system01.dbf'
打开数据库还是报错检查alert_dbservice.log文件发现
Errors in file /orac/diag/rdbms/dbservice/dbservice/trace/dbservice_ora_5247.trc (incident=24161):ORA-00600: internal error code, arguments: [2662], [3138], [3057689962], [3138], [3057697443], [12583040], [], [], [], [], [], []Incident details in: /orac/diag/rdbms/dbservice/dbservice/incident/incdir_24161/dbservice_ora_5247_i24161.trcErrors in file /orac/diag/rdbms/dbservice/dbservice/trace/dbservice_ora_5247.trc:ORA-00600: internal error code, arguments: [2662], [3138], [3057689962], [3138], [3057697443], [12583040], [], [], [], [], [], []Errors in file /orac/diag/rdbms/dbservice/dbservice/trace/dbservice_ora_5247.trc:ORA-00600: internal error code, arguments: [2662], [3138], [3057689962], [3138], [3057697443], [12583040], [], [], [], [], [], []Error 600 happened during db open, shutting down database
得到的信息有限，只能看到是严重内部错误，剩下的都是内存堆栈的一堆信息，于是查找了一下这个错误的具体相关信息。ORA-600 [2662] "Block SCN is ahead of Current SCN"，说明当前数据库的数据块的SCN早于当前的SCN，主要是和存储在UGA变量中的dependent SCN进行比较，如果当前的SCN小于它，数据库就会产生这个ORA-600 [2662]的错误了。这个错误一共有五个参
数，分别代表不同的含义，
ORA-600 [2662] [a] [b] [c] [d] [e]
Arg [a] Current SCN WRAP
Arg [b] Current SCN BASE
Arg [c] dependent SCN WRAP
Arg [d] dependent SCN BASE
Arg [e] Where present this is the DBA where the dependent SCN came from.
我们分析错误中的提示，它的参数b=3057689962,d=3057697443,表明当前的SCN确实是小于dependent SCN，所以产生了这个600的错误。
通过查阅文档，发现这个错误的产生原因主要有以下几条：
1.使用隐含参数_ALLOW_RESETLOGS_CORRUPTION后resetlogs打开数据库
2.硬件错误引起数据库没法写控制文件和重做日志文件
3.错误的部分恢复数据库
4.恢复了控制文件但是没有使用recover database using backup controlfile进行恢复
5.数据库crash后设置了_DISABLE_LOGGING隐含参数
6.在并行服务器环境中DLM存在问题
仔细对比了一下，发现问题可能是由于第一条产生的，由于设置了_ALLOW_RESETLOGS_CORRUPTION这个隐含参数后，虽然强制性的打开数据库，但是数据库本身存在了corruption，仍然存在严重的问题。于是想到使用ADJUST_SCN事件来调整当前的SCN，使其大于dependent SCN，然后保证数据库可以全库的导出，然后重建数据库导入数据。执行：
alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1';
SQL> startup pfile=/orac/orahome/11.2.0/db_1/dbs/initdbservice.ora mountORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.SQL>recover database;Media Recovery Complete SQL> alter session set events '10015 trace name adjust_scn level 1';Session altered.SQL> alter database open;ERROR at line 1:ORA-01194: file 1 needs more recovery to be consistentORA-01110: data file 1: '/oradata/dbservice/system01.dbf'
检查alert_dbservice.log文件发现
No Resource Manager plan activeErrors in file /orac/diag/rdbms/dbservice/dbservice/trace/dbservice_ora_5571.trc (incident=25369):ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
说明：600-[4000]到[5000]的错误都是和rollback 相关的
可以先使用手功管理的回滚表空间的方式将数据库打开
设置如下参数
undo_tablespace='SYSTEM'
undo_management='MANUAL'
[root@gzybtest dbservice]# vi /orac/orahome/11.2.0/db_1/dbs/initdbservice.oradbservice.__db_cache_size=7583301632dbservice.__java_pool_size=67108864dbservice.__large_pool_size=67108864dbservice.__oracle_base='/orac'#ORACLE_BASE set from environmentdbservice.__pga_aggregate_target=4764729344dbservice.__sga_target=8791261184dbservice.__shared_io_pool_size=0dbservice.__shared_pool_size=872415232dbservice.__streams_pool_size=67108864*._allow_resetlogs_corruption=TRUE*._disable_logging=FALSE*.audit_file_dest='/orac/admin/dbservice/adump'*.audit_trail='none'*.compatible='11.2.0.0.0'*.control_files='/oradata/dbservice/control01.ctl','/orac/flash_recovery_area/dbservice/control02.ctl'*.db_block_size=8192*.db_domain=''*.db_files=500*.db_name='dbservic'*.db_recovery_file_dest='/orac/flash_recovery_area'*.db_recovery_file_dest_size=4070572032*.db_unique_name='dbservice'*.deferred_segment_creation=FALSE*.diagnostic_dest='/orac'*.dispatchers='(PROTOCOL=TCP) (SERVICE=dbserviceXDB)'*.memory_target=13501464576*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'undo_tablespace='SYSTEM'undo_management='MANUAL'SQL> startup pfile=/orac/orahome/11.2.0/db_1/dbs/initdbservice.oraORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.Database opened.
接下来创建新的undo表空间并修改initdbservice.ora文件的undo表空间相关的参数
SQL> create undo tablespace undotbs02 datafile '/oradata/dbservice/undotbs02.dbf' size 500M;Tablespace created.[root@gzybtest dbservice]# vi /orac/orahome/11.2.0/db_1/dbs/initdbservice.oradbservice.__db_cache_size=7583301632dbservice.__java_pool_size=67108864dbservice.__large_pool_size=67108864dbservice.__oracle_base='/orac'#ORACLE_BASE set from environmentdbservice.__pga_aggregate_target=4764729344dbservice.__sga_target=8791261184dbservice.__shared_io_pool_size=0dbservice.__shared_pool_size=872415232dbservice.__streams_pool_size=67108864*._allow_resetlogs_corruption=TRUE*._disable_logging=FALSE*.audit_file_dest='/orac/admin/dbservice/adump'*.audit_trail='none'*.compatible='11.2.0.0.0'*.control_files='/oradata/dbservice/control01.ctl','/orac/flash_recovery_area/dbservice/control02.ctl'*.db_block_size=8192*.db_domain=''*.db_files=500*.db_name='dbservic'*.db_recovery_file_dest='/orac/flash_recovery_area'*.db_recovery_file_dest_size=4070572032*.db_unique_name='dbservice'*.deferred_segment_creation=FALSE*.diagnostic_dest='/orac'*.dispatchers='(PROTOCOL=TCP) (SERVICE=dbserviceXDB)'*.memory_target=13501464576*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'undo_tablespace='undotbs02'undo_management='AUTO'SQL> startup pfile=/orac/orahome/11.2.0/db_1/dbs/initdbservice.oraORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.Database opened.SQL> show parameter undoNAME TYPE VALUE------------------------------------ ----------- ------------------------------undo_management string AUTOundo_retention integer 900undo_tablespace string undotbs02SQL> create spfile from pfile;File created.
使用spfile参数文件来启动数据库
SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.Database opened.
数据库打开了,本以为搞定了数据库的恢复但是过了一分钟连接数据库进行操作时报错
SQL> ALTER DATABASE DATAFILE '/oradata/dbservice/undotbs01.dbf' OFFLINE DROP;ALTER DATABASE DATAFILE '/oradata/dbservice/undotbs01.dbf' OFFLINE DROP*ERROR at line 1:ORA-03135: connection lost contactProcess ID: 8532Session ID: 96 Serial number: 3
检查alert_dbservice.log文件发现
Errors in file /orac/diag/rdbms/dbservice/dbservice/trace/dbservice_smon_7186.trc (incident=32527):ORA-00600: internal error code, arguments: [4137], [2.18.4491], [0], [0], [], [], [], [], [], [], [], []Thu Aug 08 23:14:00 2013
错误原因:
_smon_internal_errlimit(limit of SMON internal errors) SMON遇到了内部错误，最大允许100次，不断计数增长,达到100的时候,数据库smon进程自动down掉,从而导致数据库down
解决办法:
1.临时解决办法:设置_smon_internal_errlimit一个较大值
2.根本解决办法:使用undo隐含参数,删除有问题undo 回滚段和undo表空间或者使用10513 事件
我这里选择删除有问题的undo表空间
SQL> drop tablespace UNDOTBS1 including contents and datafiles;drop tablespace UNDOTBS1 including contents and datafiles*ERROR at line 1:ORA-01548: active rollback segment '_SYSSMU3_2097677531$' found, terminatedropping tablespace
执行下面的查询来看undotbs1表空间的回滚段
SQL> SELECT SEGMENT_NAME, OWNER, TABLESPACE_NAME, STATUS FROM DBA_ROLLBACK_SEGS;SEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------SYSTEM SYS SYSTEMONLINE_SYSSMU13_2246115931$ PUBLIC UNDOTBS1OFFLINE_SYSSMU12_1541645018$ PUBLIC UNDOTBS1NEEDS RECOVERYSEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU11_1259892418$ PUBLIC UNDOTBS1OFFLINE_SYSSMU10_3550978943$ PUBLIC UNDOTBS1OFFLINE_SYSSMU9_1424341975$ PUBLIC UNDOTBS1OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU8_2012382730$ PUBLIC UNDOTBS1OFFLINE_SYSSMU7_3286610060$ PUBLIC UNDOTBS1OFFLINE_SYSSMU6_2443381498$ PUBLIC UNDOTBS1OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU5_1527469038$ PUBLIC UNDOTBS1OFFLINE_SYSSMU4_1152005954$ PUBLIC UNDOTBS1OFFLINE_SYSSMU3_2097677531$ PUBLIC UNDOTBS1NEEDS RECOVERYSEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU37_1815119680$ PUBLIC UNDOTBS02OFFLINE_SYSSMU36_3725248445$ PUBLIC UNDOTBS02OFFLINE_SYSSMU35_2892765787$ PUBLIC UNDOTBS02OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU34_2695217521$ PUBLIC UNDOTBS02OFFLINE_SYSSMU33_1797432692$ PUBLIC UNDOTBS02OFFLINE_SYSSMU32_1653795157$ PUBLIC UNDOTBS02OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU31_1105695367$ PUBLIC UNDOTBS02OFFLINE_SYSSMU30_424248798$ PUBLIC UNDOTBS02OFFLINE_SYSSMU29_778801568$ PUBLIC UNDOTBS02OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU28_2939988898$ PUBLIC UNDOTBS02OFFLINE_SYSSMU27_220897705$ PUBLIC UNDOTBS02OFFLINE_SYSSMU26_153095121$ PUBLIC UNDOTBS02OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU25_193585708$ PUBLIC UNDOTBS02OFFLINE_SYSSMU24_3014414866$ PUBLIC UNDOTBS02OFFLINE_SYSSMU23_2910579661$ PUBLIC UNDOTBS02OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU22_2488176863$ PUBLIC UNDOTBS02OFFLINE_SYSSMU21_1905929509$ PUBLIC UNDOTBS02OFFLINE_SYSSMU20_3032273491$ PUBLIC UNDOTBS02OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU19_2000855474$ PUBLIC UNDOTBS02OFFLINE_SYSSMU18_729116992$ PUBLIC UNDOTBS02OFFLINE_SYSSMU17_388387478$ PUBLIC UNDOTBS02OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME------------------------------ ------ ------------------------------STATUS----------------_SYSSMU16_241755401$ PUBLIC UNDOTBS02OFFLINE_SYSSMU15_1810545622$ PUBLIC UNDOTBS02OFFLINE_SYSSMU14_714084753$ PUBLIC UNDOTBS02OFFLINE[root@gzybtest admin]# vi /orac/orahome/11.2.0/db_1/dbs/initdbservice.oradbservice.__db_cache_size=7583301632dbservice.__java_pool_size=67108864dbservice.__large_pool_size=67108864dbservice.__oracle_base='/orac'#ORACLE_BASE set from environmentdbservice.__pga_aggregate_target=4764729344dbservice.__sga_target=8791261184dbservice.__shared_io_pool_size=0dbservice.__shared_pool_size=872415232dbservice.__streams_pool_size=67108864*._allow_resetlogs_corruption=TRUE*._disable_logging=FALSE*.audit_file_dest='/orac/admin/dbservice/adump'*.audit_trail='none'*.compatible='11.2.0.0.0'*.control_files='/oradata/dbservice/control01.ctl','/orac/flash_recovery_area/dbservice/control02.ctl'*.db_block_size=8192*.db_domain=''*.db_files=500*.db_name='dbservic'*.db_recovery_file_dest='/orac/flash_recovery_area'*.db_recovery_file_dest_size=4070572032*.db_unique_name='dbservice'*.deferred_segment_creation=FALSE*.diagnostic_dest='/orac'*.dispatchers='(PROTOCOL=TCP) (SERVICE=dbserviceXDB)'*.memory_target=13501464576*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.undo_management='MANUAL'*.undo_tablespace='undotbs02'_CORRUPTED_ROLLBACK_SEGMENTS = (_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,_SYSSMU9$,_SYSSMU10$,_SYSSMU11$,_SYSSMU12$,_SYSSMU13$,_SYSSMU14$,_SYSSMU15$,_SYSSMU16$,_SYSSMU17$,_SYSSMU18$,_SYSSMU19$,_SYSSMU20$,_SYSSMU2_2232571081$,_SYSSMU3_2097677531$,_SYSSMU4_1152005954$,_SYSSMU5_1527469038$,_SYSSMU6_2443381498$,_SYSSMU7_3286610060$,_SYSSMU8_2012382730$,_SYSSMU9_1424341975$,_SYSSMU10_3550978943$,_SYSSMU11_1259892418$,_SYSSMU12_1541645018$,_SYSSMU13_2246115931$)~~~~"/orac/orahome/11.2.0/db_1/dbs/initdbservice.ora" 34L, 1602C written[root@gzybtest admin]# SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup pfile=/orac/orahome/11.2.0/db_1/dbs/initdbservice.oraORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size 2218032 bytesVariable Size 5838473168 bytesDatabase Buffers 7583301632 bytesRedo Buffers 71471104 bytesDatabase mounted.Database opened.SQL> drop tablespace UNDOTBS1 including contents and datafiles;Tablespace dropped.
到此数据恢复终于搞定了,接下来就是备份数据使用exp/expdp来进行逻辑导出
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-768095/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/26015009/viewspace-768095/