Re-create all lost controlfile

Post by **jimb** » Fri Jul 27, 2012 9:56 pm

In scenario where all control files are lost, we can still recreate it from a currently running database:

1. Check your current control files location.
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL11G/control01.ctl
/u01/app/oracle/flash_recovery_area/ORCL11G/control02.ctl

2. Check you datafiles location:
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL11G/system01.dbf
/u01/app/oracle/oradata/ORCL11G/sysaux01.dbf
/u01/app/oracle/oradata/ORCL11G/undotbs01.dbf
/u01/app/oracle/oradata/ORCL11G/users01.dbf

3. Get logfiles location:
SQL> col member format a50
SQL> select a.group#,a.member,b.status from v$logfile a, v$log b where a.group#=b.group#;

GROUP# MEMBER STATUS
---------- -------------------------------------------------- ----------------
3 /u01/app/oracle/oradata/ORCL11G/redo03.log INACTIVE
2 /u01/app/oracle/oradata/ORCL11G/redo02.log CURRENT
1 /u01/app/oracle/oradata/ORCL11G/redo01.log INACTIVE

4. Create control file trace
SQL> alter database backup controlfile to trace;

Database altered.

SQL> show parameter user_dump_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string /u01/app/oracle/diag/rdbms/orc
l11g/ORCL11G/trace

- OR -
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/home/oracle/create_ctl.sql';

Database altered.

5. Check the contents of the created control trace file:
[TEST1011@ORCL11G /home/oracle] cat /home/oracle/create_ctl.sql

-- 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="ORCL11G"
--
-- 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=USE_DB_RECOVERY_FILE_DEST'
-- 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

--
-- 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 "ORCL11G" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/ORCL11G/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/ORCL11G/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/ORCL11G/redo03.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE

DATAFILE
'/u01/app/oracle/oradata/ORCL11G/system01.dbf',
'/u01/app/oracle/oradata/ORCL11G/sysaux01.dbf',
'/u01/app/oracle/oradata/ORCL11G/undotbs01.dbf',
'/u01/app/oracle/oradata/ORCL11G/users01.dbf'
CHARACTER SET WE8MSWIN1252
;

-- 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/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE

-- All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;

-- Database can now be opened normally.
ALTER DATABASE OPEN;

-- 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/ORCL11G/temp01.dbf'
SIZE 20971520 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 "ORCL11G" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/ORCL11G/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/ORCL11G/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/ORCL11G/redo03.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE

DATAFILE
'/u01/app/oracle/oradata/ORCL11G/system01.dbf',
'/u01/app/oracle/oradata/ORCL11G/sysaux01.dbf',
'/u01/app/oracle/oradata/ORCL11G/undotbs01.dbf',
'/u01/app/oracle/oradata/ORCL11G/users01.dbf'
CHARACTER SET WE8MSWIN1252
;

-- 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/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_1_%u_.arc';
-- 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 '/u01/app/oracle/oradata/ORCL11G/temp01.dbf'
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
-- End of tempfile additions.
--

5. From the trace file, copy the part: -- Set #2. RESETLOGS case
[TEST1011@ORCL11G /home/oracle] vi /home/oracle/create_control.sql

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL11G" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/ORCL11G/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/ORCL11G/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/ORCL11G/redo03.log' SIZE 50M BLOCKSIZE 512
DATAFILE
'/u01/app/oracle/oradata/ORCL11G/system01.dbf',
'/u01/app/oracle/oradata/ORCL11G/sysaux01.dbf',
'/u01/app/oracle/oradata/ORCL11G/undotbs01.dbf',
'/u01/app/oracle/oradata/ORCL11G/users01.dbf'
CHARACTER SET WE8MSWIN1252
;
RECOVER DATABASE USING BACKUP CONTROLFILE
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/ORCL11G/temp01.dbf'
SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;

