ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 隐含参数_DISABLE_LOGGING导致数据库的损坏在重启数据库时报ORA-19821

隐含参数_DISABLE_LOGGING导致数据库的损坏在重启数据库时报ORA-19821

原创 Linux操作系统 作者:eric0435 时间:2013-08-09 01:35:35 0 删除 编辑

由于修改了隐含参数_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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
系统架构师,ACOUG MEMBER,Oracle ACE,Mail:yongjing.star@gmail.com Mobile:13875984558 QQ:409898894 Blog:www.jydba.net

注册时间:2011-10-12

  • 博文量
    537
  • 访问量
    6186477