Saturday, April 06, 2013

RMAN in-completed recovery using UNTIL SEQUENCE clause

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