Trace file /data/u01/app/oracle/diag/rdbms/orcl/chicago/trace/chicago_ora_14486.trc Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /data/u01/app/oracle/product/11.2.0.4/dbhome_1 System name: Linux Node name: dax-mysql-slave Release: 3.10.0-327.el7.x86_64 Version: #1 SMP Thu Nov 19 22:10:57 UTC 2015 Machine: x86_64 Instance name: chicago Redo thread mounted by this instance: 1 Oracle process number: 26 Unix process pid: 14486, image: oracle@dax-mysql-slave (TNS V1-V3)
*** 2019-03-16 20:17:45.310 *** SESSION ID:(131.5) 2019-03-16 20:17:45.310 *** CLIENT ID:() 2019-03-16 20:17:45.310 *** SERVICE NAME:(SYS$USERS) 2019-03-16 20:17:45.310 *** MODULE NAME:(sqlplus@dax-mysql-slave (TNS V1-V3)) 2019-03-16 20:17:45.310 *** ACTION NAME:() 2019-03-16 20:17:45.310 -- The following are current System-scope REDO Log Archival related -- parameters and can be included in the database initialization file. -- -- LOG_ARCHIVE_DEST='' -- LOG_ARCHIVE_DUPLEX_DEST='' -- -- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf -- -- DB_UNIQUE_NAME="orcl" -- -- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG' -- LOG_ARCHIVE_MAX_PROCESSES=4 -- STANDBY_FILE_MANAGEMENT=MANUAL -- STANDBY_ARCHIVE_DEST=?/dbs/arch -- FAL_CLIENT='' -- FAL_SERVER='' -- -- LOG_ARCHIVE_DEST_1='LOCATION=/data/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/arch' -- LOG_ARCHIVE_DEST_1='MANDATORY NOREOPEN NODELAY' -- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM EXPEDITE NOVERIFY SYNC' -- LOG_ARCHIVE_DEST_1='NOREGISTER NOALTERNATE NODEPENDENCY' -- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME' -- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)' -- LOG_ARCHIVE_DEST_STATE_1=ENABLE -- -- The following commands will create a new control file and use it -- to open the database. -- Data used by Recovery Manager will be lost. -- The contents of online logs will be lost and all backups will -- be invalidated. Use this only if online logs are damaged. -- After mounting the created controlfile, the following SQL -- statement will place the database in the appropriate -- protection mode: -- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/data/u01/app/oracle/oradata/orcl/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '/data/u01/app/oracle/oradata/orcl/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '/data/u01/app/oracle/oradata/orcl/redo03.log' SIZE 50M BLOCKSIZE 512 -- STANDBY LOGFILE DATAFILE '/data/u01/app/oracle/oradata/orcl/system01.dbf', '/data/u01/app/oracle/oradata/orcl/sysaux01.dbf', '/data/u01/app/oracle/oradata/orcl/undotbs01.dbf', '/data/u01/app/oracle/oradata/orcl/users01.dbf' CHARACTER SET ZHS16GBK ; -- Commands to re-create incarnation table -- Below log names MUST be changed to existing filenames on -- disk. Any one log file from each branch can be used to -- re-create incarnation records. -- ALTER DATABASE REGISTER LOGFILE '/data/u01/app/oracle/product/11.2.0.4/dbhome_1 /dbs/arch1_1_1002593622.dbf'; -- ALTER DATABASE REGISTER LOGFILE '/data/u01/app/oracle/product/11.2.0.4/dbhome_1 /dbs/arch1_1_1003088967.dbf'; -- Recovery is required if any of the datafiles are restored backups, -- or if the last shutdown was not normal or immediate. RECOVER DATABASE USING BACKUP CONTROLFILE -- Database can now be opened zeroing the online logs. ALTER DATABASE OPEN RESETLOGS; -- Commands to add tempfiles to temporary tablespaces. -- Online tempfiles have complete space information. -- Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE '/data/u01/app/oracle/oradata/orcl/temp01.dbf' SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions. --
*** 2019-03-16 20:17:54.765 Stopping background process SMCO
*** 2019-03-16 20:17:55.918 Stopping background process QMNC
*** 2019-03-16 20:17:56.918 Stopping background process MMNL
*** 2019-03-16 20:17:57.918 Stopping background process MMON
*** 2019-03-16 20:17:58.939 ksukia: Starting kill, flags = 1 ksukia: killed 0 out of 0 processes.
*** 2019-03-16 20:18:00.031 *** 2019-03-16 20:18:00.031 4329 krsh.c ARCH: Archival disabled due to shutdown: 1089
*** 2019-03-16 20:18:01.032 *** 2019-03-16 20:18:01.032 4329 krsh.c ARCH: Archival disabled due to shutdown: 1089
修改操作过程：
1 2 3 4 5 6 7
STARTUP NOMOUNT该行上面的内容全部删除 以--开头的内容全部删除；（vim 方法 :%s/^--.*//g) ***下的记录进程动态的内容全部删除 CREATE CONTROLFILE REUSE DATABASE替换为CREATE CONTROLFILE SET DATABASE RECOVER DATABASE USING BACKUP CONTROLFILE加上注释--RECOVER DATABASE USING BACKUP CONTROLFILE（也可删除） ORCL替换为CHICAGO (vim 方法 :%s/ORCL/CHICAGO/g) orcl替换为chicago (vim 方法 :%s/orcl/chicago/g)