Experiment Objective:
Using RMAN in-completed recovery (Until particular archive log sequence)
1. Backup existing database to disk copy and note down the CURRENT REDO sequence right before the table is dropped
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 14:38:07 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
RMAN> backup incremental level 1 for recover of copy with tag daily_incr database;
Starting backup at 2013-04-05:14:38:23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=76 device type=DISK
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 6 found
no parent backup or copy of datafile 4 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u02/oradata/TTS/system01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf tag=DAILY_INCR RECID=103 STAMP=811953538
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:37
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u02/oradata/TTS/sysaux01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf tag=DAILY_INCR RECID=104 STAMP=811953570
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u02/oradata/TTS/undotbs01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf tag=DAILY_INCR RECID=105 STAMP=811953590
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u02/oradata/TTS/tts1_01.bdf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf tag=DAILY_INCR RECID=106 STAMP=811953594
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u02/oradata/TTS/testtbs1.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf tag=DAILY_INCR RECID=107 STAMP=811953595
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u02/oradata/TTS/users01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf tag=DAILY_INCR RECID=108 STAMP=811953596
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2013-04-05:14:39:57
Starting Control File and SPFILE Autobackup at 2013-04-05:14:39:57
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811953598_8owwfyv2_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:14:40:00
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> ls -l
total 1747704
-rw-r----- 1 oracle asmadmin 629153792 Apr 5 14:39 o1_mf_sysaux_8owwd7fd_.dbf
-rw-r----- 1 oracle asmadmin 734011392 Apr 5 14:38 o1_mf_system_8owwc247_.dbf
-rw-r----- 1 oracle asmadmin 10493952 Apr 5 14:39 o1_mf_testtbs_8owwfv98_.dbf
-rw-r----- 1 oracle asmadmin 20979712 Apr 5 14:39 o1_mf_tts1_8owwft1v_.dbf
-rw-r----- 1 oracle asmadmin 387981312 Apr 5 14:39 o1_mf_undotbs1_8owwfbql_.dbf
-rw-r----- 1 oracle asmadmin 5251072 Apr 5 14:39 o1_mf_users_8owwfwm8_.dbf
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> cd ..
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> cd autobackup/
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/autobackup> sl
-bash: sl: command not found
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/autobackup> ls -l
total 24
drwxr-x--- 2 oracle asmadmin 4096 Apr 2 09:15 2013_03_28
drwxr-x--- 2 oracle asmadmin 4096 Apr 2 09:43 2013_04_01
drwxr-x--- 2 oracle asmadmin 4096 Apr 2 18:06 2013_04_02
drwxr-x--- 2 oracle asmadmin 4096 Apr 5 14:33 2013_04_03
drwxr-x--- 2 oracle asmadmin 4096 Apr 5 14:33 2013_04_04
drwxr-x--- 2 oracle asmadmin 4096 Apr 5 14:39 2013_04_05
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/autobackup> cd 2013_04_05
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05> ls -l
total 9872
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 14:39 o1_mf_s_811953598_8owwfyv2_.bkp
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 14:49:56 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> select dbid from v$database;
DBID
----------
1769654909
SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05> cd /u02/oradata/TTS
orarac2poc:TTS:/u02/oradata/TTS> ls -l
total 1922112
drwxr-xr-x 2 oracle oinstall 4096 Apr 4 16:22 bak
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 14:50 control01.ctl
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 14:50 control02.ctl
drwxr-xr-x 3 oracle oinstall 4096 Mar 27 09:33 FRA
-rw-r--r-- 1 oracle oinstall 187 Apr 4 16:37 ls
-rw-r--r-- 1 oracle oinstall 394 Apr 4 16:25 manual_copy.sh
-rw-r----- 1 oracle asmadmin 52429312 Apr 5 03:00 redo01.log
-rw-r----- 1 oracle asmadmin 52429312 Apr 5 14:47 redo02.log
-rw-r----- 1 oracle asmadmin 52429312 Apr 4 16:41 redo03.log
-rw-r----- 1 oracle oinstall 629153792 Apr 5 14:39 sysaux01.dbf
-rw-r----- 1 oracle oinstall 734011392 Apr 5 14:38 system01.dbf
-rw-r----- 1 oracle asmadmin 20979712 Apr 4 18:00 temp01.dbf
-rw-r----- 1 oracle oinstall 10493952 Apr 5 14:39 testtbs1.dbf
-rw-r----- 1 oracle oinstall 20979712 Apr 5 14:39 tts1_01.bdf
-rw-r----- 1 oracle oinstall 387981312 Apr 5 14:39 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Apr 5 14:39 users01.dbf
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 14:51:00 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> select * from liqy.incr_changes;
C1 CHANGES
---------- --------------------
3 some changes
4 some more changes
5 change no apply
6 last change
9 using bakctrlfile2
1 init backup copy
2 change before crash
7 after PITR
8 using bakctrlfile
7 no online redo
10 rows selected.
SYS@TTS> exit
Disconnected from 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
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 14:52:03 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
14:52:03 SYS@TTS> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
14:54:28 SYS@TTS> exit
Disconnected from 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
eorarac2poc:TTS:/u02/oradata/TTS> echo "perform cold backup"
perform cold backup
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 15:08:09 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
15:08:09 SYS@TTS> startup
ORACLE instance started.
Total System Global Area 663908352 bytes
Fixed Size 2229440 bytes
Variable Size 281021248 bytes
Database Buffers 373293056 bytes
Redo Buffers 7364608 bytes
Database mounted.
Database opened.
15:08:36 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 1 52428800 512 1 YES INACTIVE 1372570 2013-04-04:16:41:22
1391687 2013-04-05:03:00:43
2 1 2 52428800 512 1 NO CURRENT 1391687 2013-04-05:03:00:43
2.8147E+14
3 1 0 52428800 512 1 YES UNUSED 0
0
15:08:54 SYS@TTS> select * from liqy.incr_changes;
C1 CHANGES
---------- --------------------
3 some changes
4 some more changes
5 change no apply
6 last change
9 using bakctrlfile2
1 init backup copy
2 change before crash
7 after PITR
8 using bakctrlfile
7 no online redo
10 rows selected.
15:09:10 SYS@TTS> insert into liqy.incr_changes values (10, 'change before drop');
1 row created.
15:09:44 SYS@TTS> commit;
Commit complete.
15:09:46 SYS@TTS> alter system switch logfile;
System altered.
15:09:58 SYS@TTS> select * from liqy.incr_changes;
C1 CHANGES
---------- --------------------
3 some changes
4 some more changes
5 change no apply
6 last change
9 using bakctrlfile2
10 change before drop
1 init backup copy
2 change before crash
7 after PITR
8 using bakctrlfile
7 no online redo
11 rows selected.
15:12:34 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 1 52428800 512 1 YES INACTIVE 1372570 2013-04-04:16:41:22
1391687 2013-04-05:03:00:43
2 1 2 52428800 512 1 YES ACTIVE 1391687 2013-04-05:03:00:43
1410960 2013-04-05:15:09:58
3 1 3 52428800 512 1 NO CURRENT 1410960 2013-04-05:15:09:58
2.8147E+14
15:12:45 SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 15:15:02 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
RMAN> backup incremental level 1 for recover of copy with tag daily_incr database;
Starting backup at 2013-04-05:15:15:12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/oradata/TTS/system01.dbf
input datafile file number=00002 name=/u02/oradata/TTS/sysaux01.dbf
input datafile file number=00003 name=/u02/oradata/TTS/undotbs01.dbf
input datafile file number=00005 name=/u02/oradata/TTS/tts1_01.bdf
input datafile file number=00006 name=/u02/oradata/TTS/testtbs1.dbf
input datafile file number=00004 name=/u02/oradata/TTS/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2013-04-05:15:15:16
channel ORA_DISK_1: finished piece 1 at 2013-04-05:15:16:01
piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8owyj4qv_.bkp tag=DAILY_INCR comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46
Finished backup at 2013-04-05:15:16:02
Starting Control File and SPFILE Autobackup at 2013-04-05:15:16:02
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811955762_8owykm1p_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:15:16:03
RMAN> backup as backupset archivelog all not backed up delete all input;
Starting backup at 2013-04-05:15:18:50
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=64 STAMP=811911664
input archived log thread=1 sequence=2 RECID=65 STAMP=811955399
input archived log thread=1 sequence=3 RECID=66 STAMP=811955930
channel ORA_DISK_1: starting piece 1 at 2013-04-05:15:18:51
channel ORA_DISK_1: finished piece 1 at 2013-04-05:15:18:54
piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_annnn_TAG20130405T151850_8owypv46_.bkp tag=TAG20130405T151850 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_1_8ovmhct9_.arc RECID=64 STAMP=811911664
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_2_8owy66og_.arc RECID=65 STAMP=811955399
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_3_8owyptdy_.arc RECID=66 STAMP=811955930
Finished backup at 2013-04-05:15:18:54
Starting Control File and SPFILE Autobackup at 2013-04-05:15:18:54
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811955934_8owypymj_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:15:18:55
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 15:20:17 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
15:20:18 SYS@TTS> select * from liqy.incr_changes;
C1 CHANGES
---------- --------------------
3 some changes
4 some more changes
5 change no apply
6 last change
9 using bakctrlfile2
10 change before drop
1 init backup copy
2 change before crash
7 after PITR
8 using bakctrlfile
7 no online redo
11 rows selected.
15:21:07 SYS@TTS> insert into liqy.incr_changes values (11, 'change2 before drop');
1 row created.
15:21:53 SYS@TTS> commit;
Commit complete.
15:22:01 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 4 52428800 512 1 NO CURRENT 1411185 2013-04-05:15:18:50
2.8147E+14
2 1 2 52428800 512 1 YES INACTIVE 1391687 2013-04-05:03:00:43
1410960 2013-04-05:15:09:58
3 1 3 52428800 512 1 YES ACTIVE 1410960 2013-04-05:15:09:58
1411185 2013-04-05:15:18:50
15:22:10 SYS@TTS> alter system switch logfile;
System altered.
15:22:24 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 4 52428800 512 1 YES ACTIVE 1411185 2013-04-05:15:18:50
1411345 2013-04-05:15:22:24
2 1 5 52428800 512 1 NO CURRENT 1411345 2013-04-05:15:22:24
2.8147E+14
3 1 3 52428800 512 1 YES ACTIVE 1410960 2013-04-05:15:09:58
1411185 2013-04-05:15:18:50
15:22:26 SYS@TTS> select controlfile_change# from v$database;
CONTROLFILE_CHANGE#
-------------------
1411395
15:24:39 SYS@TTS> select current_scn from v$database;
CURRENT_SCN
-----------
1411858
15:24:55 SYS@TTS> select file#, CHECKPOINT_CHANGE# from V$DATAFILE_HEADER;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1411185
2 1411185
3 1411185
4 1411185
5 1411185
6 1411185
6 rows selected.
15:25:08 SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 15:26:28 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
RMAN> backup incremental level 1 for recover of copy with tag daily_incr database;
Starting backup at 2013-04-05:15:26:33
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=76 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/oradata/TTS/system01.dbf
input datafile file number=00002 name=/u02/oradata/TTS/sysaux01.dbf
input datafile file number=00003 name=/u02/oradata/TTS/undotbs01.dbf
input datafile file number=00005 name=/u02/oradata/TTS/tts1_01.bdf
input datafile file number=00006 name=/u02/oradata/TTS/testtbs1.dbf
input datafile file number=00004 name=/u02/oradata/TTS/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2013-04-05:15:26:35
channel ORA_DISK_1: finished piece 1 at 2013-04-05:15:27:11
piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8owz5d0w_.bkp tag=DAILY_INCR comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
Finished backup at 2013-04-05:15:27:11
Starting Control File and SPFILE Autobackup at 2013-04-05:15:27:11
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811956431_8owz6jl0_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:15:27:14
RMAN> backup as backupset archivelog all not backed up delete all input;
Starting backup at 2013-04-05:15:28:29
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=67 STAMP=811956144
input archived log thread=1 sequence=5 RECID=68 STAMP=811956509
channel ORA_DISK_1: starting piece 1 at 2013-04-05:15:28:29
channel ORA_DISK_1: finished piece 1 at 2013-04-05:15:28:30
piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_annnn_TAG20130405T152829_8owz8xk6_.bkp tag=TAG20130405T152829 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_4_8owyxj80_.arc RECID=67 STAMP=811956144
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_5_8owz8x50_.arc RECID=68 STAMP=811956509
Finished backup at 2013-04-05:15:28:30
Starting Control File and SPFILE Autobackup at 2013-04-05:15:28:30
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811956510_8owz8ytt_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:15:28:31
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> echo "now drop the table"
now drop the table
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 15:29:21 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
15:29:21 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 4 52428800 512 1 YES INACTIVE 1411185 2013-04-05:15:18:50
1411345 2013-04-05:15:22:24
2 1 5 52428800 512 1 YES INACTIVE 1411345 2013-04-05:15:22:24
1411966 2013-04-05:15:28:29
3 1 6 52428800 512 1 NO CURRENT 1411966 2013-04-05:15:28:29
2.8147E+14
#the sequence number is 6, so we'll recover up to sequence 5. but note in Oracle command "UNTIL 6" means stopping roll-forward after applying everything in 5th archived log.
15:29:24 SYS@TTS> drop table liqy.incr_changes;
Table dropped.
15:29:36 SYS@TTS> alter system switch logfile;
System altered.
15:29:45 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 7 52428800 512 1 NO CURRENT 1412034 2013-04-05:15:29:45
2.8147E+14
2 1 5 52428800 512 1 YES INACTIVE 1411345 2013-04-05:15:22:24
1411966 2013-04-05:15:28:29
3 1 6 52428800 512 1 YES ACTIVE 1411966 2013-04-05:15:28:29
1412034 2013-04-05:15:29:45
15:29:47 SYS@TTS> prompt "table drop in sequence 6"
"table drop in sequence 6"
15:30:11 SYS@TTS> shutdown abort
ORACLE instance shut down.
15:31:52 SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> ls -lrt
total 1941600
drwxr-xr-x 3 oracle oinstall 4096 Mar 27 09:33 FRA
-rw-r--r-- 1 oracle oinstall 394 Apr 4 16:25 manual_copy.sh
-rw-r--r-- 1 oracle oinstall 187 Apr 4 16:37 ls
-rw-r----- 1 oracle oinstall 20979712 Apr 4 18:00 temp01.dbf
-rw-r--r-- 1 oracle oinstall 12 Apr 5 14:51 login.sql
drwxr-xr-x 2 oracle oinstall 4096 Apr 5 15:05 bak
-rw-r----- 1 oracle oinstall 5251072 Apr 5 15:28 users01.dbf
-rw-r----- 1 oracle oinstall 387981312 Apr 5 15:28 undotbs01.dbf
-rw-r----- 1 oracle oinstall 20979712 Apr 5 15:28 tts1_01.bdf
-rw-r----- 1 oracle oinstall 10493952 Apr 5 15:28 testtbs1.dbf
-rw-r----- 1 oracle oinstall 734011392 Apr 5 15:28 system01.dbf
-rw-r----- 1 oracle oinstall 629153792 Apr 5 15:28 sysaux01.dbf
-rw-r----- 1 oracle oinstall 52429312 Apr 5 15:28 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Apr 5 15:29 redo03.log
-rw-r----- 1 oracle oinstall 52429312 Apr 5 15:29 redo01.log
-rw-r----- 1 oracle oinstall 10010624 Apr 5 15:31 control02.ctl
-rw-r----- 1 oracle oinstall 10010624 Apr 5 15:31 control01.ctl
orarac2poc:TTS:/u02/oradata/TTS> gzip *.dbf *.ctl *.log *.bdf
orarac2poc:TTS:/u02/oradata/TTS> ls -l
total 220744
drwxr-xr-x 2 oracle oinstall 4096 Apr 5 15:05 bak
-rw-r----- 1 oracle oinstall 55239 Apr 5 15:31 control01.ctl.gz
-rw-r----- 1 oracle oinstall 55239 Apr 5 15:31 control02.ctl.gz
drwxr-xr-x 3 oracle oinstall 4096 Mar 27 09:33 FRA
-rw-r--r-- 1 oracle oinstall 12 Apr 5 14:51 login.sql
-rw-r--r-- 1 oracle oinstall 187 Apr 4 16:37 ls
-rw-r--r-- 1 oracle oinstall 394 Apr 4 16:25 manual_copy.sh
-rw-r----- 1 oracle oinstall 8805338 Apr 5 15:29 redo01.log.gz
-rw-r----- 1 oracle oinstall 4272099 Apr 5 15:28 redo02.log.gz
-rw-r----- 1 oracle oinstall 804795 Apr 5 15:29 redo03.log.gz
-rw-r----- 1 oracle oinstall 76557555 Apr 5 15:28 sysaux01.dbf.gz
-rw-r----- 1 oracle oinstall 127970636 Apr 5 15:28 system01.dbf.gz
-rw-r----- 1 oracle oinstall 22531 Apr 4 18:00 temp01.dbf.gz
-rw-r----- 1 oracle oinstall 24341 Apr 5 15:28 testtbs1.dbf.gz
-rw-r----- 1 oracle oinstall 1137516 Apr 5 15:28 tts1_01.bdf.gz
-rw-r----- 1 oracle oinstall 6012976 Apr 5 15:28 undotbs01.dbf.gz
-rw-r----- 1 oracle oinstall 13956 Apr 5 15:28 users01.dbf.gz
2. Now , assuming all datafiles and redo files are gone. We'll restore from backup control file
Here I purpose test few round restoration of controlfile with UNTIL different sequence REDO, but it shows only last in autobackup is restored. The MAXSEQ seems to be ingored.
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 16:34:43 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 281021248 bytes
Database Buffers 373293056 bytes
Redo Buffers 7364608 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 2013-04-05:16:35:16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 device type=DISK
recovery area destination: /u02/oradata/TTS/FRA
database name (or database unique name) used for search: TTS
channel ORA_DISK_1: AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811956510_8owz8ytt_.bkp found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811956510_8owz8ytt_.bkp
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 2013-04-05:16:35:19
RMAN> shutdown immediate
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> ls -l *.ctl
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:35 control01.ctl
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:35 control02.ctl
orarac2poc:TTS:/u02/oradata/TTS> rm *.ctl
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 16:36:00 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 281021248 bytes
Database Buffers 373293056 bytes
Redo Buffers 7364608 bytes
RMAN> set dbid 1769654909;
executing command: SET DBID
RMAN> restore controlfile from autobackup;
Starting restore at 2013-04-05:16:36:40
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 device type=DISK
recovery area destination: /u02/oradata/TTS/FRA
database name (or database unique name) used for search: TTS
channel ORA_DISK_1: AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811956510_8owz8ytt_.bkp found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130405
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811956510_8owz8ytt_.bkp
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 2013-04-05:16:36:43
RMAN> shutdown immediate
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> ls -l *.ctl
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:36 control01.ctl
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:36 control02.ctl
orarac2poc:TTS:/u02/oradata/TTS> rm *.ctl
orarac2poc:TTS:/u02/oradata/TTS> gunzip *.gz
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 16:42:18 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
16:42:18 SYS@TTS> startup
ORACLE instance started.
Total System Global Area 663908352 bytes
Fixed Size 2229440 bytes
Variable Size 281021248 bytes
Database Buffers 373293056 bytes
Redo Buffers 7364608 bytes
Database mounted.
Database opened.
16:42:49 SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 16:42:56 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
RMAN> backup incremental level 1 for recover of copy with tag daily_incr database;
Starting backup at 2013-04-05:16:43:09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/oradata/TTS/system01.dbf
input datafile file number=00002 name=/u02/oradata/TTS/sysaux01.dbf
input datafile file number=00003 name=/u02/oradata/TTS/undotbs01.dbf
input datafile file number=00005 name=/u02/oradata/TTS/tts1_01.bdf
input datafile file number=00006 name=/u02/oradata/TTS/testtbs1.dbf
input datafile file number=00004 name=/u02/oradata/TTS/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2013-04-05:16:43:13
channel ORA_DISK_1: finished piece 1 at 2013-04-05:16:43:48
piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8ox3o1nz_.bkp tag=DAILY_INCR comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 2013-04-05:16:43:48
Starting Control File and SPFILE Autobackup at 2013-04-05:16:43:48
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961028_8ox3p56w_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:16:43:49
RMAN> backup as backupset archivelog all not backed up delete all input;
Starting backup at 2013-04-05:16:44:00
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=69 STAMP=811956585
input archived log thread=1 sequence=7 RECID=70 STAMP=811960965
input archived log thread=1 sequence=8 RECID=71 STAMP=811961040
channel ORA_DISK_1: starting piece 1 at 2013-04-05:16:44:01
channel ORA_DISK_1: finished piece 1 at 2013-04-05:16:44:02
piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_annnn_TAG20130405T164401_8ox3pk8h_.bkp tag=TAG20130405T164401 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_6_8owzc95j_.arc RECID=69 STAMP=811956585
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_7_8ox3n54m_.arc RECID=70 STAMP=811960965
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_8_8ox3pjtf_.arc RECID=71 STAMP=811961040
Finished backup at 2013-04-05:16:44:02
Starting Control File and SPFILE Autobackup at 2013-04-05:16:44:02
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:16:44:03
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 16:44:08 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
16:44:08 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 7 52428800 512 1 YES INACTIVE 1412034 2013-04-05:15:29:45
1432037 2013-04-05:16:42:44
2 1 8 52428800 512 1 YES INACTIVE 1432037 2013-04-05:16:42:44
1432388 2013-04-05:16:44:00
3 1 9 52428800 512 1 NO CURRENT 1432388 2013-04-05:16:44:00
2.8147E+14
16:44:12 SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 16:44:17 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
16:44:18 SYS@TTS> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:44:31 SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> ls -l
total 1941600
drwxr-xr-x 2 oracle oinstall 4096 Apr 5 15:05 bak
-rw-r----- 1 oracle oinstall 10010624 Apr 5 16:44 control01.ctl
-rw-r----- 1 oracle oinstall 10010624 Apr 5 16:44 control02.ctl
drwxr-xr-x 3 oracle oinstall 4096 Mar 27 09:33 FRA
-rw-r--r-- 1 oracle oinstall 12 Apr 5 14:51 login.sql
-rw-r--r-- 1 oracle oinstall 187 Apr 4 16:37 ls
-rw-r--r-- 1 oracle oinstall 394 Apr 4 16:25 manual_copy.sh
-rw-r----- 1 oracle oinstall 52429312 Apr 5 16:42 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Apr 5 16:44 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Apr 5 16:44 redo03.log
-rw-r----- 1 oracle oinstall 629153792 Apr 5 16:44 sysaux01.dbf
-rw-r----- 1 oracle oinstall 734011392 Apr 5 16:44 system01.dbf
-rw-r----- 1 oracle oinstall 20979712 Apr 4 18:00 temp01.dbf
-rw-r----- 1 oracle oinstall 10493952 Apr 5 16:44 testtbs1.dbf
-rw-r----- 1 oracle oinstall 20979712 Apr 5 16:44 tts1_01.bdf
-rw-r----- 1 oracle oinstall 387981312 Apr 5 16:44 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Apr 5 16:44 users01.dbf
orarac2poc:TTS:/u02/oradata/TTS> gzip *.dbf *.ctl *.log *.bdf
orarac2poc:TTS:/u02/oradata/TTS> ls -l
total 220772
drwxr-xr-x 2 oracle oinstall 4096 Apr 5 15:05 bak
-rw-r----- 1 oracle oinstall 55951 Apr 5 16:44 control01.ctl.gz
-rw-r----- 1 oracle oinstall 55951 Apr 5 16:44 control02.ctl.gz
drwxr-xr-x 3 oracle oinstall 4096 Mar 27 09:33 FRA
-rw-r--r-- 1 oracle oinstall 12 Apr 5 14:51 login.sql
-rw-r--r-- 1 oracle oinstall 187 Apr 4 16:37 ls
-rw-r--r-- 1 oracle oinstall 394 Apr 4 16:25 manual_copy.sh
-rw-r----- 1 oracle oinstall 8803712 Apr 5 16:42 redo01.log.gz
-rw-r----- 1 oracle oinstall 4270174 Apr 5 16:44 redo02.log.gz
-rw-r----- 1 oracle oinstall 841195 Apr 5 16:44 redo03.log.gz
-rw-r----- 1 oracle oinstall 76557468 Apr 5 16:44 sysaux01.dbf.gz
-rw-r----- 1 oracle oinstall 127956472 Apr 5 16:44 system01.dbf.gz
-rw-r----- 1 oracle oinstall 22531 Apr 4 18:00 temp01.dbf.gz
-rw-r----- 1 oracle oinstall 24351 Apr 5 16:44 testtbs1.dbf.gz
-rw-r----- 1 oracle oinstall 1137518 Apr 5 16:44 tts1_01.bdf.gz
-rw-r----- 1 oracle oinstall 6017554 Apr 5 16:44 undotbs01.dbf.gz
-rw-r----- 1 oracle oinstall 13957 Apr 5 16:44 users01.dbf.gz
orarac2poc:TTS:/u02/oradata/TTS> rm ls
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 16:48:01 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 281021248 bytes
Database Buffers 373293056 bytes
Redo Buffers 7364608 bytes
RMAN> restore controlfile from autobackup maxseq 6 ;
Starting restore at 2013-04-05:16:49:41
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=50 device type=DISK
recovery area destination: /u02/oradata/TTS/FRA
database name (or database unique name) used for search: TTS
channel ORA_DISK_1: AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
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 2013-04-05:16:49:45
RMAN> host 'ls -lrt /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/'
2> ;
total 69104
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 14:39 o1_mf_s_811953598_8owwfyv2_.bkp
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 15:16 o1_mf_s_811955762_8owykm1p_.bkp
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 15:18 o1_mf_s_811955934_8owypymj_.bkp
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 15:27 o1_mf_s_811956431_8owz6jl0_.bkp
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 15:28 o1_mf_s_811956510_8owz8ytt_.bkp
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 16:43 o1_mf_s_811961028_8ox3p56w_.bkp
-rw-r----- 1 oracle asmadmin 10092544 Apr 5 16:44 o1_mf_s_811961042_8ox3plm1_.bkp
host command complete
RMAN> restore controlfile from autobackup maxseq 6 maxdays 2;
Starting restore at 2013-04-05:16:53:29
using channel ORA_DISK_1
recovery area destination: /u02/oradata/TTS/FRA
database name (or database unique name) used for search: TTS
channel ORA_DISK_1: AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
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 2013-04-05:16:53:31
RMAN> alter database mount ;
database mounted
released channel: ORA_DISK_1
RMAN> host 'ls -l ';
total 240352
drwxr-xr-x 2 oracle oinstall 4096 Apr 5 15:05 bak
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:54 control01.ctl
-rw-r----- 1 oracle oinstall 55951 Apr 5 16:44 control01.ctl.gz
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:54 control02.ctl
-rw-r----- 1 oracle oinstall 55951 Apr 5 16:44 control02.ctl.gz
drwxr-xr-x 3 oracle oinstall 4096 Mar 27 09:33 FRA
-rw-r--r-- 1 oracle oinstall 12 Apr 5 14:51 login.sql
-rw-r--r-- 1 oracle oinstall 394 Apr 4 16:25 manual_copy.sh
-rw-r----- 1 oracle oinstall 8803712 Apr 5 16:42 redo01.log.gz
-rw-r----- 1 oracle oinstall 4270174 Apr 5 16:44 redo02.log.gz
-rw-r----- 1 oracle oinstall 841195 Apr 5 16:44 redo03.log.gz
-rw-r----- 1 oracle oinstall 76557468 Apr 5 16:44 sysaux01.dbf.gz
-rw-r----- 1 oracle oinstall 127956472 Apr 5 16:44 system01.dbf.gz
-rw-r----- 1 oracle oinstall 22531 Apr 4 18:00 temp01.dbf.gz
-rw-r----- 1 oracle oinstall 24351 Apr 5 16:44 testtbs1.dbf.gz
-rw-r----- 1 oracle oinstall 1137518 Apr 5 16:44 tts1_01.bdf.gz
-rw-r----- 1 oracle oinstall 6017554 Apr 5 16:44 undotbs01.dbf.gz
-rw-r----- 1 oracle oinstall 13957 Apr 5 16:44 users01.dbf.gz
host command complete
RMAN> shutdown immediate
database dismounted
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> ls -l *.ctl
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:54 control01.ctl
-rw-r----- 1 oracle asmadmin 10010624 Apr 5 16:54 control02.ctl
orarac2poc:TTS:/u02/oradata/TTS> rm con*.ctl
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 16:55:02 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 281021248 bytes
Database Buffers 373293056 bytes
Redo Buffers 7364608 bytes
RMAN> set dbid 1769654909;
executing command: SET DBID
RMAN> restore controlfile from autobackup maxseq 6 maxdays 2;
Starting restore at 2013-04-05:16:55:33
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 device type=DISK
recovery area destination: /u02/oradata/TTS/FRA
database name (or database unique name) used for search: TTS
channel ORA_DISK_1: AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130405
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
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 2013-04-05:16:55:35
RMAN> restore controlfile from autobackup maxseq 4 maxdays 2;
Starting restore at 2013-04-05:16:56:31
using channel ORA_DISK_1
recovery area destination: /u02/oradata/TTS/FRA
database name (or database unique name) used for search: TTS
channel ORA_DISK_1: AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp found in the recovery area
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
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 2013-04-05:16:56:32
RMAN> restore controlfile from autobackup maxseq 6 maxdays 2;
Starting restore at 2013-04-05:16:56:39
using channel ORA_DISK_1
recovery area destination: /u02/oradata/TTS/FRA
database name (or database unique name) used for search: TTS
channel ORA_DISK_1: AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130405
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
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 2013-04-05:16:56:40
RMAN> alter database mount ;
database mounted
released channel: ORA_DISK_1
3. Restore database and recover it
RMAN> restore database until sequence 6;
Starting restore at 2013-04-05:16:57:11
Starting implicit crosscheck backup at 2013-04-05:16:57:11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 device type=DISK
Crosschecked 28 objects
Finished implicit crosscheck backup at 2013-04-05:16:57:14
Starting implicit crosscheck copy at 2013-04-05:16:57:14
using channel ORA_DISK_1
Crosschecked 6 objects
Finished implicit crosscheck copy at 2013-04-05:16:57:15
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_28/o1_mf_s_811272380_8o835wv5_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868418_8ot982xv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868443_8ot98vgk_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868428_8ot98djk_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868201_8ot91b5p_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868233_8ot929rp_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868221_8ot91xwf_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811703243_8oo7ydpz_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706806_8oocfp72_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811702379_8oo73cv1_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811702849_8oo7l23n_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706780_8oocdwsh_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811691536_8onwjk4p_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811693094_8ony16vx_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706022_8oobo6ws_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706727_8oocc868_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811703321_8oo80sjq_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769873_8oq90kjv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769586_8oq8qlmd_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769883_8oq90vbw_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811780266_8oqm5bsv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769838_8oq8zh0h_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769291_8oq8gcoq_.bkp
using channel ORA_DISK_1
channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=103 STAMP=811953538 file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf
destination for restore of datafile 00001: /u02/oradata/TTS/system01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00001
output file name=/u02/oradata/TTS/system01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00002
input datafile copy RECID=104 STAMP=811953570 file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf
destination for restore of datafile 00002: /u02/oradata/TTS/sysaux01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00002
output file name=/u02/oradata/TTS/sysaux01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=105 STAMP=811953590 file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf
destination for restore of datafile 00003: /u02/oradata/TTS/undotbs01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00003
output file name=/u02/oradata/TTS/undotbs01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=108 STAMP=811953596 file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf
destination for restore of datafile 00004: /u02/oradata/TTS/users01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00004
output file name=/u02/oradata/TTS/users01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00005
input datafile copy RECID=106 STAMP=811953594 file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf
destination for restore of datafile 00005: /u02/oradata/TTS/tts1_01.bdf
channel ORA_DISK_1: copied datafile copy of datafile 00005
output file name=/u02/oradata/TTS/tts1_01.bdf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00006
input datafile copy RECID=107 STAMP=811953595 file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf
destination for restore of datafile 00006: /u02/oradata/TTS/testtbs1.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00006
output file name=/u02/oradata/TTS/testtbs1.dbf RECID=0 STAMP=0
Finished restore at 2013-04-05:16:58:55
RMAN> recover database until sequence 6;
Starting recover at 2013-04-05:16:59:57
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u02/oradata/TTS/system01.dbf
destination for restore of datafile 00002: /u02/oradata/TTS/sysaux01.dbf
destination for restore of datafile 00003: /u02/oradata/TTS/undotbs01.dbf
destination for restore of datafile 00004: /u02/oradata/TTS/users01.dbf
destination for restore of datafile 00005: /u02/oradata/TTS/tts1_01.bdf
destination for restore of datafile 00006: /u02/oradata/TTS/testtbs1.dbf
channel ORA_DISK_1: reading from backup piece /u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8owyj4qv_.bkp
channel ORA_DISK_1: piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8owyj4qv_.bkp tag=DAILY_INCR
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u02/oradata/TTS/system01.dbf
destination for restore of datafile 00002: /u02/oradata/TTS/sysaux01.dbf
destination for restore of datafile 00003: /u02/oradata/TTS/undotbs01.dbf
destination for restore of datafile 00004: /u02/oradata/TTS/users01.dbf
destination for restore of datafile 00005: /u02/oradata/TTS/tts1_01.bdf
destination for restore of datafile 00006: /u02/oradata/TTS/testtbs1.dbf
channel ORA_DISK_1: reading from backup piece /u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8owz5d0w_.bkp
channel ORA_DISK_1: piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8owz5d0w_.bkp tag=DAILY_INCR
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=5
channel ORA_DISK_1: reading from backup piece /u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_annnn_TAG20130405T152829_8owz8xk6_.bkp
channel ORA_DISK_1: piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_annnn_TAG20130405T152829_8owz8xk6_.bkp tag=TAG20130405T152829
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_5_8ox4nlfy_.arc thread=1 sequence=5
channel default: deleting archived log(s)
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_5_8ox4nlfy_.arc RECID=72 STAMP=811962002
media recovery complete, elapsed time: 00:00:01
Finished recover at 2013-04-05:17:00:04
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 5 17:00:30 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
17:00:30 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 7 52428800 512 1 YES INACTIVE 1412034 2013-04-05:15:29:45
1432037 2013-04-05:16:42:44
3 1 9 52428800 512 1 NO CURRENT 1432388 2013-04-05:16:44:00
2.8147E+14
2 1 8 52428800 512 1 YES ACTIVE 1432037 2013-04-05:16:42:44
1432388 2013-04-05:16:44:00
17:00:41 SYS@TTS> select current_scn from v$database;
CURRENT_SCN
-----------
0
17:00:55 SYS@TTS> select file#, CHECKPOINT_CHANGE# from V$DATAFILE_HEADER;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1411966
2 1411966
3 1411966
4 1411966
5 1411966
6 1411966
6 rows selected.
17:01:00 SYS@TTS> select controlfile_change# from v$database;
CONTROLFILE_CHANGE#
-------------------
1432397
17:01:19 SYS@TTS> alter database open read only ;
Database altered.
#strange , according to metalink doc, such in-completed recovery doesn't support "open read only".
17:01:42 SYS@TTS> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
NEXT_CHANGE# NEXT_TIME
------------ -------------------
1 1 7 52428800 512 1 YES INACTIVE 1412034 2013-04-05:15:29:45
1432037 2013-04-05:16:42:44
2 1 8 52428800 512 1 YES ACTIVE 1432037 2013-04-05:16:42:44
1432388 2013-04-05:16:44:00
3 1 9 52428800 512 1 NO CURRENT 1432388 2013-04-05:16:44:00
2.8147E+14
17:01:50 SYS@TTS> select * from liqy.incr_changes;
C1 CHANGES
---------- --------------------
3 some changes
4 some more changes
5 change no apply
6 last change
9 using bakctrlfile2
10 change before drop
1 init backup copy
2 change before crash
7 after PITR
8 using bakctrlfile
7 no online redo
11 change2 before drop
12 rows selected.
17:02:03 SYS@TTS> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
17:02:25 SYS@TTS> startup mount
ORACLE instance started.
Total System Global Area 663908352 bytes
Fixed Size 2229440 bytes
Variable Size 281021248 bytes
Database Buffers 373293056 bytes
Redo Buffers 7364608 bytes
Database mounted.
17:02:55 SYS@TTS> alter database open resetlogs ;
Database altered.
17:04:48 SYS@TTS> select * from v$database_incarnation;
INCARNATION# RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TIM STATUS RESETLOGS_ID
------------ ----------------- ------------------- ----------------------- ------------------- ------- ------------
PRIOR_INCARNATION# FLASHBACK_DATABASE_ALLOWED
------------------ --------------------------
1 1 2013-03-20:16:41:33 0 PARENT 810578493
0 NO
2 721427 2013-03-21:14:12:46 1 2013-03-20:16:41:33 PARENT 810655966
1 NO
3 1009055 2013-03-27:09:44:13 721427 2013-03-21:14:12:46 PARENT 811158253
2 NO
4 1019618 2013-03-27:15:11:48 1009055 2013-03-27:09:44:13 PARENT 811177908
3 NO
5 1021343 2013-03-27:15:43:03 1019618 2013-03-27:15:11:48 PARENT 811179783
4 NO
6 1147625 2013-03-28:17:35:21 1021343 2013-03-27:15:43:03 PARENT 811272921
5 NO
7 1368073 2013-04-04:12:47:03 1147625 2013-03-28:17:35:21 PARENT 811860423
6 NO
8 1371062 2013-04-04:14:27:49 1368073 2013-04-04:12:47:03 PARENT 811866469
7 NO
9 1335171 2013-04-02:10:17:03 1147625 2013-03-28:17:35:21 ORPHAN 811678623
6 NO
10 1372570 2013-04-04:16:41:22 1371062 2013-04-04:14:27:49 PARENT 811874482
8 NO
11 1411967 2013-04-05:17:04:27 1372570 2013-04-04:16:41:22 CURRENT 811962267
10 NO
11 rows selected.
17:05:29 SYS@TTS> exit
Disconnected from 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
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 17:05:36 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
RMAN> list incarnation;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 TTS 1769654909 PARENT 1 2013-03-20:16:41:33
2 2 TTS 1769654909 PARENT 721427 2013-03-21:14:12:46
3 3 TTS 1769654909 PARENT 1009055 2013-03-27:09:44:13
4 4 TTS 1769654909 PARENT 1019618 2013-03-27:15:11:48
5 5 TTS 1769654909 PARENT 1021343 2013-03-27:15:43:03
6 6 TTS 1769654909 PARENT 1147625 2013-03-28:17:35:21
9 9 TTS 1769654909 ORPHAN 1335171 2013-04-02:10:17:03
7 7 TTS 1769654909 PARENT 1368073 2013-04-04:12:47:03
8 8 TTS 1769654909 PARENT 1371062 2013-04-04:14:27:49
10 10 TTS 1769654909 PARENT 1372570 2013-04-04:16:41:22
11 11 TTS 1769654909 CURRENT 1411967 2013-04-05:17:04:27
RMAN> exit
4. verify if disk copy becomes invalid.
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Apr 5 17:05:48 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
RMAN> crosscheck copy ;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 device type=DISK
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf RECID=103 STAMP=811953538
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf RECID=104 STAMP=811953570
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf RECID=105 STAMP=811953590
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf RECID=108 STAMP=811953596
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf RECID=106 STAMP=811953594
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf RECID=107 STAMP=811953595
Crosschecked 6 objects
RMAN> list copy;
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - ------------------- ---------- -------------------
103 1 A 2013-04-05:14:38:58 1410192 2013-04-05:14:38:25
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf
Tag: DAILY_INCR
104 2 A 2013-04-05:14:39:30 1410208 2013-04-05:14:39:03
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf
Tag: DAILY_INCR
105 3 A 2013-04-05:14:39:50 1410220 2013-04-05:14:39:38
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf
Tag: DAILY_INCR
108 4 A 2013-04-05:14:39:56 1410229 2013-04-05:14:39:56
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf
Tag: DAILY_INCR
106 5 A 2013-04-05:14:39:54 1410227 2013-04-05:14:39:54
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf
Tag: DAILY_INCR
107 6 A 2013-04-05:14:39:55 1410228 2013-04-05:14:39:55
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf
Tag: DAILY_INCR
RMAN> backup incremental level 1 for recover of copy with tag daily_incr database;
Starting backup at 2013-04-05:17:06:40
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/oradata/TTS/system01.dbf
input datafile file number=00002 name=/u02/oradata/TTS/sysaux01.dbf
input datafile file number=00003 name=/u02/oradata/TTS/undotbs01.dbf
input datafile file number=00005 name=/u02/oradata/TTS/tts1_01.bdf
input datafile file number=00006 name=/u02/oradata/TTS/testtbs1.dbf
input datafile file number=00004 name=/u02/oradata/TTS/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2013-04-05:17:06:41
channel ORA_DISK_1: finished piece 1 at 2013-04-05:17:07:26
piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_05/o1_mf_nnnd1_DAILY_INCR_8ox51206_.bkp tag=DAILY_INCR comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 2013-04-05:17:07:27
Starting Control File and SPFILE Autobackup at 2013-04-05:17:07:27
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811962447_8ox52k2o_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-04-05:17:07:30
5. The alert log
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Private Interface 'eth2:1' configured from GPnP for use as a private interconnect.
[name='eth2:1', type=1, ip=169.254.231.131, mac=00-50-56-9c-1d-68, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'eth0' configured from GPnP for use as a public interface.
[name='eth0', type=1, ip=10.139.90.42, mac=00-50-56-9c-3d-c2, net=10.139.0.0/16, mask=255.255.0.0, use=public/1]
Public Interface 'eth0:1' configured from GPnP for use as a public interface.
[name='eth0:1', type=1, ip=10.139.92.42, mac=00-50-56-9c-3d-c2, net=10.139.0.0/16, mask=255.255.0.0, use=public/1]
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
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"
log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST"
db_recovery_file_dest = "/u02/oradata/TTS/FRA"
db_recovery_file_dest_size= 2500M
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
Fri Apr 05 16:55:17 2013
PMON started with pid=2, OS id=19314
Fri Apr 05 16:55:17 2013
PSP0 started with pid=3, OS id=19316
Fri Apr 05 16:55:18 2013
VKTM started with pid=4, OS id=19322 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Fri Apr 05 16:55:18 2013
GEN0 started with pid=5, OS id=19326
Fri Apr 05 16:55:18 2013
DIAG started with pid=6, OS id=19329
Fri Apr 05 16:55:18 2013
DBRM started with pid=7, OS id=19331
Fri Apr 05 16:55:18 2013
PING started with pid=8, OS id=19333
Fri Apr 05 16:55:18 2013
ACMS started with pid=9, OS id=19335
Fri Apr 05 16:55:18 2013
DIA0 started with pid=10, OS id=19337
Fri Apr 05 16:55:18 2013
LMON started with pid=11, OS id=19339
Fri Apr 05 16:55:19 2013
LMD0 started with pid=12, OS id=19341
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [1920 - 2560]
Fri Apr 05 16:55:19 2013
RMS0 started with pid=13, OS id=19343
Fri Apr 05 16:55:19 2013
LMHB started with pid=14, OS id=19346
Fri Apr 05 16:55:19 2013
MMAN started with pid=15, OS id=19348
Fri Apr 05 16:55:19 2013
DBW0 started with pid=16, OS id=19350
Fri Apr 05 16:55:19 2013
LGWR started with pid=17, OS id=19352
Fri Apr 05 16:55:19 2013
CKPT started with pid=18, OS id=19355
Fri Apr 05 16:55:19 2013
SMON started with pid=19, OS id=19358
Fri Apr 05 16:55:19 2013
RECO started with pid=20, OS id=19360
Fri Apr 05 16:55:19 2013
MMON started with pid=21, OS id=19362
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Apr 05 16:55:19 2013
MMNL started with pid=22, OS id=19364
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
Fri Apr 05 16:55:21 2013
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.139.92.42)(PORT=1521))))' SCOPE=MEMORY SID='TTS';
Fri Apr 05 16:56:52 2013
alter database mount
Fri Apr 05 16:56:56 2013
Successful mount of redo thread 1, with mount id 1771016212
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Fri Apr 05 16:57:18 2013
Checker run found 7 new persistent data failures
Fri Apr 05 16:57:56 2013
Restore of datafile copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf complete to datafile 1 /u02/oradata/TTS/system01.dbf
checkpoint is 1410192
Fri Apr 05 16:58:26 2013
Restore of datafile copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf complete to datafile 2 /u02/oradata/TTS/sysaux01.dbf
checkpoint is 1410208
Fri Apr 05 16:58:44 2013
Restore of datafile copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf complete to datafile 3 /u02/oradata/TTS/undotbs01.dbf
checkpoint is 1410220
Restore of datafile copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf complete to datafile 4 /u02/oradata/TTS/users01.dbf
checkpoint is 1410229
Restore of datafile copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf complete to datafile 5 /u02/oradata/TTS/tts1_01.bdf
checkpoint is 1410227
Fri Apr 05 16:58:55 2013
Restore of datafile copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf complete to datafile 6 /u02/oradata/TTS/testtbs1.dbf
checkpoint is 1410228
Fri Apr 05 16:59:58 2013
Incremental restore complete of datafile 4 /u02/oradata/TTS/users01.dbf
checkpoint is 1411085
last deallocation scn is 3
Incremental restore complete of datafile 6 /u02/oradata/TTS/testtbs1.dbf
checkpoint is 1411085
Incremental restore complete of datafile 5 /u02/oradata/TTS/tts1_01.bdf
checkpoint is 1411085
last deallocation scn is 3
Incremental restore complete of datafile 3 /u02/oradata/TTS/undotbs01.dbf
checkpoint is 1411085
last deallocation scn is 1104578
Incremental restore complete of datafile 2 /u02/oradata/TTS/sysaux01.dbf
checkpoint is 1411085
last deallocation scn is 557345
Incremental restore complete of datafile 1 /u02/oradata/TTS/system01.dbf
checkpoint is 1411085
last deallocation scn is 1101545
Incremental restore complete of datafile 4 /u02/oradata/TTS/users01.dbf
checkpoint is 1411906
last deallocation scn is 3
Incremental restore complete of datafile 6 /u02/oradata/TTS/testtbs1.dbf
checkpoint is 1411906
Incremental restore complete of datafile 5 /u02/oradata/TTS/tts1_01.bdf
checkpoint is 1411906
last deallocation scn is 3
Incremental restore complete of datafile 3 /u02/oradata/TTS/undotbs01.dbf
checkpoint is 1411906
last deallocation scn is 1104578
Incremental restore complete of datafile 2 /u02/oradata/TTS/sysaux01.dbf
checkpoint is 1411906
last deallocation scn is 557345
Incremental restore complete of datafile 1 /u02/oradata/TTS/system01.dbf
checkpoint is 1411906
last deallocation scn is 1101545
Fri Apr 05 17:00:00 2013
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: alter database recover if needed
start until cancel using backup controlfile
...
alter database recover logfile '/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_5_8ox4nlfy_.arc'
Media Recovery Log /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_5_8ox4nlfy_.arc
ORA-279 signalled during: alter database recover logfile '/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_05/o1_mf_1_5_8ox4nlfy_.arc'...
alter database recover cancel
Media Recovery Canceled
Completed: alter database recover cancel
Fri Apr 05 17:01:28 2013
alter database open read only
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
ARCH: STARTING ARCH PROCESSES
Fri Apr 05 17:01:28 2013
ARC0 started with pid=27, OS id=21152
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 05 17:01:29 2013
SMON: enabling cache recovery
ARC0: STARTING ARCH PROCESSES
Fri Apr 05 17:01:29 2013
ARC1 started with pid=26, OS id=21164
Fri Apr 05 17:01:29 2013
ARC2 started with pid=29, OS id=21166
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Fri Apr 05 17:01:30 2013
ARC3 started with pid=30, OS id=21168
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Re-creating tempfile /u02/oradata/TTS/temp01.dbf
Database Characterset is US7ASCII
No Resource Manager plan active
Fri Apr 05 17:01:38 2013
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open read only
Fri Apr 05 17:01:45 2013
db_recovery_file_dest_size of 2500 MB is 70.91% 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.
Fri Apr 05 17:02:15 2013
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 6
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Fri Apr 05 17:02:18 2013
SMON: disabling cache recovery
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Fri Apr 05 17:02:18 2013
ARCH shutting down
ARC3: Archival stopped
Fri Apr 05 17:02:18 2013
ARCH shutting down
ARC2: Archival stopped
Fri Apr 05 17:02:18 2013
ARCH shutting down
ARC1: Archival stopped
Fri Apr 05 17:02:18 2013
ARCH shutting down
ARC0: Archival stopped
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Apr 05 17:02:19 2013
Stopping background process VKTM
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Apr 05 17:02:20 2013
freeing rdom 0
Fri Apr 05 17:02:25 2013
Instance shutdown complete
Fri Apr 05 17:02:39 2013
Adjusting the default value of parameter parallel_max_servers
from 80 to 35 due to the value of parameter processes (50)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Private Interface 'eth2:1' configured from GPnP for use as a private interconnect.
[name='eth2:1', type=1, ip=169.254.231.131, mac=00-50-56-9c-1d-68, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'eth0' configured from GPnP for use as a public interface.
[name='eth0', type=1, ip=10.139.90.42, mac=00-50-56-9c-3d-c2, net=10.139.0.0/16, mask=255.255.0.0, use=public/1]
Public Interface 'eth0:1' configured from GPnP for use as a public interface.
[name='eth0:1', type=1, ip=10.139.92.42, mac=00-50-56-9c-3d-c2, net=10.139.0.0/16, mask=255.255.0.0, use=public/1]
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
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"
log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST"
db_recovery_file_dest = "/u02/oradata/TTS/FRA"
db_recovery_file_dest_size= 2500M
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
Fri Apr 05 17:02:47 2013
PMON started with pid=2, OS id=21807
Fri Apr 05 17:02:47 2013
PSP0 started with pid=3, OS id=21809
Fri Apr 05 17:02:48 2013
VKTM started with pid=4, OS id=21815 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Fri Apr 05 17:02:48 2013
GEN0 started with pid=5, OS id=21819
Fri Apr 05 17:02:48 2013
DIAG started with pid=6, OS id=21821
Fri Apr 05 17:02:48 2013
DBRM started with pid=7, OS id=21823
Fri Apr 05 17:02:48 2013
PING started with pid=8, OS id=21825
Fri Apr 05 17:02:48 2013
ACMS started with pid=9, OS id=21827
Fri Apr 05 17:02:48 2013
DIA0 started with pid=10, OS id=21829
Fri Apr 05 17:02:49 2013
LMON started with pid=11, OS id=21831
Fri Apr 05 17:02:49 2013
LMD0 started with pid=12, OS id=21833
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [1920 - 2560]
Fri Apr 05 17:02:49 2013
RMS0 started with pid=13, OS id=21835
Fri Apr 05 17:02:49 2013
LMHB started with pid=14, OS id=21838
Fri Apr 05 17:02:49 2013
MMAN started with pid=15, OS id=21840
Fri Apr 05 17:02:49 2013
DBW0 started with pid=16, OS id=21843
Fri Apr 05 17:02:49 2013
LGWR started with pid=17, OS id=21846
Fri Apr 05 17:02:49 2013
CKPT started with pid=18, OS id=21848
Fri Apr 05 17:02:49 2013
SMON started with pid=19, OS id=21850
Fri Apr 05 17:02:49 2013
RECO started with pid=20, OS id=21853
Fri Apr 05 17:02:49 2013
MMON started with pid=21, OS id=21855
Fri Apr 05 17:02:49 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Apr 05 17:02:49 2013
MMNL started with pid=22, OS id=21857
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
Fri Apr 05 17:02:51 2013
ALTER DATABASE MOUNT
Fri Apr 05 17:02:51 2013
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.139.92.42)(PORT=1521))))' SCOPE=MEMORY SID='TTS';
Successful mount of redo thread 1, with mount id 1771038587
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Fri Apr 05 17:04:27 2013
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 1411966
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_21897.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_21897.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_21897.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_21897.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 7
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_21897.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_21897.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_21897.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 8
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_21897.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_21897.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_21897.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 9
Errors in file /u01/app/oracle/diag/rdbms/tts/TTS/trace/TTS_ora_21897.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_21897.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 1770995941 (0x698f40e5)
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
Fri Apr 05 17:04:29 2013
Setting recovery target incarnation to 11
Using SCN growth rate of 16384 per second
Fri Apr 05 17:04:29 2013
Assigning activation ID 1771038587 (0x698fe77b)
LGWR: STARTING ARCH PROCESSES
Fri Apr 05 17:04:29 2013
ARC0 started with pid=26, OS id=22448
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Fri Apr 05 17:04:30 2013
ARC1 started with pid=27, OS id=22451
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
Fri Apr 05 17:04:30 2013
SMON: enabling cache recovery
Fri Apr 05 17:04:30 2013
ARC2 started with pid=28, OS id=22453
ARC1: Archival started
Fri Apr 05 17:04:31 2013
ARC3 started with pid=29, OS id=22458
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC2: Becoming the heartbeat ARCH
[21897] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:3166596074 end:3166597484 diff:1410 (14 seconds)
Dictionary check beginning
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is US7ASCII
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Apr 05 17:04:41 2013
Starting background process QMNC
Fri Apr 05 17:04:41 2013
QMNC started with pid=30, OS id=22506
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: alter database open resetlogs
Fri Apr 05 17:04:48 2013
db_recovery_file_dest_size of 2500 MB is 72.06% 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.
Fri Apr 05 17:04:48 2013
Starting background process CJQ0
Fri Apr 05 17:04:48 2013
CJQ0 started with pid=36, OS id=22554
Starting background process SMCO
Fri Apr 05 17:09:42 2013
SMCO started with pid=38, OS id=24219
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...