隱含引數_DISABLE_LOGGING導致資料庫的損壞在重啟資料庫時報ORA-19821

eric0435發表於2013-08-09
資料庫

由於修改了隱含引數_DISABLE_LOGGING為TRUE：_disable_logging = TRUE 那麼啟動資料庫後進行任何的操作，在關閉資料庫後，就會發現資料庫出現了損壞：

SQL> startup
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database 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 immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database 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.ora
System 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 mount
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database mounted.

SQL> recover database until cancel;

ORA-00279: change 13480665044793 generated at 08/08/2013 16:36:47 needed for
thread 1
ORA-00289: suggestion :
/orac/flash_recovery_area/DBSERVICE/archivelog/2013_08_08/o1_mf_1_1258_%u_.arc
ORA-00280: change 13480665044793 for thread 1 is in sequence #1258

Specify 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 status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-10879: error signaled in parallel recovery slave
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: '/oradata/dbservice/system01.dbf'

SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> 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 2336
LOGFILE
  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 LOGFILE
DATAFILE
  '/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 nomount
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes

SQL>CREATE CONTROLFILE REUSE DATABASE "DBSERVIC" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 800
    MAXINSTANCES 8
    MAXLOGHISTORY 2336
LOGFILE
  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 LOGFILE
DATAFILE
  '/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 open

SQL>  alter database open 
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-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.trc
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], [], 

[], [], [], [], []
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 mount
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database 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 consistent
ORA-01110: data file 1: '/oradata/dbservice/system01.dbf'

檢查alert_dbservice.log檔案發現

No Resource Manager plan active
Errors 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.ora
dbservice.__db_cache_size=7583301632
dbservice.__java_pool_size=67108864
dbservice.__large_pool_size=67108864
dbservice.__oracle_base='/orac'#ORACLE_BASE set from environment
dbservice.__pga_aggregate_target=4764729344
dbservice.__sga_target=8791261184
dbservice.__shared_io_pool_size=0
dbservice.__shared_pool_size=872415232
dbservice.__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.ora
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database 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.ora
dbservice.__db_cache_size=7583301632
dbservice.__java_pool_size=67108864
dbservice.__large_pool_size=67108864
dbservice.__oracle_base='/orac'#ORACLE_BASE set from environment
dbservice.__pga_aggregate_target=4764729344
dbservice.__sga_target=8791261184
dbservice.__shared_io_pool_size=0
dbservice.__shared_pool_size=872415232
dbservice.__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.ora
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database mounted.
Database opened.
SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      undotbs02
SQL> create spfile from pfile;

File created.

使用spfile引數檔案來啟動資料庫

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database 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 contact
Process ID: 8532
Session 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, terminate
dropping tablespace

執行下面的查詢來看undotbs1表空間的回滾段

SQL> SELECT SEGMENT_NAME, OWNER, TABLESPACE_NAME, STATUS FROM DBA_ROLLBACK_SEGS;

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
SYSTEM                         SYS    SYSTEM
ONLINE

_SYSSMU13_2246115931$          PUBLIC UNDOTBS1
OFFLINE

_SYSSMU12_1541645018$          PUBLIC UNDOTBS1
NEEDS RECOVERY

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU11_1259892418$          PUBLIC UNDOTBS1
OFFLINE

_SYSSMU10_3550978943$          PUBLIC UNDOTBS1
OFFLINE

_SYSSMU9_1424341975$           PUBLIC UNDOTBS1
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU8_2012382730$           PUBLIC UNDOTBS1
OFFLINE

_SYSSMU7_3286610060$           PUBLIC UNDOTBS1
OFFLINE

_SYSSMU6_2443381498$           PUBLIC UNDOTBS1
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU5_1527469038$           PUBLIC UNDOTBS1
OFFLINE

_SYSSMU4_1152005954$           PUBLIC UNDOTBS1
OFFLINE

_SYSSMU3_2097677531$           PUBLIC UNDOTBS1
NEEDS RECOVERY

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU37_1815119680$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU36_3725248445$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU35_2892765787$          PUBLIC UNDOTBS02
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU34_2695217521$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU33_1797432692$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU32_1653795157$          PUBLIC UNDOTBS02
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU31_1105695367$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU30_424248798$           PUBLIC UNDOTBS02
OFFLINE

_SYSSMU29_778801568$           PUBLIC UNDOTBS02
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU28_2939988898$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU27_220897705$           PUBLIC UNDOTBS02
OFFLINE

_SYSSMU26_153095121$           PUBLIC UNDOTBS02
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU25_193585708$           PUBLIC UNDOTBS02
OFFLINE

_SYSSMU24_3014414866$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU23_2910579661$          PUBLIC UNDOTBS02
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU22_2488176863$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU21_1905929509$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU20_3032273491$          PUBLIC UNDOTBS02
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU19_2000855474$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU18_729116992$           PUBLIC UNDOTBS02
OFFLINE

_SYSSMU17_388387478$           PUBLIC UNDOTBS02
OFFLINE

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
------------------------------ ------ ------------------------------
STATUS
----------------
_SYSSMU16_241755401$           PUBLIC UNDOTBS02
OFFLINE

_SYSSMU15_1810545622$          PUBLIC UNDOTBS02
OFFLINE

_SYSSMU14_714084753$           PUBLIC UNDOTBS02
OFFLINE

[root@gzybtest admin]# vi /orac/orahome/11.2.0/db_1/dbs/initdbservice.ora
dbservice.__db_cache_size=7583301632
dbservice.__java_pool_size=67108864
dbservice.__large_pool_size=67108864
dbservice.__oracle_base='/orac'#ORACLE_BASE set from environment
dbservice.__pga_aggregate_target=4764729344
dbservice.__sga_target=8791261184
dbservice.__shared_io_pool_size=0
dbservice.__shared_pool_size=872415232
dbservice.__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.ora
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            5838473168 bytes
Database Buffers         7583301632 bytes
Redo Buffers               71471104 bytes
Database mounted.
Database opened.
SQL> drop tablespace UNDOTBS1 including contents and datafiles;

Tablespace dropped.

到此資料恢復終於搞定了,接下來就是備份資料使用exp/expdp來進行邏輯匯出

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-768095/，如需轉載，請註明出處，否則將追究法律責任。

相關文章