Shulou(Shulou.com)05/31 Report--

This article shows you how to recreate the control file in Oracle. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

There are two ways to create control files

Resetlogs and Noresetlogs respectively, when we back up the control file to the trace file, we can see that it contains two parts of the reconstruction statement, one is to use resetlogs, the other is to use 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.

-- use noresetlogs only when all current online logs is available.

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.

-- using resetlogs will result in loss of content in online logs and invalidation of all backups, using resetlos mode only if online logs goes bad.

Second, get the script to rebuild the control file

Alter database backup controlfile to trace

Get the SQL of the trace file (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))

3. The contents of the trace files obtained by the test environment

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 purl 59 purl 49.680

* SESSION ID: (1. 5) 2018-12-02 21 purl 59 purl 49.680

* CLIENT ID: () 2018-12-02 21 purl 59 purl 49.680

* SERVICE NAME: (SYS$USERS) 2018-12-02 21 purl 59 purl 49.680

* MODULE NAME: (sqlplus@test-db (TNS V1-V3)) 2018-12-02 21 Fran 59 49 680

* ACTION NAME: () 2018-12-02 21 purl 59 purl 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 21 Fraser 5922

Kwqinfy: Call kwqrNondurSubInstTsk

* 2018-12-02 22 22 48 purl 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 SIZE SIZE 50m BLOCKSIZE 512

GROUP 2'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 3'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 4'/ u01 SIZE SIZE 50m BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

'/ u01 apprenticeship oracleplains oradataUniplicatescliceddataUniplicationorclplets system01.dbf'

'/ u01 apprenticeship oradataUniplicateorclaux01.dbf'

'/ u01 apprenticeship oracleplains oradataUniplicationsundotbs01.dbf'

'/ u01 apprenticeship oracleplexoradataUniplicates01.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'/ u01Accord oradataActionoradataUniplicatedorclicarchplains 1' 762083164.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataPlacement 1 '901324477.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataPlacement 1 '920849936. Dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataPlacement orclicarchplains 1percent 925085090.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataUniplicatedorclicarchplains 1y974422417.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataPlacement orclicarchArchPlance1y974502550.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 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'/ u01qapplash oracle.oradataUniplicateorcliceddataUniplicationorclActions2.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'/ u01qqappUniqr oracle.oradataUniplicateorclincdataUniplicationorclap01.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 SIZE SIZE 50m BLOCKSIZE 512

GROUP 2'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 3'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 4'/ u01 SIZE SIZE 50m BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

'/ u01 apprenticeship oracleplains oradataUniplicatescliceddataUniplicationorclplets system01.dbf'

'/ u01 apprenticeship oradataUniplicateorclaux01.dbf'

'/ u01 apprenticeship oracleplains oradataUniplicationsundotbs01.dbf'

'/ u01 apprenticeship oracleplexoradataUniplicates01.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'/ u01amp appActionoracleUniplicateoradataUniplicateorclicalarchplicarplic1ity762083164.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01 ripple appplplet oracleUniplicateoradataUniplicateorclicalarchplains 1' 901324477.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataPlacement 1 '920849936. Dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataPlacement orclicarchplains 1percent 925085090.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataUniplicatedorclicarchplains 1y974422417.dbf'

-- ALTER DATABASE REGISTER LOGFILE'/ u01Accord oradataActionoradataPlacement orclicarchArchPlance1y974502550.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 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'/ u01qapplash oracle.oradataUniplicateorcliceddataUniplicationorclActions2.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'/ u01qqappUniqr oracle.oradataUniplicateorclincdataUniplicationorclap01.dbf'.

SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M

-- End of tempfile additions.

Recreate the control file

Because the redo log file is complete, the control file is reconstructed by NORESETLOGS.

An error is reported after deleting the control file and restarting the startup database. The message prompt is as follows:

ALTER DATABASE MOUNT

ORA-00210: cannot open the specified control file

ORA-00202: control file:'/ u01According to an oracle.oradataAccording to the control l02.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:'/ u01According to an oracle.oradataAccording to an orclencoded data

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Execute the information to create the control file 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 > 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 > 2

Tablespace altered.

SYS@orcl >

Database log information:

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 SIZE SIZE 50m BLOCKSIZE 512

GROUP 2'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 3'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 4'/ u01 SIZE SIZE 50m BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

'/ u01 apprenticeship oracleplains oradataUniplicatescliceddataUniplicationorclplets system01.dbf'

'/ u01 apprenticeship oradataUniplicateorclaux01.dbf'

'/ u01 apprenticeship oracleplains oradataUniplicationsundotbs01.dbf'

'/ u01 apprenticeship oracleplexoradataUniplicates01.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 SIZE SIZE 50m BLOCKSIZE 512

GROUP 2'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 3'/ u01 SIZE SIZE 50m BLOCKSIZE 512

GROUP 4'/ u01 SIZE SIZE 50m BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

'/ u01 apprenticeship oracleplains oradataUniplicatescliceddataUniplicationorclplets system01.dbf'

'/ u01 apprenticeship oradataUniplicateorclaux01.dbf'

'/ u01 apprenticeship oracleplains oradataUniplicationsundotbs01.dbf'

'/ u01 apprenticeship oracleplexoradataUniplicates01.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 REUSE

Block change tracking file is current.

Completed: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

USING FILE'/ u01 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 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'/ u01qapplash oracle.oradataUniplicateorcliceddataUniplicationorclActions2.dbf'

Completed: ALTER DATABASE RENAME FILE 'MISSING00006'

TO'/ u01qapplash oracle.oradataUniplicateorcliceddataUniplicationorclActions2.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'/ u01qqappUniqr oracle.oradataUniplicateorclincdataUniplicationorclap01.dbf'.

SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M

Completed: ALTER TABLESPACE TEMP ADD TEMPFILE'/ u01qqappActionoradataAccording to temp01.dbf'

SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M

The above is how to recreate control files in Oracle. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.