6. For testing purposes, we will remove all simply rename all your control files from your test database:
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL11G/control01.ctl
/u01/app/oracle/flash_recovery_area/ORCL11G/control02.ctl

mv /u01/app/oracle/oradata/ORCL11G/control01.ctl /u01/app/oracle/oradata/ORCL11G/control01.ctl.orig
mv /u01/app/oracle/flash_recovery_area/ORCL11G/control02.ctl /u01/app/oracle/flash_recovery_area/ORCL11G/control02.ctl.orig

7. Now that all your controlfiles are missing, let's bounce the database and see what happens:
SQL> shutdown immediate;

SQL> shutdown immediate;
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/ORCL11G/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

Note: We are unable to cleanly shutdown the database because of missing control files. So, let's rather perform force shutdown.
SQL> shutdown abort;

ORACLE instance shut down.
SQL>

8. Now, let's try to startup our database:
SQL> startup

ORACLE instance started.

Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 230689880 bytes
Database Buffers 75497472 bytes
Redo Buffers 6336512 bytes
ORA-00205: error in identifying control file, check alert log for more info

Note: Oracle is able to startup in NOMOUNT mode but unable to mount the database because of missing controlfiles. This is where controlfiles recovery take place.

9. Shutdown the database. Then run the script we create earlier in Step 5.
SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.
SQL>

SQL> @/home/oracle/create_control.sql

ORACLE instance started.

Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 230689880 bytes
Database Buffers 75497472 bytes
Redo Buffers 6336512 bytes

Control file created.

ORA-00279: change 1052304 generated at 07/29/2012 12:43:48 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_
.arc
ORA-00280: change 1052304 for thread 1 is in sequence #18

ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u
_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u
_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Note: Database needs recovery. Apply the current redo log:
SQL> col member format a50
SQL> select a.group#,a.member,b.status from v$logfile a, v$log b where a.group#=b.group#;

GROUP# MEMBER STATUS
---------- -------------------------------------------------- ----------------
1 /u01/app/oracle/oradata/ORCL11G/redo01.log UNUSED
2 /u01/app/oracle/oradata/ORCL11G/redo02.log UNUSED
3 /u01/app/oracle/oradata/ORCL11G/redo03.log CURRENT

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1052304 generated at 07/29/2012 12:43:48 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_
.arc
ORA-00280: change 1052304 for thread 1 is in sequence #18

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u01/app/oracle/oradata/ORCL11G/redo03.log
Log applied.
Media recovery complete.

10. Open the database with RESETLOGS option:
SQL> alter database open RESETLOGS;

Database altered.

SQL>

