1. backup the existing database.
orarac2poc:TTS:/u02/oradata> ls -l TTS
total 1916700
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 13:51 control01.ctl
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 13:51 control02.ctl
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 13:51 redo01.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 13:50 redo02.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 13:50 redo03.log
-rw-r----- 1 oracle asmadmin 629153792 Mar 21 13:51 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 734011392 Mar 21 13:51 system01.dbf
-rw-r----- 1 oracle asmadmin 61874176 Mar 20 17:52 temp01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Mar 21 10:25 tts1_01.dbf
-rw-r----- 1 oracle asmadmin 387981312 Mar 21 13:51 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Mar 21 13:51 users01.dbf
orarac2poc:TTS:/u02/oradata> mv TTS TTS_bak
orarac2poc:TTS:/u02/oradata> mkdir TTS
2. Restore controlfile first.
orarac2poc:TTS:/u02/oradata> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Mar 21 13:55:10 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 663908352 bytes
Fixed Size 2229440 bytes
Variable Size 251661120 bytes
Database Buffers 402653184 bytes
Redo Buffers 7364608 bytes
RMAN> list backup;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 03/21/2013 13:55:35
ORA-01507: database not mounted
RMAN> restore controlfile;
Starting restore at 21-MAR-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/21/2013 14:01:52
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
RMAN> restore controlfile from autobackup;
Starting restore at 21-MAR-13
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/21/2013 14:02:04
RMAN-06495: must explicitly specify DBID with SET DBID command
RMAN> shutdown abort
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Mar 21 14:05:05 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> set dbid 1769654909;
executing command: SET DBID
RMAN> restore database;
Starting restore at 21-MAR-13
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/21/2013 14:06:00
RMAN-12010: automatic channel allocation initialization failed
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
RMAN> startup nomount;
Oracle instance started
Total System Global Area 663908352 bytes
Fixed Size 2229440 bytes
Variable Size 251661120 bytes
Database Buffers 402653184 bytes
Redo Buffers 7364608 bytes
RMAN> set dbid 1769654909;
executing command: SET DBID
RMAN> restore database;
Starting restore at 21-MAR-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/21/2013 14:06:48
ORA-01507: database not mounted
RMAN> restore controlfile from autobackup;
Starting restore at 21-MAR-13
using channel ORA_DISK_1
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130321
channel ORA_DISK_1: AUTOBACKUP found: c-1769654909-20130321-00
channel ORA_DISK_1: restoring control file from AUTOBACKUP c-1769654909-20130321-00
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/u02/oradata/TTS/control01.ctl
output file name=/u02/oradata/TTS/control02.ctl
Finished restore at 21-MAR-13
orarac2poc:ORCL2:/u02/oradata> ls -l TTS
total 19072
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:06 control01.ctl
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:06 control02.ctl
#only control file are restored by now.
3. next, restore datafiles.
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 21-MAR-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u02/oradata/TTS/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u02/oradata/TTS/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u02/oradata/TTS/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u02/oradata/TTS/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u02/oradata/TTS/tts1_01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/11.2.0/db_2/dbs/01o536r8_1_1
channel ORA_DISK_1: piece handle=/u01/app/oracle/product/11.2.0/db_2/dbs/01o536r8_1_1 tag=TAG20130321T134928
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
Finished restore at 21-MAR-13
orarac2poc:ORCL2:/u02/oradata> ls -l TTS
total 1756512
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:12 control01.ctl
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:12 control02.ctl
-rw-r----- 1 oracle asmadmin 629153792 Mar 21 14:09 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 734011392 Mar 21 14:10 system01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Mar 21 14:08 tts1_01.dbf
-rw-r----- 1 oracle asmadmin 387981312 Mar 21 14:08 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Mar 21 14:08 users01.dbf
as we can see, REDO and TEMP files are not backed up and not restored as result.
4. recover the database and open database with resetlogs.
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/21/2013 14:11:10
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> recover database noredo;
Starting recover at 21-MAR-13
using channel ORA_DISK_1
datafile 5 not processed because file is read-only
Finished recover at 21-MAR-13
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/21/2013 14:12:33
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> alter database open resetlogs;
database opened
RMAN> exit
Recovery Manager complete.
orarac2poc:ORCL2:/u02/oradata> ls -l TTS
total 1911320
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:13 control01.ctl
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:13 control02.ctl
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:13 redo01.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:12 redo02.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:12 redo03.log
-rw-r----- 1 oracle asmadmin 629153792 Mar 21 14:12 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 734011392 Mar 21 14:12 system01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Mar 21 14:12 temp01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Mar 21 14:08 tts1_01.dbf
-rw-r----- 1 oracle asmadmin 387981312 Mar 21 14:12 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Mar 21 14:12 users01.dbf
5. Verification.
orarac2poc:TTS:/u02/oradata> ls -l
total 356
drwxr-xr-x 3 oracle oinstall 4096 Mar 5 16:06 DGLOGI
-rw-r----- 1 oracle oinstall 289692 Mar 20 17:53 install2013-03-20_17-30-09.log
-rw-r--r-- 1 oracle oinstall 52444 Mar 21 13:53 i.tar.gz
drwxr-xr-x 2 oracle oinstall 4096 Mar 21 14:12 TTS
drwxr-x--- 2 oracle oinstall 4096 Mar 21 10:18 TTS_bak
orarac2poc:TTS:/u02/oradata> du -sk TTS*
1911324 TTS
1916704 TTS_bak
orarac2poc:TTS:/u02/oradata> ls -l TTS*
TTS:
total 1911320
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:15 control01.ctl
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:15 control02.ctl
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:15 redo01.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:12 redo02.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:12 redo03.log
-rw-r----- 1 oracle asmadmin 629153792 Mar 21 14:12 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 734011392 Mar 21 14:12 system01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Mar 21 14:12 temp01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Mar 21 14:08 tts1_01.dbf
-rw-r----- 1 oracle asmadmin 387981312 Mar 21 14:12 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Mar 21 14:12 users01.dbf
TTS_bak:
total 1916700
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:04 control01.ctl
-rw-r----- 1 oracle asmadmin 9748480 Mar 21 14:04 control02.ctl
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:04 redo01.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:03 redo02.log
-rw-r----- 1 oracle asmadmin 52429312 Mar 21 14:03 redo03.log
-rw-r----- 1 oracle asmadmin 629153792 Mar 21 14:04 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 734011392 Mar 21 14:04 system01.dbf
-rw-r----- 1 oracle asmadmin 61874176 Mar 20 17:52 temp01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Mar 21 10:25 tts1_01.dbf
-rw-r----- 1 oracle asmadmin 387981312 Mar 21 14:04 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Mar 21 14:04 users01.dbf
orarac2poc:TTS:/u02/oradata> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Mar 21 14:16:09 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SYS@TTS> alter system checkpoint;
System altered.
SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------
NEXT_TIME
---------
1 1 1 52428800 512 1 NO CURRENT 721427 21-MAR-13 2.8147E+14
2 1 0 52428800 512 1 YES UNUSED 0 0
3 1 0 52428800 512 1 YES UNUSED 0 0
SYS@TTS> alter system switch logfile;
System altered.
SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------
NEXT_TIME
---------
1 1 1 52428800 512 1 NO INACTIVE 721427 21-MAR-13 721697
21-MAR-13
2 1 2 52428800 512 1 NO CURRENT 721697 21-MAR-13 2.8147E+14
3 1 0 52428800 512 1 YES UNUSED 0 0
6. The corresponding alert log
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db_2/dbs/spfileTTS.ora
System parameters with non-default values:
processes = 50
sessions = 98
sga_target = 636M
control_files = "/u02/oradata/TTS/control01.ctl"
control_files = "/u02/oradata/TTS/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=TTSXDB)"
audit_file_dest = "/u01/app/oracle/admin/TTS/adump"
audit_trail = "DB"
db_name = "TTS"
open_cursors = 300
pga_aggregate_target = 196M
diagnostic_dest = "/u01/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
169.254.231.131
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Thu Mar 21 14:06:17 2013
PMON started with pid=2, OS id=10900
Thu Mar 21 14:06:17 2013
PSP0 started with pid=3, OS id=10902
Thu Mar 21 14:06:18 2013
VKTM started with pid=4, OS id=10907 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Thu Mar 21 14:06:18 2013
GEN0 started with pid=5, OS id=10911
Thu Mar 21 14:06:18 2013
DIAG started with pid=6, OS id=10913
Thu Mar 21 14:06:19 2013
DBRM started with pid=7, OS id=10915
Thu Mar 21 14:06:19 2013
PING started with pid=8, OS id=10917
Thu Mar 21 14:06:19 2013
ACMS started with pid=9, OS id=10919
Thu Mar 21 14:06:19 2013
DIA0 started with pid=10, OS id=10921
Thu Mar 21 14:06:19 2013
LMON started with pid=11, OS id=10923
Thu Mar 21 14:06:19 2013
LMD0 started with pid=12, OS id=10925
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [1920 - 2560]
Thu Mar 21 14:06:19 2013
RMS0 started with pid=13, OS id=10927
Thu Mar 21 14:06:19 2013
LMHB started with pid=14, OS id=10929
Thu Mar 21 14:06:19 2013
MMAN started with pid=15, OS id=10931
Thu Mar 21 14:06:19 2013
DBW0 started with pid=16, OS id=10933
Thu Mar 21 14:06:19 2013
LGWR started with pid=17, OS id=10935
Thu Mar 21 14:06:19 2013
CKPT started with pid=18, OS id=10937
Thu Mar 21 14:06:19 2013
SMON started with pid=19, OS id=10939
Thu Mar 21 14:06:19 2013
RECO started with pid=20, OS id=10941
Thu Mar 21 14:06:19 2013
MMON started with pid=21, OS id=10943
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 21 14:06:19 2013
MMNL started with pid=22, OS id=10945
starting up 1 shared server(s) ...
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 2)
List of instances:
1 (myinst: 1)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Reconfiguration complete
ORACLE_BASE from environment = /u01/app/oracle
Thu Mar 21 14:06:20 2013
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.139.92.42)(PORT=1521))))' SCOPE=MEMORY SID='TTS';
Thu Mar 21 14:08:37 2013
alter database mount
Thu Mar 21 14:08:41 2013
Successful mount of redo thread 1, with mount id 1769701925
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Thu Mar 21 14:08:49 2013
Checker run found 6 new persistent data failures
Thu Mar 21 14:08:50 2013
Full restore complete of datafile 4 /u02/oradata/TTS/users01.dbf. Elapsed time: 0:00:01
checkpoint is 721426
last deallocation scn is 3
Full restore complete of datafile 5 /u02/oradata/TTS/tts1_01.dbf. Elapsed time: 0:00:02
checkpoint is 714646
last deallocation scn is 3
Full restore complete of datafile 3 /u02/oradata/TTS/undotbs01.dbf. Elapsed time: 0:00:05
checkpoint is 721426
last deallocation scn is 720265
Undo Optimization current scn is 719749
Thu Mar 21 14:09:55 2013
Full restore complete of datafile 2 /u02/oradata/TTS/sysaux01.dbf. Elapsed time: 0:01:05
checkpoint is 721426
last deallocation scn is 557345
Thu Mar 21 14:10:18 2013
Full restore complete of datafile 1 /u02/oradata/TTS/system01.dbf. Elapsed time: 0:01:29
checkpoint is 721426
last deallocation scn is 715712
Undo Optimization current scn is 719749
Thu Mar 21 14:11:09 2013
alter database open
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Thu Mar 21 14:12:33 2013
alter database open
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Thu Mar 21 14:12:46 2013
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 721426
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u02/oradata/TTS/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 /u02/oradata/TTS/redo01.log
Clearing online log 1 of thread 1 sequence number 52
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u02/oradata/TTS/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u02/oradata/TTS/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 complete
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u02/oradata/TTS/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 /u02/oradata/TTS/redo02.log
Clearing online log 2 of thread 1 sequence number 50
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u02/oradata/TTS/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u02/oradata/TTS/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 complete
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u02/oradata/TTS/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 /u02/oradata/TTS/redo03.log
Clearing online log 3 of thread 1 sequence number 51
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u02/oradata/TTS/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_11406.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u02/oradata/TTS/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 complete
Resetting resetlogs activation ID 1769682045 (0x697b347d)
Online log /u02/oradata/TTS/redo01.log: Thread 1 Group 1 was previously cleared
Online log /u02/oradata/TTS/redo02.log: Thread 1 Group 2 was previously cleared
Online log /u02/oradata/TTS/redo03.log: Thread 1 Group 3 was previously cleared
Thu Mar 21 14:12:48 2013
Setting recovery target incarnation to 2
Using SCN growth rate of 16384 per second
Thu Mar 21 14:12:48 2013
Assigning activation ID 1769701925 (0x697b8225)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u02/oradata/TTS/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Mar 21 14:12:48 2013
SMON: enabling cache recovery
[11406] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:1860542514 end:1860543284 diff:770 (7 seconds)
Dictionary check beginning
File #5 is offline, but is part of an online tablespace.
data file 5: '/u02/oradata/TTS/tts1_01.dbf'
Successfuly brought file #5 online.
Thu Mar 21 14:12:52 2013
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_dbw0_10933.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u02/oradata/TTS/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_dbw0_10933.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u02/oradata/TTS/temp01.dbf'
File 201 not verified due to error ORA-01157
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Re-creating tempfile /u02/oradata/TTS/temp01.dbf
Database Characterset is US7ASCII
Thu Mar 21 14:12:57 2013
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Mar 21 14:13:03 2013
QMNC started with pid=28, OS id=12035
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: alter database open resetlogs
Thu Mar 21 14:13:07 2013
Starting background process CJQ0
Thu Mar 21 14:13:07 2013
CJQ0 started with pid=31, OS id=12079
Popular Posts
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
SQL> select * from dba_data_files where tablespace_name='TESTBS'; FILE_NAME ...
-
As I have CPU issue with physical standby database in previous post, I have to remove it before I have the solution. In 12c Enterprise Man... -
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
This installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty.... -
Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second f...
-
RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # de...
-
I hit the error when using RMAN duplicate command to create a physical standby database, with purpose of using same directory structure in...