Oracle 11g 重新建立控制檔案
一、建立控制檔案有2種方式
分別是 Resetlogs 和 Noresetlogs 方式，當我們將控制檔案備份到trace 檔案時，可以看到裡面包含了2部分的重建語句，一個是使用resetlogs，另一個是使用noresetlogs。
Set #1. NORESETLOGS case
The followingcommands will create a new control file and use it to open the database. Dataused by Recovery Manager will be lost.
Additional logsmay be required for media recovery of offline.
Use this only ifthe current versions of all online logs are available.
--使用noresetlogs僅是當前所有的online logs可用時。
Set #2. RESETLOGS case
The followingcommands will create a new control file and use it to open the database. Dataused by Recovery Manager will be lost.
The contents ofonline logs will be lost and all backups will be invalidated. Use this only ifonline logs are damaged.
--使用resetlogs，將導致online logs裡的內容丟失，並且所有的備份失效，僅當online logs 隨壞的情況下，才使用resetlos模式。
二、獲取重建控制檔案的指令碼
alter database backup controlfile to trace;
獲取trace檔案的SQL（Oracle 11g）
SELECT TRACEFILE
FROM V$PROCESS
WHERE ADDR IN
(SELECT PADDR
FROM V$SESSION
WHERE SID IN (SELECT SID FROM V$MYSTAT WHERE ROWNUM = 1))
三、測試環境獲取的trace檔案內容
Trace file /u01/app/oracle/diag/rdbms/primary_orcl/orcl/trace/orcl_ora_2260.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: test-db
Release: 2.6.32-279.el6.x86_64
Version: #1 SMP Wed Jun 13 18:24:36 EDT 2012
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 2260, image: oracle@test-db (TNS V1-V3)
*** 2018-12-02 21:59:49.680
*** SESSION ID:(1.5) 2018-12-02 21:59:49.680
*** CLIENT ID:() 2018-12-02 21:59:49.680
*** SERVICE NAME:(SYS$USERS) 2018-12-02 21:59:49.680
*** MODULE NAME:(sqlplus@test-db (TNS V1-V3)) 2018-12-02 21:59:49.680
*** ACTION NAME:() 2018-12-02 21:59:49.680
kwqmnich: current time:: 13: 59: 48: 0
kwqmnich: instance no 0 repartition flag 1
kwqmnich: initialized job cache structure
*** 2018-12-02 21:59:50.422
kwqinfy: Call kwqrNondurSubInstTsk
*** 2018-12-02 22:48:05.484
-- 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="primary_orcl"
--
-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'
-- LOG_ARCHIVE_MAX_PROCESSES=4
-- ARCHIVE_LAG_TARGET=1800
-- STANDBY_FILE_MANAGEMENT=AUTO
-- STANDBY_ARCHIVE_DEST=?/dbs/arch
-- FAL_CLIENT=primary_orcl
-- FAL_SERVER=standby_orcl
--
-- LOG_ARCHIVE_DEST_2='SERVICE=standby_orcl'
-- LOG_ARCHIVE_DEST_2='OPTIONAL REOPEN=300 NODELAY'
-- LOG_ARCHIVE_DEST_2='LGWR NOAFFIRM NOEXPEDITE NOVERIFY ASYNC=61440'
-- LOG_ARCHIVE_DEST_2='REGISTER NOALTERNATE NODEPENDENCY'
-- LOG_ARCHIVE_DEST_2='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'
-- LOG_ARCHIVE_DEST_2='DB_UNIQUE_NAME=standby_orcl'
-- LOG_ARCHIVE_DEST_2='VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE)'
-- LOG_ARCHIVE_DEST_STATE_2=DEFER
--
-- LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/oradata/orcl_arch'
-- LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'
-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM NOEXPEDITE NOVERIFY SYNC'
-- LOG_ARCHIVE_DEST_1='REGISTER NOALTERNATE NODEPENDENCY'
-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'
-- LOG_ARCHIVE_DEST_1='DB_UNIQUE_NAME=primary_orcl'
-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'
-- LOG_ARCHIVE_DEST_STATE_1=ENABLE
--
-- Below are two sets of SQL statements, each of which creates a new
-- control file and uses it to open the database. The first set opens
-- the database with the NORESETLOGS option and should be used only if
-- the current versions of all online logs are available. The second
-- set opens the database with the RESETLOGS option and should be used
-- if online logs are unavailable.
-- The appropriate set of statements can be copied from the trace into
-- a script file, edited as necessary, and executed when there is a
-- need to re-create the control file.
--
-- Set #1. NORESETLOGS case
--
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- Additional logs may be required for media recovery of offline
-- Use this only if the current versions of all online logs are
-- available.
-- 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" NORESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl_data/orcl/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/orcl_data/orcl/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/orcl_data/orcl/redo03.log' SIZE 50M BLOCKSIZE 512,
GROUP 4 '/u01/app/oracle/oradata/orcl_data/orcl/redo04.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/orcl_data/orcl/system01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/users01.dbf'
CHARACTER SET ZHS16GBK
;
-- Configure RMAN configuration record 1
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');
-- Configure RMAN configuration record 2
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE','DISK TO ''/backup/orcl_%F''');
-- 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 '/u01/app/oracle/oradata/orcl_arch/1_1_762083164.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_901324477.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_920849936.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_925085090.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_974422417.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_974502550.dbf';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- Block change tracking was enabled, so re-enable it now.
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE '/u01/app/oracle/oradata/block_track/block_tracking.chg' REUSE;
-- All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
-- Database can now be opened normally.
ALTER DATABASE OPEN;
-- Files in read-only tablespaces are now named.
ALTER DATABASE RENAME FILE 'MISSING00005'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test01.dbf
';
ALTER DATABASE RENAME FILE 'MISSING00006'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test_ts2.dbf';
-- Online the files in read-only tablespaces.
ALTER TABLESPACE "TEST" ONLINE;
ALTER TABLESPACE "TEST_TS" ONLINE;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/orcl_data/orcl/temp01.dbf'
SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
-- End of tempfile additions.
--
-- Set #2. RESETLOGS case
--
-- 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 FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl_data/orcl/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/orcl_data/orcl/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/orcl_data/orcl/redo03.log' SIZE 50M BLOCKSIZE 512,
GROUP 4 '/u01/app/oracle/oradata/orcl_data/orcl/redo04.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/orcl_data/orcl/system01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/users01.dbf'
CHARACTER SET ZHS16GBK
;
-- Configure RMAN configuration record 1
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');
-- Configure RMAN configuration record 2
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE','DISK TO ''/backup/orcl_%F''');
-- 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 '/u01/app/oracle/oradata/orcl_arch/1_1_762083164.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_901324477.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_920849936.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_925085090.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_974422417.dbf';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/oradata/orcl_arch/1_1_974502550.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
-- Block change tracking was enabled, so re-enable it now.
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE '/u01/app/oracle/oradata/block_track/block_tracking.chg' REUSE;
-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
-- Files in read-only tablespaces are now named.
ALTER DATABASE RENAME FILE 'MISSING00005'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test01.dbf
';
ALTER DATABASE RENAME FILE 'MISSING00006'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test_ts2.dbf';
-- Online the files in read-only tablespaces.
ALTER TABLESPACE "TEST" ONLINE;
ALTER TABLESPACE "TEST_TS" ONLINE;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/orcl_data/orcl/temp01.dbf'
SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
-- End of tempfile additions.
五、 重新建立控制檔案
由於redo log file 是完整的，所以採用 NORESETLOGS方式重建控制檔案。
刪除控制檔案並重啟啟動資料庫後報錯，資訊提示如下：
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl_data/orcl/control02.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl_data/orcl/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
執行建立控制檔案SQL的資訊
Total System Global Area 784998400 bytes
Fixed Size 2232472 bytes
Variable Size 591400808 bytes
Database Buffers 188743680 bytes
Redo Buffers 2621440 bytes
SYS@orcl> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Control file created.
SYS@orcl> SYS@orcl> SYS@orcl>
PL/SQL procedure successfully completed.
SYS@orcl> SYS@orcl> SYS@orcl>
PL/SQL procedure successfully completed.
SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SYS@orcl> SYS@orcl> 2
Database altered.
SYS@orcl> SYS@orcl>
System altered.
SYS@orcl> SYS@orcl>
Database altered.
SYS@orcl> SYS@orcl> 2 3
Database altered.
SYS@orcl> 2
Database altered.
SYS@orcl> SYS@orcl>
Tablespace altered.
SYS@orcl>
Tablespace altered.
SYS@orcl> SYS@orcl> SYS@orcl> SYS@orcl> 2
Tablespace altered.
SYS@orcl>
資料庫日誌資訊：
Sun Dec 02 22:57:32 2018
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: test-db
Release: 2.6.32-279.el6.x86_64
Version: #1 SMP Wed Jun 13 18:24:36 EDT 2012
Machine: x86_64
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 150
memory_target = 752M
control_files = "/u01/app/oracle/oradata/orcl_data/orcl/control01.ctl"
control_files = "/u01/app/oracle/oradata/orcl_data/orcl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=/u01/app/oracle/oradata/orcl_arch valid_for=(all_logfiles,all_roles) db_unique_name=primary_orcl"
log_archive_dest_2 = "service=standby_orcl LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=standby_orcl"
log_archive_dest_state_1 = "enable"
log_archive_dest_state_2 = "defer"
fal_client = "primary_orcl"
fal_server = "standby_orcl"
log_archive_config = ""
log_archive_format = "%t_%s_%r.dbf"
archive_lag_target = 1800
standby_file_management = "AUTO"
_allow_resetlogs_corruption= TRUE
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener = "my_orcl"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "primary_orcl"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Sun Dec 02 22:57:33 2018
PMON started with pid=2, OS id=2996
Sun Dec 02 22:57:33 2018
PSP0 started with pid=3, OS id=3000
Sun Dec 02 22:57:34 2018
VKTM started with pid=4, OS id=3004 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Dec 02 22:57:34 2018
GEN0 started with pid=5, OS id=3010
Sun Dec 02 22:57:34 2018
DIAG started with pid=6, OS id=3014
Sun Dec 02 22:57:34 2018
DBRM started with pid=7, OS id=3018
Sun Dec 02 22:57:34 2018
DIA0 started with pid=8, OS id=3022
Sun Dec 02 22:57:34 2018
MMAN started with pid=9, OS id=3026
Sun Dec 02 22:57:34 2018
DBW0 started with pid=10, OS id=3030
Sun Dec 02 22:57:34 2018
LGWR started with pid=11, OS id=3034
Sun Dec 02 22:57:34 2018
CKPT started with pid=12, OS id=3038
Sun Dec 02 22:57:34 2018
SMON started with pid=13, OS id=3042
Sun Dec 02 22:57:34 2018
RECO started with pid=14, OS id=3046
Sun Dec 02 22:57:34 2018
MMON started with pid=15, OS id=3050
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Dec 02 22:57:34 2018
MMNL started with pid=16, OS id=3054
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Sun Dec 02 22:57:34 2018
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl_data/orcl/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/orcl_data/orcl/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/orcl_data/orcl/redo03.log' SIZE 50M BLOCKSIZE 512,
GROUP 4 '/u01/app/oracle/oradata/orcl_data/orcl/redo04.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/orcl_data/orcl/system01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/users01.dbf'
CHARACTER SET ZHS16GBK
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Successful mount of redo thread 1, with mount id 1521687390
Completed: CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl_data/orcl/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/orcl_data/orcl/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/orcl_data/orcl/redo03.log' SIZE 50M BLOCKSIZE 512,
GROUP 4 '/u01/app/oracle/oradata/orcl_data/orcl/redo04.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/orcl_data/orcl/system01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl_data/orcl/users01.dbf'
CHARACTER SET ZHS16GBK
ALTER DATABASE RECOVER DATABASE
Media Recovery Start
Serial Media Recovery started
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER DATABASE ...
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE '/u01/app/oracle/oradata/block_track/block_tracking.chg' REUSE
Block change tracking file is current.
Completed: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE '/u01/app/oracle/oradata/block_track/block_tracking.chg' REUSE
Archived Log entry 1 added for thread 1 sequence 99 ID 0x598b1587 dest 1:
Archived Log entry 2 added for thread 1 sequence 100 ID 0x598b1587 dest 1:
Archived Log entry 3 added for thread 1 sequence 101 ID 0x598b1587 dest 1:
ALTER DATABASE OPEN
Block change tracking file is current.
LGWR: STARTING ARCH PROCESSES
Sun Dec 02 22:57:38 2018
ARC0 started with pid=20, OS id=3120
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sun Dec 02 22:57:39 2018
ARC1 started with pid=21, OS id=3124
Sun Dec 02 22:57:39 2018
ARC2 started with pid=22, OS id=3128
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Sun Dec 02 22:57:39 2018
ARC3 started with pid=23, OS id=3132
Thread 1 advanced to log sequence 103 (thread open)
Thread 1 opened at log sequence 103
Current log# 3 seq# 103 mem# 0: /u01/app/oracle/oradata/orcl_data/orcl/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Starting background process CTWR
Archived Log entry 4 added for thread 1 sequence 102 ID 0x598b1587 dest 1:
Sun Dec 02 22:57:39 2018
CTWR started with pid=24, OS id=3136
Block change tracking service is active.
SMON: enabling cache recovery
[3067] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:2892964 end:2892994 diff:30 (0 seconds)
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Tablespace 'TEST' #6 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Tablespace 'TEST_TS' #7 found in data dictionary,
but not in the controlfile. Adding to controlfile.
File #5 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00005' in the controlfile.
File #6 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00006' in the controlfile.
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sun Dec 02 22:57:39 2018
QMNC started with pid=25, OS id=3140
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: ALTER DATABASE OPEN
ALTER DATABASE RENAME FILE 'MISSING00005'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test01.dbf
'
Completed: ALTER DATABASE RENAME FILE 'MISSING00005'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test01.dbf
'
ALTER DATABASE RENAME FILE 'MISSING00006'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test_ts2.dbf'
Completed: ALTER DATABASE RENAME FILE 'MISSING00006'
TO '/u01/app/oracle/oradata/orcl_data/orcl/test_ts2.dbf'
ALTER TABLESPACE "TEST" ONLINE
Completed: ALTER TABLESPACE "TEST" ONLINE
ALTER TABLESPACE "TEST_TS" ONLINE
Completed: ALTER TABLESPACE "TEST_TS" ONLINE
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Starting background process CJQ0
Sun Dec 02 22:57:40 2018
CJQ0 started with pid=27, OS id=3164
Setting Resource Manager plan SCHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Starting background process VKRM
Sun Dec 02 22:57:43 2018
VKRM started with pid=26, OS id=3168
Sun Dec 02 22:57:52 2018
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/orcl_data/orcl/temp01.dbf'
SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/orcl_data/orcl/temp01.dbf'
SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M
資料庫已經成功啟動
---------------------
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/2317695/viewspace-2222412/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle 控制檔案Oracle
- oracle ORA-01189 ORA-01110（控制檔案建立報錯）Oracle
- ORACLE 控制檔案（Control Files）概述Oracle
- Oracle 11g RAC重新新增節點Oracle
- 11G oracle資料庫重新啟動crsOracle資料庫
- Oracle 控制檔案損壞解決方案Oracle
- oracle監聽檔案listener.ora for 10g/11gOracle
- oracle 11g建立基線詳細資訊Oracle
- oracle11g修改控制檔案路徑Oracle
- oracle 控制檔案及引數檔案何時自動備份Oracle
- 【RMAN】Oracle中如何備份控制檔案？備份控制檔案的方式有哪幾種？Oracle
- oracle 11G RAC的建立(VM虛擬環境)Oracle
- Oracle+Ogg 歸檔丟失 重新導資料建立ogg同步步驟Oracle
- oracle快速拿到重建控制檔案語句的方法二Oracle
- 清除Oracle控制檔案中的歸檔資訊v$archived_logOracleHive
- oracle 11g開啟歸檔模式及修改歸檔目錄Oracle模式
- oracle 11g 分割槽表建立（年月日周時分秒）Oracle
- oracle dg庫資料檔案建立失敗ORA-01111Oracle
- oracle 19c建立非OMF檔案命名格式的PDBOracle
- docker新增檔案重新打包Docker
- 建立.symlnk檔案
- 【SQL】Oracle建立CLOB型別上傳下載讀取檔案SQLOracle型別
- 重新整理檔案上傳
- Oracle之11g DataGuardOracle
- 2.6.4 指定控制檔案
- 重新命名一千個檔案要多久？ Name Mangler 快速為大量檔案重新命名
- Oracle 19c standby 建立資料檔案報錯ORA-01111Oracle
- ORACLE 概要檔案管理Oracle
- Oracle 密碼檔案Oracle密碼
- VBA建立文字檔案、讀寫文字檔案
- Oracle12C新特性-線上重新命名遷移資料檔案(一)Oracle
- ORA-01113異常處理_一鍵重新整理Oracle資料檔案scnOracle
- Oracle 11g Data Guard 增加資料檔案報錯：ORA-01111、ORA-01110、ORA-01157Oracle
- 批次檔案重新命名的方法
- Oracle-無備份情況下，如何手動恢復控制檔案Oracle
- oracle控制檔案的損壞或完全丟失的恢復辦法Oracle
- Oracle 11G 安裝文件Oracle
- benchmark 壓測Oracle 11gOracle