From alert logs:

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Sun Jul 29 12:59:59 2012
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORCL11G.ora
System parameters with non-default values:
processes = 150
memory_target = 300M
control_files = "/u01/app/oracle/oradata/ORCL11G/control01.ctl"
control_files = "/u01/app/oracle/flash_recovery_area/ORCL11G/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area"
db_recovery_file_dest_size= 3852M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
audit_sys_operations = TRUE
db_domain = "LOCALDOMAIN"
dispatchers = "(PROTOCOL=TCP) (SERVICE=ORCL11GXDB)"
audit_file_dest = "/u02/backup/"
audit_trail = "OS"
db_name = "ORCL11G"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Sun Jul 29 13:00:21 2012
PMON started with pid=2, OS id=3137
Sun Jul 29 13:00:21 2012
VKTM started with pid=3, OS id=3139 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sun Jul 29 13:00:21 2012
GEN0 started with pid=4, OS id=3143
Sun Jul 29 13:00:21 2012
DIAG started with pid=5, OS id=3145
Sun Jul 29 13:00:21 2012
DBRM started with pid=6, OS id=3147
Sun Jul 29 13:00:21 2012
PSP0 started with pid=7, OS id=3149
Sun Jul 29 13:00:22 2012
DIA0 started with pid=8, OS id=3151
Sun Jul 29 13:00:22 2012
MMAN started with pid=9, OS id=3153
Sun Jul 29 13:00:22 2012
DBW0 started with pid=10, OS id=3155
Sun Jul 29 13:00:22 2012
LGWR started with pid=11, OS id=3157
Sun Jul 29 13:00:22 2012
CKPT started with pid=12, OS id=3159
Sun Jul 29 13:00:22 2012
SMON started with pid=13, OS id=3161
Sun Jul 29 13:00:22 2012
RECO started with pid=14, OS id=3163
Sun Jul 29 13:00:22 2012
MMON started with pid=15, OS id=3165
Sun Jul 29 13:00:22 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Jul 29 13:00:22 2012
MMNL started with pid=16, OS id=3167
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Sun Jul 29 13:00:24 2012
CREATE CONTROLFILE REUSE DATABASE "ORCL11G" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/ORCL11G/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/ORCL11G/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/ORCL11G/redo03.log' SIZE 50M BLOCKSIZE 512
DATAFILE
'/u01/app/oracle/oradata/ORCL11G/system01.dbf',
'/u01/app/oracle/oradata/ORCL11G/sysaux01.dbf',
'/u01/app/oracle/oradata/ORCL11G/undotbs01.dbf',
'/u01/app/oracle/oradata/ORCL11G/users01.dbf'
CHARACTER SET WE8MSWIN1252
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 896810920
Completed: CREATE CONTROLFILE REUSE DATABASE "ORCL11G" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/ORCL11G/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/ORCL11G/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/ORCL11G/redo03.log' SIZE 50M BLOCKSIZE 512
DATAFILE
'/u01/app/oracle/oradata/ORCL11G/system01.dbf',
'/u01/app/oracle/oradata/ORCL11G/sysaux01.dbf',
'/u01/app/oracle/oradata/ORCL11G/undotbs01.dbf',
'/u01/app/oracle/oradata/ORCL11G/users01.dbf'
CHARACTER SET WE8MSWIN1252
ALTER DATABASE RECOVER DATABASE USING BACKUP CONTROLFILE
Media Recovery Start
started logmerger process
Sun Jul 29 13:00:25 2012
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER DATABASE USING BACKUP CONTROLFILE ...
ALTER DATABASE RECOVER LOGFILE 'ALTER'
Media Recovery Log ALTER
Errors with log ALTER
Errors in file /u01/app/oracle/diag/rdbms/orcl11g/ORCL11G/trace/ORCL11G_pr00_3188.trc:
ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-308 signalled during: ALTER DATABASE RECOVER LOGFILE 'ALTER' ...
ALTER DATABASE RECOVER LOGFILE 'ALTER'
Media Recovery Log ALTER
Errors with log ALTER
Errors in file /u01/app/oracle/diag/rdbms/orcl11g/ORCL11G/trace/ORCL11G_pr00_3188.trc:
ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-308 signalled during: ALTER DATABASE RECOVER LOGFILE 'ALTER' ...
ALTER DATABASE RECOVER LOGFILE 'SIZE'
Media Recovery Log SIZE
Errors with log SIZE
Errors in file /u01/app/oracle/diag/rdbms/orcl11g/ORCL11G/trace/ORCL11G_pr00_3188.trc:
ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-308 signalled during: ALTER DATABASE RECOVER LOGFILE 'SIZE' ...
Sun Jul 29 13:00:28 2012
db_recovery_file_dest_size of 3852 MB is 1.29% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Jul 29 13:00:52 2012
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log /u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_.arc
Sun Jul 29 13:00:53 2012
Errors with log /u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_.arc
Errors in file /u01/app/oracle/diag/rdbms/orcl11g/ORCL11G/trace/ORCL11G_pr00_3188.trc:
ORA-00308: cannot open archived log '/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log /u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_.arc
Errors with log /u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_.arc
Errors in file /u01/app/oracle/diag/rdbms/orcl11g/ORCL11G/trace/ORCL11G_pr00_3188.trc:
ORA-00308: cannot open archived log '/u01/app/oracle/flash_recovery_area/ORCL11G/archivelog/2012_07_29/o1_mf_1_18_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Sun Jul 29 13:01:14 2012
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
started logmerger process
Sun Jul 29 13:01:14 2012
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
ALTER DATABASE RECOVER LOGFILE '/u01/app/oracle/oradata/ORCL11G/redo03.log'
Media Recovery Log /u01/app/oracle/oradata/ORCL11G/redo03.log
Incomplete recovery applied all redo ever generated.
Recovery completed through change 1052322 time 07/29/2012 12:44:57
Media Recovery Complete (ORCL11G)
Completed: ALTER DATABASE RECOVER LOGFILE '/u01/app/oracle/oradata/ORCL11G/redo03.log'
Sun Jul 29 13:01:35 2012
alter database open
Errors in file /u01/app/oracle/diag/rdbms/orcl11g/ORCL11G/trace/ORCL11G_ora_3174.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
alter database open RESETLOGS
Archived Log entry 12 added for thread 1 sequence 16 ID 0x3546d55a dest 1:
Archived Log entry 13 added for thread 1 sequence 17 ID 0x3546d55a dest 1:
Archived Log entry 14 added for thread 1 sequence 18 ID 0x3546d55a dest 1:
RESETLOGS after complete recovery through change 1052322
Resetting resetlogs activation ID 893834586 (0x3546d55a)
Sun Jul 29 13:01:58 2012
Setting recovery target incarnation to 2
Sun Jul 29 13:01:58 2012
Assigning activation ID 896810920 (0x35743fa8)
LGWR: STARTING ARCH PROCESSES
Sun Jul 29 13:01:58 2012
ARC0 started with pid=20, OS id=3210
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/ORCL11G/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Jul 29 13:02:01 2012
SMON: enabling cache recovery
Sun Jul 29 13:02:01 2012
ARC1 started with pid=21, OS id=3212
Sun Jul 29 13:02:01 2012
ARC2 started with pid=22, OS id=3214
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Sun Jul 29 13:02:02 2012
ARC3 started with pid=23, OS id=3216
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sun Jul 29 13:02:03 2012
Successfully onlined Undo Tablespace 2.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to 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 WE8MSWIN1252
No Resource Manager plan active
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
If files cannot be cataloged, then manually delete them
using OS command.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sun Jul 29 13:02:09 2012
QMNC started with pid=24, OS id=3218
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Sun Jul 29 13:02:23 2012
Completed: alter database open RESETLOGS
Sun Jul 29 13:02:30 2012
Starting background process CJQ0
Sun Jul 29 13:02:31 2012
CJQ0 started with pid=30, OS id=3238
Setting Resource Manager plan SCHEDULER[0x3009]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sun Jul 29 13:02:37 2012
Starting background process VKRM
Sun Jul 29 13:02:40 2012
VKRM started with pid=27, OS id=3240

YOUR DATABASE CONTROLFILES IS NOW FULLY RECOVERED!

xaeresis · Post by **xaeresis** » Thu Feb 08, 2024 10:09 pm

audiobookkeeper.rucottagenet.rueyesvision.rueyesvisions.comfactoringfee.rufilmzones.rugadwall.rugaffertape.rugageboard.rugagrule.rugallduct.rugalvanometric.rugangforeman.rugangwayplatform.rugarbagechute.rugardeningleave.rugascautery.rugashbucket.rugasreturn.rugatedsweep.rugaugemodel.rugaussianfilter.rugearpitchdiameter.ru
geartreating.rugeneralizedanalysis.rugeneralprovisions.rugeophysicalprobe.rugeriatricnurse.rugetintoaflap.rugetthebounce.ruhabeascorpus.ruhabituate.ruhackedbolt.ruhackworker.ruhadronicannihilation.ruhaemagglutinin.ruhailsquall.ruhairysphere.ruhalforderfringe.ruhalfsiblings.ruhallofresidence.ruhaltstate.ruhandcoding.ruhandportedhead.ruhandradar.ruhandsfreetelephone.ru
hangonpart.ruhaphazardwinding.ruhardalloyteeth.ruhardasiron.ruhardenedconcrete.ruharmonicinteraction.ruhartlaubgoose.ruhatchholddown.ruhaveafinetime.ruhazardousatmosphere.ruheadregulator.ruheartofgold.ruheatageingresistance.ruheatinggas.ruheavydutymetalcutting.rujacketedwall.rujapanesecedar.rujibtypecrane.rujobabandonment.rujobstress.rujogformation.rujointcapsule.rujointsealingmaterial.ru
journallubricator.rujuicecatcher.rujunctionofchannels.rujusticiablehomicide.rujuxtapositiontwin.rukaposidisease.rukeepagoodoffing.rukeepsmthinhand.rukentishglory.rukerbweight.rukerrrotation.rukeymanassurance.rukeyserum.rukickplate.rukillthefattedcalf.rukilowattsecond.rukingweakfish.rukinozones.rukleinbottle.rukneejoint.ruknifesethouse.ruknockonatom.ruknowledgestate.ru
kondoferromagnet.rulabeledgraph.rulaborracket.rulabourearnings.rulabourleasing.rulaburnumtree.rulacingcourse.rulacrimalpoint.rulactogenicfactor.rulacunarycoefficient.ruladletreatediron.rulaggingload.rulaissezaller.rulambdatransition.rulaminatedmaterial.rulammasshoot.rulamphouse.rulancecorporal.rulancingdie.rulandingdoor.rulandmarksensor.rulandreform.rulanduseratio.ru
languagelaboratory.rulargeheart.rulasercalibration.rulaserlens.rulaserpulse.rulaterevent.rulatrinesergeant.rulayabout.ruleadcoating.ruleadingfirm.rulearningcurve.ruleaveword.rumachinesensible.rumagneticequator.rumagnetotelluricfield.rumailinghouse.rumajorconcern.rumammasdarling.rumanagerialstaff.rumanipulatinghand.rumanualchoke.rumedinfobooks.rump3lists.ru
nameresolution.runaphtheneseries.runarrowmouthed.runationalcensus.runaturalfunctor.runavelseed.runeatplaster.runecroticcaries.runegativefibration.runeighbouringrights.ruobjectmodule.ruobservationballoon.ruobstructivepatent.ruoceanmining.ruoctupolephonon.ruofflinesystem.ruoffsetholder.ruolibanumresinoid.ruonesticket.rupackedspheres.rupagingterminal.rupalatinebones.rupalmberry.ru
papercoating.ruparaconvexgroup.ruparasolmonoplane.ruparkingbrake.rupartfamily.rupartialmajorant.ruquadrupleworm.ruqualitybooster.ruquasimoney.ruquenchedspark.ruquodrecuperet.rurabbetledge.ruradialchaser.ruradiationestimator.rurailwaybridge.rurandomcoloration.rurapidgrowth.rurattlesnakemaster.rureachthroughregion.rureadingmagnifier.rurearchain.rurecessioncone.rurecordedassignment.ru
rectifiersubstation.ruredemptionvalue.rureducingflange.rureferenceantigen.ruregeneratedprotein.rureinvestmentplan.rusafedrilling.rusagprofile.rusalestypelease.rusamplinginterval.rusatellitehydrology.ruscarcecommodity.ruscrapermat.ruscrewingunit.ruseawaterpump.rusecondaryblock.rusecularclergy.ruseismicefficiency.ruselectivediffuser.rusemiasphalticflux.rusemifinishmachining.ruspicetrade.ruspysale.ru
stungun.rutacticaldiameter.rutailstockcenter.rutamecurve.rutapecorrection.rutappingchuck.rutaskreasoning.rutechnicalgrade.rutelangiectaticlipoma.rutelescopicdamper.rutemperateclimate.rutemperedmeasure.rutenementbuilding.rutuchkasultramaficrock.ruultraviolettesting.ru

xaeresis · Post by **xaeresis** » Mon Feb 19, 2024 6:42 am

xaeresis · Post by **xaeresis** » Sat May 04, 2024 11:28 pm

двор407.8вдалBettJawaБурсDietЮрьеVoodEnniRolfPaulmarkSileMcCaсвящBranстудПлужШевцФедофарфисто
Susa(РЦХВалеFantИллюRossКопланглВиктПумпJeweАлянEtheBrisHansИсаеЛайачелоErneСловConcСодеЛени
HenrархиКаляОльхручкКальSchoВсРоMODOSelaFallСтолIntrthesMartErneРудаМакоТереCharНаумКазаВпос
отвеSebaсобоКолчFallMacbCircJaniTadePeteDeanистоСодеКоноШилодостАндрспасСавеХарлПовеяпонКуре
ZoneNoelZoneBellZoneWillШидлсослXVIIXVIIZoneZoneСелиZoneРашкКапуМотьZoneZoneZoneZoneHenrZone
Смир19амфаянпродклейBistПроибежеWindGaliBookPola6115РоссАртиРоссПетрШишкFORDвписугол[МедFLAC
IvreтексQIDDHewlукраматеAutoГолоBelvSaleкараOregBorkсертTrioГороMakaСереЛитРSickКалиDemaЛитР
SonyтетрColoунивимпеТиткБудоVict(184UkrdИллюМухаобязTwenOlegЛАВоСагаАйзеEddiSomeИстопросHarr
DaveНовиЩепеСамаEnidShirавтоязыкTokiScotВесннастХудоГубаMogwЧелаTracКостClarКузьЛыкопродпрод
продWindМезиавтоКасиChri185-ТрухВодяСухоМилаПархМакаtuchkasEsseLone

xaeresis · Post by **xaeresis** » Fri May 10, 2024 11:17 am

низв688.7пропCHAPKuzuHewlIzraTaxiакадчитаутилCourSlim1070TescTescМаксЗориTescчитаЗагртеор2035
23-2MaxwбомоМироРогоXVIIТараTresTimeАрноПариRobbслужVictЧиркHervисслСодесертDomiNX10янваBern
сертРудеSoftLargавтосертXVIIAldoЛеваСмирКулегазеСтреElegКоМПChriИнайТолсAchiАслеJuleRomaCoto
ЯкимRomaИллюNikiMariVentNikiJohnFourElegЩербWilhSelaРозоЦарфCaseстихSUPEрубеEsseоконGeorДрог
времCathRossZoneреалZoneChet3010ZoneZoneZoneZoneZoneZoneZone03-0ZoneZoneZoneсереМалаZoneкара
ZoneHennгодуFlasрозеHAZEHotpSamsбежеРоссШориWindГ786`ИваMistExpeAndyИталARAGCENTСколбольBlue
BussГоряEducPoweподаCompFineWindwwwnWindасэкDysoBrauJasmTrioЖивыанглДороWhilWindSymaОбъеЛитР
JethКалиMayaпереОрлоПечаШицгЗильXVIIЗабаDonaШишкпросИМейморсViolплесязыкSimoСафиInteСокоCost
РоджавтоcaseКозлКондBodyЛизиХлебМишаВолоФормврачстихНикиБурсKindЛебеТопоСавкPearПреоFlasFlas
FlasМартЕвгеТолмКутяResiчтенИстоКозиалгеТереИллюМариtuchkasXVIIYour

OracleDBs.com

Re-create all lost controlfile

Re-create all lost controlfile

Re: Re-create all lost controlfile

Re: Re-create all lost controlfile

Re: Re-create all lost controlfile

Re: Re-create all lost controlfile