Test Script

Test Run

rman @bkup_mib_update.rman >  run1.log 2>&1

List of Database Incarnations

Starting backup at 27-OCT-2013 13:02:39

Starting recover at 27-OCT-2013 13:04:15

Starting Control File and SPFILE Autobackup at 27-OCT-2013 13:04:15

List of Backup Sets

List of Backups

List of Archived Log Backups

List of Control File Backups

List of SPFILE Backups

List of Datafile Copies

Report of files that need backup due to unrecoverable operations

Report of database schema for database with db_unique_name LAX_DB01

List of Permanent Datafiles

List of Temporary Files

rman @validate.rman        >> run1.log 2>&1

rman @bkup_mib_update.rman >  run2.log 2>&1

List of Database Incarnations

Starting backup at 27-OCT-2013 13:05:47

Starting recover at 27-OCT-2013 13:07:06

Starting Control File and SPFILE Autobackup at 27-OCT-2013 13:07:28

List of Backup Sets

List of Backups

Deleting the following obsolete backups and copies:

List of Archived Log Backups

List of Control File Backups

List of SPFILE Backups

List of Datafile Copies

Report of files that need backup due to unrecoverable operations

Report of database schema for database with db_unique_name LAX_DB01

List of Permanent Datafiles

List of Temporary Files

rman @validate.rman        >> run2.log 2>&1

Prepare for switch database to copy

Save Existing Database

Switch database to copy;

Test Script

$ cat run.sh

rman @bkup_mib_update.rman >  run1.log 2>&1

rman @validate.rman        >> run1.log 2>&1

rman @bkup_mib_update.rman >  run2.log 2>&1

rman @validate.rman        >> run2.log 2>&1

exit

Test Run

rman @bkup_mib_update.rman >  run1.log 2>&1

$ cat run1.log

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 27 13:02:36 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target;

2> configure controlfile autobackup on;

3> show all;

4> list incarnation of database;

5> run {

6> allocate channel d1 device type disk maxopenfiles 1 format '/oracle/datafilecopy/%U.dbf';

7> backup as compressed backupset check logical incremental level 1

8> for recover of copy with tag MIB_UPDATE database filesperset 1

9> include current controlfile

10> plus archivelog not backed up 1 times delete input

11> filesperset 8;

12> recover copy of database with tag MIB_UPDATE;

13> # recover copy of database with tag MIB_UPDATE until time "TRUNC(SYSDATE)-1";

14> }

15> list backup of CONTROLFILE;

16> list backup SUMMARY;

17> delete noprompt obsolete redundancy=1;

18> list backup by FILE;

19> list datafilecopy ALL;

20> report unrecoverable;

21> report schema;

22>

connected to target database: DB01 (DBID=1452485914)

using target database control file instead of recovery catalog

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN configuration parameters for database with db_unique_name LAX_DB01 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 2;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 1 FORMAT   '/oracle/backup/bkup_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.3/db_1/dbs/snapcf_db01.f'; # default

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       DB01     1452485914       PARENT  1          19-JUL-2013 20:04:42

2       2       DB01     1452485914       PARENT  769197     06-SEP-2013 13:09:43

3       3       DB01     1452485914       PARENT  780332     06-SEP-2013 20:36:41

4       4       DB01     1452485914       PARENT  780436     06-SEP-2013 20:42:24

5       5       DB01     1452485914       PARENT  780949     06-SEP-2013 20:54:43

6       6       DB01     1452485914       PARENT  889522     07-SEP-2013 10:44:26

7       7       DB01     1452485914       PARENT  890476     07-SEP-2013 11:05:47

8       8       DB01     1452485914       PARENT  890779     07-SEP-2013 11:13:35

9       9       DB01     1452485914       PARENT  913752     08-SEP-2013 09:01:06

10      10      DB01     1452485914       PARENT  919351     08-SEP-2013 11:25:57

11      11      DB01     1452485914       PARENT  943416     08-SEP-2013 15:24:48

12      12      DB01     1452485914       PARENT  947930     08-SEP-2013 18:00:17

13      13      DB01     1452485914       CURRENT 989580     08-SEP-2013 18:35:12

allocated channel: d1

channel d1: SID=36 device type=DISK

Starting backup at 27-OCT-2013 13:02:39

current log archived

channel d1: starting compressed archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=133 RECID=353 STAMP=829918960

channel d1: starting piece 1 at 27-OCT-2013 13:02:41

channel d1: finished piece 1 at 27-OCT-2013 13:02:42

piece handle=/oracle/datafilecopy/p8onf3nh_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:01

channel d1: deleting archived log(s)

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_10_27/o1_mf_1_133_96twc0bq_.arc RECID=353 STAMP=829918960

Finished backup at 27-OCT-2013 13:02:42

Starting backup at 27-OCT-2013 13:02:43

no parent backup or copy of datafile 3 found

no parent backup or copy of datafile 4 found

no parent backup or copy of datafile 1 found

no parent backup or copy of datafile 2 found

channel d1: starting datafile copy

input datafile file number=00003 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_undotbs_8ymzsr1w_.dbf

output file name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf tag=MIB_UPDATE RECID=113 STAMP=829918996

channel d1: datafile copy complete, elapsed time: 00:00:35

channel d1: starting datafile copy

input datafile file number=00004 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_user_dat_8yo8879m_.dbf

output file name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf tag=MIB_UPDATE RECID=114 STAMP=829919011

channel d1: datafile copy complete, elapsed time: 00:00:15

channel d1: starting datafile copy

input datafile file number=00001 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf

output file name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf tag=MIB_UPDATE RECID=115 STAMP=829919025

channel d1: datafile copy complete, elapsed time: 00:00:15

channel d1: starting datafile copy

input datafile file number=00002 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_sysaux_8ymzrr20_.dbf

output file name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf tag=MIB_UPDATE RECID=116 STAMP=829919040

channel d1: datafile copy complete, elapsed time: 00:00:15

channel d1: starting compressed incremental level 1 datafile backup set

channel d1: specifying datafile(s) in backup set

including current control file in backup set

channel d1: starting piece 1 at 27-OCT-2013 13:04:08

channel d1: finished piece 1 at 27-OCT-2013 13:04:09

piece handle=/oracle/datafilecopy/pdonf3q5_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:01

Finished backup at 27-OCT-2013 13:04:09

Starting backup at 27-OCT-2013 13:04:10

current log archived

channel d1: starting compressed archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=134 RECID=354 STAMP=829919052

channel d1: starting piece 1 at 27-OCT-2013 13:04:12

channel d1: finished piece 1 at 27-OCT-2013 13:04:13

piece handle=/oracle/datafilecopy/peonf3qc_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:01

channel d1: deleting archived log(s)

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_10_27/o1_mf_1_134_96twfvwr_.arc RECID=354 STAMP=829919052

Finished backup at 27-OCT-2013 13:04:14

Starting recover at 27-OCT-2013 13:04:15

no copy of datafile 1 found to recover

no copy of datafile 2 found to recover

no copy of datafile 3 found to recover

no copy of datafile 4 found to recover

Finished recover at 27-OCT-2013 13:04:15

Starting Control File and SPFILE Autobackup at 27-OCT-2013 13:04:15

piece handle=/oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 27-OCT-2013 13:04:22

released channel: d1

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ --------------------

682     Incr 1  1.23M      DISK        00:00:04     27-OCT-2013 13:04:09

        BP Key: 682   Status: AVAILABLE  Compressed: YES  Tag: MIB_UPDATE

        Piece Name: /oracle/datafilecopy/pdonf3q5_1_1.dbf

  Control File Included: Ckp SCN: 1718979      Ckp time: 27-OCT-2013 13:04:05

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ --------------------

684     Full    17.61M     DISK        00:00:05     27-OCT-2013 13:04:21

        BP Key: 684   Status: AVAILABLE  Compressed: NO  Tag: TAG20131027T130415

        Piece Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp

  Control File Included: Ckp SCN: 1719008      Ckp time: 27-OCT-2013 13:04:16

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

681     B  A  A DISK        27-OCT-2013 13:02:41 1       1       YES        MIB_UPDATE

682     B  1  A DISK        27-OCT-2013 13:04:09 1       1       YES        MIB_UPDATE

683     B  A  A DISK        27-OCT-2013 13:04:13 1       1       YES        MIB_UPDATE

684     B  F  A DISK        27-OCT-2013 13:04:21 1       1       NO         TAG20131027T130415

Note the above backup are obsolete.

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=36 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=28 device type=DISK

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set           681    27-OCT-2013 13:02:41

  Backup Piece       681    27-OCT-2013 13:02:41 /oracle/datafilecopy/p8onf3nh_1_1.dbf

Backup Set           682    27-OCT-2013 13:04:09

  Backup Piece       682    27-OCT-2013 13:04:09 /oracle/datafilecopy/pdonf3q5_1_1.dbf

deleted backup piece

backup piece handle=/oracle/datafilecopy/p8onf3nh_1_1.dbf RECID=681 STAMP=829918961

deleted backup piece

backup piece handle=/oracle/datafilecopy/pdonf3q5_1_1.dbf RECID=682 STAMP=829919048

Deleted 2 objects

List of Archived Log Backups

============================

Thrd Seq     Low SCN    Low Time             BS Key  S #Pieces #Copies Compressed Tag

---- ------- ---------- -------------------- ------- - ------- ------- ---------- ---

1    134     1718947    27-OCT-2013 13:02:39 683     A 1       1       YES        MIB_UPDATE

List of Control File Backups

============================

CF Ckp SCN Ckp Time             BS Key  S #Pieces #Copies Compressed Tag

---------- -------------------- ------- - ------- ------- ---------- ---

1719008    27-OCT-2013 13:04:16 684     A 1       1       NO         TAG20131027T130415

List of SPFILE Backups

======================

Modification Time    BS Key  S #Pieces #Copies Compressed Tag

-------------------- ------- - ------- ------- ---------- ---

27-OCT-2013 12:54:16 684     A 1       1       NO         TAG20131027T130415

List of Datafile Copies

=======================

Key     File S Completion Time      Ckp SCN    Ckp Time

------- ---- - -------------------- ---------- --------------------

115     1    A 27-OCT-2013 13:03:45 1718968    27-OCT-2013 13:03:34

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

        Tag: MIB_UPDATE

116     2    A 27-OCT-2013 13:04:00 1718974    27-OCT-2013 13:03:50

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

        Tag: MIB_UPDATE

113     3    A 27-OCT-2013 13:03:16 1718954    27-OCT-2013 13:02:44

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

        Tag: MIB_UPDATE

114     4    A 27-OCT-2013 13:03:31 1718962    27-OCT-2013 13:03:19

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

        Tag: MIB_UPDATE

Report of files that need backup due to unrecoverable operations

File Type of Backup Required Name

---- ----------------------- -----------------------------------

Report of database schema for database with db_unique_name LAX_DB01

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    200      SYSTEM               ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf

2    200      SYSAUX               ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_sysaux_8ymzrr20_.dbf

3    1024     UNDOTBS              ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_undotbs_8ymzsr1w_.dbf

4    256      USER_DATA            ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_user_dat_8yo8879m_.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    512      TEMP                 512         /oracle/oradata/LAX_DB01/datafile/o1_mf_temp_8ymzxhld_.tmp

2    128      TEMP                 1024        /oracle/oradata/LAX_DB01/datafile/o1_mf_temp_92d2dj6f_.tmp

Recovery Manager complete.

rman @validate.rman        >> run1.log 2>&1

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 27 13:04:38 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target;

2> restore validate database;

3> restore validate spfile to '/tmp/spfiledb01.ora' from autobackup;

4> restore validate controlfile from autobackup;

5> restore validate database;

6> restore validate archivelog from time 'sysdate-1';

7>

connected to target database: DB01 (DBID=1452485914)

Starting restore at 27-OCT-2013 13:04:39

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=16 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=39 device type=DISK

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

Finished restore at 27-OCT-2013 13:05:06

Starting restore at 27-OCT-2013 13:05:07

using channel ORA_DISK_1

using channel ORA_DISK_2

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_1: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp found in the recovery area

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20131027

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_2: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp found in the recovery area

channel ORA_DISK_2: looking for AUTOBACKUP on day: 20131027

channel ORA_DISK_2: skipped, AUTOBACKUP already found

channel ORA_DISK_1: restoring spfile from AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp

channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete

Finished restore at 27-OCT-2013 13:05:16

Starting restore at 27-OCT-2013 13:05:17

using channel ORA_DISK_1

using channel ORA_DISK_2

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_1: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp found in the recovery area

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20131027

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_2: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp found in the recovery area

channel ORA_DISK_2: looking for AUTOBACKUP on day: 20131027

channel ORA_DISK_2: skipped, AUTOBACKUP already found

channel ORA_DISK_1: starting validation of datafile backup set

channel ORA_DISK_1: validation complete, elapsed time: 00:00:08

Finished restore at 27-OCT-2013 13:05:25

Starting restore at 27-OCT-2013 13:05:26

using channel ORA_DISK_1

using channel ORA_DISK_2

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

Finished restore at 27-OCT-2013 13:05:42

Starting restore at 27-OCT-2013 13:05:43

using channel ORA_DISK_1

using channel ORA_DISK_2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 10/27/2013 13:05:43

RMAN-06026: some targets not found - aborting restore

RMAN-06025: no backup of archived log for thread 1 with sequence 133 and starting SCN of 1718594 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 132 and starting SCN of 1717713 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 131 and starting SCN of 1717679 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 130 and starting SCN of 1716450 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 129 and starting SCN of 1716398 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 128 and starting SCN of 1713821 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 127 and starting SCN of 1713788 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 126 and starting SCN of 1713566 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 125 and starting SCN of 1713519 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 124 and starting SCN of 1712253 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 123 and starting SCN of 1712214 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 122 and starting SCN of 1711981 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 121 and starting SCN of 1711930 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 120 and starting SCN of 1711675 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 119 and starting SCN of 1711627 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 118 and starting SCN of 1691631 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 117 and starting SCN of 1691564 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 116 and starting SCN of 1691318 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 115 and starting SCN of 1691279 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 114 and starting SCN of 1691136 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 113 and starting SCN of 1691056 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 112 and starting SCN of 1690030 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 111 and starting SCN of 1689996 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 110 and starting SCN of 1689130 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 109 and starting SCN of 1689084 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 108 and starting SCN of 1688190 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 107 and starting SCN of 1688147 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 106 and starting SCN of 1682995 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 105 and starting SCN of 1682944 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 104 and starting SCN of 1682683 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 103 and starting SCN of 1682655 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 102 and starting SCN of 1682471 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 101 and starting SCN of 1682442 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 100 and starting SCN of 1681949 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 99 and starting SCN of 1681899 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 98 and starting SCN of 1681768 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 97 and starting SCN of 1681333 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 96 and starting SCN of 1681241 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 95 and starting SCN of 1680267 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 94 and starting SCN of 1680059 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 93 and starting SCN of 1679182 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 92 and starting SCN of 1679156 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 91 and starting SCN of 1679029 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 90 and starting SCN of 1678959 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 89 and starting SCN of 1678710 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 88 and starting SCN of 1678685 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 87 and starting SCN of 1678581 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 86 and starting SCN of 1678507 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 85 and starting SCN of 1678300 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 84 and starting SCN of 1678277 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 83 and starting SCN of 1678134 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 82 and starting SCN of 1678097 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 81 and starting SCN of 1677869 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 80 and starting SCN of 1677744 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 79 and starting SCN of 1677331 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 78 and starting SCN of 1677266 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 77 and starting SCN of 1677180 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 76 and starting SCN of 1676863 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 75 and starting SCN of 1671071 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 74 and starting SCN of 1638528 found to restore

Recovery Manager complete.

rman @bkup_mib_update.rman >  run2.log 2>&1

$ cat run2.log

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 27 13:05:44 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target;

2> configure controlfile autobackup on;

3> show all;

4> list incarnation of database;

5> run {

6> allocate channel d1 device type disk maxopenfiles 1 format '/oracle/datafilecopy/%U.dbf';

7> backup as compressed backupset check logical incremental level 1

8> for recover of copy with tag MIB_UPDATE database filesperset 1

9> include current controlfile

10> plus archivelog not backed up 1 times delete input

11> filesperset 8;

12> recover copy of database with tag MIB_UPDATE;

13> # recover copy of database with tag MIB_UPDATE until time "TRUNC(SYSDATE)-1";

14> }

15> list backup of CONTROLFILE;

16> list backup SUMMARY;

17> delete noprompt obsolete redundancy=1;

18> list backup by FILE;

19> list datafilecopy ALL;

20> report unrecoverable;

21> report schema;

22>

connected to target database: DB01 (DBID=1452485914)

using target database control file instead of recovery catalog

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN configuration parameters for database with db_unique_name LAX_DB01 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 2;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 1 FORMAT   '/oracle/backup/bkup_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.3/db_1/dbs/snapcf_db01.f'; # default

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       DB01     1452485914       PARENT  1          19-JUL-2013 20:04:42

2       2       DB01     1452485914       PARENT  769197     06-SEP-2013 13:09:43

3       3       DB01     1452485914       PARENT  780332     06-SEP-2013 20:36:41

4       4       DB01     1452485914       PARENT  780436     06-SEP-2013 20:42:24

5       5       DB01     1452485914       PARENT  780949     06-SEP-2013 20:54:43

6       6       DB01     1452485914       PARENT  889522     07-SEP-2013 10:44:26

7       7       DB01     1452485914       PARENT  890476     07-SEP-2013 11:05:47

8       8       DB01     1452485914       PARENT  890779     07-SEP-2013 11:13:35

9       9       DB01     1452485914       PARENT  913752     08-SEP-2013 09:01:06

10      10      DB01     1452485914       PARENT  919351     08-SEP-2013 11:25:57

11      11      DB01     1452485914       PARENT  943416     08-SEP-2013 15:24:48

12      12      DB01     1452485914       PARENT  947930     08-SEP-2013 18:00:17

13      13      DB01     1452485914       CURRENT 989580     08-SEP-2013 18:35:12

allocated channel: d1

channel d1: SID=36 device type=DISK

Starting backup at 27-OCT-2013 13:05:47

current log archived

channel d1: starting compressed archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=135 RECID=355 STAMP=829919149

channel d1: starting piece 1 at 27-OCT-2013 13:05:50

channel d1: finished piece 1 at 27-OCT-2013 13:05:53

piece handle=/oracle/datafilecopy/pgonf3te_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:03

channel d1: deleting archived log(s)

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_10_27/o1_mf_1_135_96twjxhq_.arc RECID=355 STAMP=829919149

Finished backup at 27-OCT-2013 13:05:54

Starting backup at 27-OCT-2013 13:05:55

channel d1: starting compressed incremental level 1 datafile backup set

channel d1: specifying datafile(s) in backup set

input datafile file number=00003 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_undotbs_8ymzsr1w_.dbf

channel d1: starting piece 1 at 27-OCT-2013 13:05:55

channel d1: finished piece 1 at 27-OCT-2013 13:06:20

piece handle=/oracle/datafilecopy/phonf3tj_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:25

channel d1: starting compressed incremental level 1 datafile backup set

channel d1: specifying datafile(s) in backup set

input datafile file number=00004 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_user_dat_8yo8879m_.dbf

channel d1: starting piece 1 at 27-OCT-2013 13:06:20

channel d1: finished piece 1 at 27-OCT-2013 13:06:28

piece handle=/oracle/datafilecopy/pionf3uc_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:08

channel d1: starting compressed incremental level 1 datafile backup set

channel d1: specifying datafile(s) in backup set

input datafile file number=00001 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf

channel d1: starting piece 1 at 27-OCT-2013 13:06:28

channel d1: finished piece 1 at 27-OCT-2013 13:06:35

piece handle=/oracle/datafilecopy/pjonf3uk_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:07

channel d1: starting compressed incremental level 1 datafile backup set

channel d1: specifying datafile(s) in backup set

input datafile file number=00002 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_sysaux_8ymzrr20_.dbf

channel d1: starting piece 1 at 27-OCT-2013 13:06:35

channel d1: finished piece 1 at 27-OCT-2013 13:06:50

piece handle=/oracle/datafilecopy/pkonf3ur_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:15

channel d1: starting compressed incremental level 1 datafile backup set

channel d1: specifying datafile(s) in backup set

including current control file in backup set

channel d1: starting piece 1 at 27-OCT-2013 13:06:58

channel d1: finished piece 1 at 27-OCT-2013 13:07:01

piece handle=/oracle/datafilecopy/plonf3vb_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:03

Finished backup at 27-OCT-2013 13:07:01

Starting backup at 27-OCT-2013 13:07:01

current log archived

channel d1: starting compressed archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=136 RECID=356 STAMP=829919223

channel d1: starting piece 1 at 27-OCT-2013 13:07:04

channel d1: finished piece 1 at 27-OCT-2013 13:07:05

piece handle=/oracle/datafilecopy/pmonf3vo_1_1.dbf tag=MIB_UPDATE comment=NONE

channel d1: backup set complete, elapsed time: 00:00:01

channel d1: deleting archived log(s)

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_10_27/o1_mf_1_136_96twm7hc_.arc RECID=356 STAMP=829919223

Finished backup at 27-OCT-2013 13:07:06

Starting recover at 27-OCT-2013 13:07:06

channel d1: starting incremental datafile backup set restore

channel d1: specifying datafile copies to recover

recovering datafile copy file number=00003 name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

channel d1: reading from backup piece /oracle/datafilecopy/phonf3tj_1_1.dbf

channel d1: piece handle=/oracle/datafilecopy/phonf3tj_1_1.dbf tag=MIB_UPDATE

channel d1: restored backup piece 1

channel d1: restore complete, elapsed time: 00:00:03

channel d1: starting incremental datafile backup set restore

channel d1: specifying datafile copies to recover

recovering datafile copy file number=00004 name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

channel d1: reading from backup piece /oracle/datafilecopy/pionf3uc_1_1.dbf

channel d1: piece handle=/oracle/datafilecopy/pionf3uc_1_1.dbf tag=MIB_UPDATE

channel d1: restored backup piece 1

channel d1: restore complete, elapsed time: 00:00:02

channel d1: starting incremental datafile backup set restore

channel d1: specifying datafile copies to recover

recovering datafile copy file number=00001 name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

channel d1: reading from backup piece /oracle/datafilecopy/pjonf3uk_1_1.dbf

channel d1: piece handle=/oracle/datafilecopy/pjonf3uk_1_1.dbf tag=MIB_UPDATE

channel d1: restored backup piece 1

channel d1: restore complete, elapsed time: 00:00:01

channel d1: starting incremental datafile backup set restore

channel d1: specifying datafile copies to recover

recovering datafile copy file number=00002 name=/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

channel d1: reading from backup piece /oracle/datafilecopy/pkonf3ur_1_1.dbf

channel d1: piece handle=/oracle/datafilecopy/pkonf3ur_1_1.dbf tag=MIB_UPDATE

channel d1: restored backup piece 1

channel d1: restore complete, elapsed time: 00:00:15

Finished recover at 27-OCT-2013 13:07:28

Starting Control File and SPFILE Autobackup at 27-OCT-2013 13:07:28

piece handle=/oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 27-OCT-2013 13:07:35

released channel: d1

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ --------------------

684     Full    17.61M     DISK        00:00:05     27-OCT-2013 13:04:21

        BP Key: 684   Status: AVAILABLE  Compressed: NO  Tag: TAG20131027T130415

        Piece Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp

  Control File Included: Ckp SCN: 1719008      Ckp time: 27-OCT-2013 13:04:16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ --------------------

690     Incr 1  1.23M      DISK        00:00:07     27-OCT-2013 13:06:58

        BP Key: 690   Status: AVAILABLE  Compressed: YES  Tag: MIB_UPDATE

        Piece Name: /oracle/datafilecopy/plonf3vb_1_1.dbf

  Control File Included: Ckp SCN: 1719305      Ckp time: 27-OCT-2013 13:06:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ --------------------

692     Full    17.61M     DISK        00:00:04     27-OCT-2013 13:07:33

        BP Key: 692   Status: AVAILABLE  Compressed: NO  Tag: TAG20131027T130728

        Piece Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp

  Control File Included: Ckp SCN: 1719347      Ckp time: 27-OCT-2013 13:07:29

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

683     B  A  A DISK        27-OCT-2013 13:04:13 1       1       YES        MIB_UPDATE

684     B  F  A DISK        27-OCT-2013 13:04:21 1       1       NO         TAG20131027T130415

685     B  A  A DISK        27-OCT-2013 13:05:51 1       1       YES        MIB_UPDATE

686     B  1  A DISK        27-OCT-2013 13:06:10 1       1       YES        MIB_UPDATE

687     B  1  A DISK        27-OCT-2013 13:06:26 1       1       YES        MIB_UPDATE

688     B  1  A DISK        27-OCT-2013 13:06:33 1       1       YES        MIB_UPDATE

689     B  1  A DISK        27-OCT-2013 13:06:48 1       1       YES        MIB_UPDATE

690     B  1  A DISK        27-OCT-2013 13:06:58 1       1       YES        MIB_UPDATE

691     B  A  A DISK        27-OCT-2013 13:07:04 1       1       YES        MIB_UPDATE

692     B  F  A DISK        27-OCT-2013 13:07:33 1       1       NO         TAG20131027T130728

Note the above backup are obsolete.

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=36 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=28 device type=DISK

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set           683    27-OCT-2013 13:04:13

  Backup Piece       683    27-OCT-2013 13:04:13 /oracle/datafilecopy/peonf3qc_1_1.dbf

Backup Set           684    27-OCT-2013 13:04:21

  Backup Piece       684    27-OCT-2013 13:04:21 /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp

Backup Set           685    27-OCT-2013 13:05:51

  Backup Piece       685    27-OCT-2013 13:05:51 /oracle/datafilecopy/pgonf3te_1_1.dbf

Backup Set           686    27-OCT-2013 13:06:10

  Backup Piece       686    27-OCT-2013 13:06:10 /oracle/datafilecopy/phonf3tj_1_1.dbf

Backup Set           687    27-OCT-2013 13:06:26

  Backup Piece       687    27-OCT-2013 13:06:26 /oracle/datafilecopy/pionf3uc_1_1.dbf

Backup Set           688    27-OCT-2013 13:06:33

  Backup Piece       688    27-OCT-2013 13:06:33 /oracle/datafilecopy/pjonf3uk_1_1.dbf

Backup Set           689    27-OCT-2013 13:06:48

  Backup Piece       689    27-OCT-2013 13:06:48 /oracle/datafilecopy/pkonf3ur_1_1.dbf

Backup Set           690    27-OCT-2013 13:06:58

  Backup Piece       690    27-OCT-2013 13:06:58 /oracle/datafilecopy/plonf3vb_1_1.dbf

deleted backup piece

backup piece handle=/oracle/datafilecopy/peonf3qc_1_1.dbf RECID=683 STAMP=829919052

deleted backup piece

backup piece handle=/oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919056_96twg3ym_.bkp RECID=684 STAMP=829919059

deleted backup piece

backup piece handle=/oracle/datafilecopy/pgonf3te_1_1.dbf RECID=685 STAMP=829919150

deleted backup piece

backup piece handle=/oracle/datafilecopy/phonf3tj_1_1.dbf RECID=686 STAMP=829919156

deleted backup piece

backup piece handle=/oracle/datafilecopy/pionf3uc_1_1.dbf RECID=687 STAMP=829919181

deleted backup piece

backup piece handle=/oracle/datafilecopy/pjonf3uk_1_1.dbf RECID=688 STAMP=829919188

deleted backup piece

backup piece handle=/oracle/datafilecopy/pkonf3ur_1_1.dbf RECID=689 STAMP=829919203

deleted backup piece

backup piece handle=/oracle/datafilecopy/plonf3vb_1_1.dbf RECID=690 STAMP=829919218

Deleted 8 objects

List of Archived Log Backups

============================

Thrd Seq     Low SCN    Low Time             BS Key  S #Pieces #Copies Compressed Tag

---- ------- ---------- -------------------- ------- - ------- ------- ---------- ---

1    136     1719275    27-OCT-2013 13:05:48 691     A 1       1       YES        MIB_UPDATE

List of Control File Backups

============================

CF Ckp SCN Ckp Time             BS Key  S #Pieces #Copies Compressed Tag

---------- -------------------- ------- - ------- ------- ---------- ---

1719347    27-OCT-2013 13:07:29 692     A 1       1       NO         TAG20131027T130728

List of SPFILE Backups

======================

Modification Time    BS Key  S #Pieces #Copies Compressed Tag

-------------------- ------- - ------- ------- ---------- ---

27-OCT-2013 12:54:16 692     A 1       1       NO         TAG20131027T130728

List of Datafile Copies

=======================

Key     File S Completion Time      Ckp SCN    Ckp Time

------- ---- - -------------------- ---------- --------------------

119     1    A 27-OCT-2013 13:07:12 1719297    27-OCT-2013 13:06:28

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

        Tag: MIB_UPDATE

120     2    A 27-OCT-2013 13:07:21 1719300    27-OCT-2013 13:06:35

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

        Tag: MIB_UPDATE

117     3    A 27-OCT-2013 13:07:09 1719282    27-OCT-2013 13:05:55

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

        Tag: MIB_UPDATE

118     4    A 27-OCT-2013 13:07:11 1719293    27-OCT-2013 13:06:21

        Name: /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

        Tag: MIB_UPDATE

Report of files that need backup due to unrecoverable operations

File Type of Backup Required Name

---- ----------------------- -----------------------------------

Report of database schema for database with db_unique_name LAX_DB01

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    200      SYSTEM               ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf

2    200      SYSAUX               ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_sysaux_8ymzrr20_.dbf

3    1024     UNDOTBS              ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_undotbs_8ymzsr1w_.dbf

4    256      USER_DATA            ***     /oracle/oradata/LAX_DB01/datafile/o1_mf_user_dat_8yo8879m_.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    512      TEMP                 512         /oracle/oradata/LAX_DB01/datafile/o1_mf_temp_8ymzxhld_.tmp

2    128      TEMP                 1024        /oracle/oradata/LAX_DB01/datafile/o1_mf_temp_92d2dj6f_.tmp

Recovery Manager complete.

rman @validate.rman        >> run2.log 2>&1

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 27 13:07:54 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target;

2> restore validate database;

3> restore validate spfile to '/tmp/spfiledb01.ora' from autobackup;

4> restore validate controlfile from autobackup;

5> restore validate database;

6> restore validate archivelog from time 'sysdate-1';

7>

connected to target database: DB01 (DBID=1452485914)

Starting restore at 27-OCT-2013 13:07:56

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=16 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=39 device type=DISK

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

Finished restore at 27-OCT-2013 13:08:56

Starting restore at 27-OCT-2013 13:08:57

using channel ORA_DISK_1

using channel ORA_DISK_2

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_1: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp found in the recovery area

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20131027

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_2: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp found in the recovery area

channel ORA_DISK_2: looking for AUTOBACKUP on day: 20131027

channel ORA_DISK_2: skipped, AUTOBACKUP already found

channel ORA_DISK_1: restoring spfile from AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp

channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete

Finished restore at 27-OCT-2013 13:09:05

Starting restore at 27-OCT-2013 13:09:06

using channel ORA_DISK_1

using channel ORA_DISK_2

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_1: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp found in the recovery area

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20131027

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_2: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp found in the recovery area

channel ORA_DISK_2: looking for AUTOBACKUP on day: 20131027

channel ORA_DISK_2: skipped, AUTOBACKUP already found

channel ORA_DISK_1: starting validation of datafile backup set

channel ORA_DISK_1: validation complete, elapsed time: 00:00:09

Finished restore at 27-OCT-2013 13:09:15

Starting restore at 27-OCT-2013 13:09:16

using channel ORA_DISK_1

using channel ORA_DISK_2

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

channel ORA_DISK_1: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

channel ORA_DISK_2: scanning datafile copy /oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

Finished restore at 27-OCT-2013 13:09:20

Starting restore at 27-OCT-2013 13:09:21

using channel ORA_DISK_1

using channel ORA_DISK_2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 10/27/2013 13:09:21

RMAN-06026: some targets not found - aborting restore

RMAN-06025: no backup of archived log for thread 1 with sequence 135 and starting SCN of 1718986 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 134 and starting SCN of 1718947 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 133 and starting SCN of 1718594 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 132 and starting SCN of 1717713 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 131 and starting SCN of 1717679 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 130 and starting SCN of 1716450 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 129 and starting SCN of 1716398 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 128 and starting SCN of 1713821 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 127 and starting SCN of 1713788 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 126 and starting SCN of 1713566 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 125 and starting SCN of 1713519 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 124 and starting SCN of 1712253 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 123 and starting SCN of 1712214 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 122 and starting SCN of 1711981 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 121 and starting SCN of 1711930 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 120 and starting SCN of 1711675 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 119 and starting SCN of 1711627 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 118 and starting SCN of 1691631 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 117 and starting SCN of 1691564 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 116 and starting SCN of 1691318 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 115 and starting SCN of 1691279 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 114 and starting SCN of 1691136 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 113 and starting SCN of 1691056 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 112 and starting SCN of 1690030 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 111 and starting SCN of 1689996 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 110 and starting SCN of 1689130 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 109 and starting SCN of 1689084 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 108 and starting SCN of 1688190 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 107 and starting SCN of 1688147 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 106 and starting SCN of 1682995 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 105 and starting SCN of 1682944 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 104 and starting SCN of 1682683 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 103 and starting SCN of 1682655 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 102 and starting SCN of 1682471 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 101 and starting SCN of 1682442 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 100 and starting SCN of 1681949 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 99 and starting SCN of 1681899 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 98 and starting SCN of 1681768 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 97 and starting SCN of 1681333 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 96 and starting SCN of 1681241 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 95 and starting SCN of 1680267 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 94 and starting SCN of 1680059 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 93 and starting SCN of 1679182 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 92 and starting SCN of 1679156 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 91 and starting SCN of 1679029 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 90 and starting SCN of 1678959 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 89 and starting SCN of 1678710 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 88 and starting SCN of 1678685 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 87 and starting SCN of 1678581 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 86 and starting SCN of 1678507 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 85 and starting SCN of 1678300 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 84 and starting SCN of 1678277 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 83 and starting SCN of 1678134 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 82 and starting SCN of 1678097 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 81 and starting SCN of 1677869 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 80 and starting SCN of 1677744 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 79 and starting SCN of 1677331 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 78 and starting SCN of 1677266 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 77 and starting SCN of 1677180 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 76 and starting SCN of 1676863 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 75 and starting SCN of 1671071 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 74 and starting SCN of 1638528 found to restore

Recovery Manager complete.

[oracle@lax:db01]/home/oracle

$

Prepare for switch database to copy

LAX:(SYS@db01)> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf

/oracle/oradata/LAX_DB01/datafile/o1_mf_sysaux_8ymzrr20_.dbf

/oracle/oradata/LAX_DB01/datafile/o1_mf_undotbs_8ymzsr1w_.dbf

/oracle/oradata/LAX_DB01/datafile/o1_mf_user_dat_8yo8879m_.dbf

LAX:(SYS@db01)> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlb9v_.ctl

/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlc18_.ctl

LAX:(SYS@db01)> select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_1_8ymzlf3t_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_1_8ymzlfdm_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_2_8ymzlfph_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_2_8ymzm4lz_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_3_8ymzmqo3_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_3_8ymzo1yx_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_4_8ymzo7bw_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_4_8ymzpogk_.log

8 rows selected.

LAX:(SYS@db01)> @pr "select * from v$database"

DBID                          : 1452485914

NAME                          : DB01

CREATED                       : 19-jul-2013 20:04:42

RESETLOGS_CHANGE#             : 989580

RESETLOGS_TIME                : 08-sep-2013 18:35:12

PRIOR_RESETLOGS_CHANGE#       : 947930

PRIOR_RESETLOGS_TIME          : 08-sep-2013 18:00:17

LOG_MODE                      : ARCHIVELOG

CHECKPOINT_CHANGE#            : 1719314

ARCHIVE_CHANGE#               : 1719310

CONTROLFILE_TYPE              : CURRENT

CONTROLFILE_CREATED           : 19-jul-2013 20:04:43

CONTROLFILE_SEQUENCE#         : 19082

CONTROLFILE_CHANGE#           : 1719532

CONTROLFILE_TIME              : 27-oct-2013 13:09:22

OPEN_RESETLOGS                : NOT ALLOWED

VERSION_TIME                  : 08-sep-2013 18:33:54

OPEN_MODE                     : READ WRITE

PROTECTION_MODE               : MAXIMUM PERFORMANCE

PROTECTION_LEVEL              : MAXIMUM PERFORMANCE

REMOTE_ARCHIVE                : ENABLED

ACTIVATION#                   : 1456836684

SWITCHOVER#                   : 1456836684

DATABASE_ROLE                 : PRIMARY

ARCHIVELOG_CHANGE#            : 0

ARCHIVELOG_COMPRESSION        : DISABLED

SWITCHOVER_STATUS             : NOT ALLOWED

DATAGUARD_BROKER              : DISABLED

GUARD_STATUS                  : NONE

SUPPLEMENTAL_LOG_DATA_MIN     : NO

SUPPLEMENTAL_LOG_DATA_PK      : NO

SUPPLEMENTAL_LOG_DATA_UI      : NO

FORCE_LOGGING                 : NO

PLATFORM_ID                   : 13

PLATFORM_NAME                 : Linux x86 64-bit

RECOVERY_TARGET_INCARNATION#  : 13

LAST_OPEN_INCARNATION#        : 13

CURRENT_SCN                   : 1720414

FLASHBACK_ON                  : NO

SUPPLEMENTAL_LOG_DATA_FK      : NO

SUPPLEMENTAL_LOG_DATA_ALL     : NO

DB_UNIQUE_NAME                : lax_db01

STANDBY_BECAME_PRIMARY_SCN    : 0

FS_FAILOVER_STATUS            : DISABLED

FS_FAILOVER_CURRENT_TARGET    :

FS_FAILOVER_THRESHOLD         : 0

FS_FAILOVER_OBSERVER_PRESENT  :

FS_FAILOVER_OBSERVER_HOST     :

CONTROLFILE_CONVERTED         : NO

PRIMARY_DB_UNIQUE_NAME        :

SUPPLEMENTAL_LOG_DATA_PL      : NO

MIN_REQUIRED_CAPTURE_CHANGE#  :

-------------------------

PL/SQL procedure successfully completed.

LAX:(SYS@db01)> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

LAX:(SYS@db01)>

Save Existing Database

[oracle@lax:db01]/home/oracle

$ cd /oracle/oradata/

[oracle@lax:db01]/oracle/oradata

$ ls

LAX_DB01

[oracle@lax:db01]/oracle/oradata

$ mv LAX_DB01/ LAX_DB01_BKUP

Switch database to copy;

[oracle@lax:db01]/oracle/oradata

$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 27 13:38:43 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> startup force nomount;

Oracle instance started

Total System Global Area     534462464 bytes

Fixed Size                     2230072 bytes

Variable Size                289409224 bytes

Database Buffers             239075328 bytes

Redo Buffers                   3747840 bytes

RMAN> set dbid 1452485914;

executing command: SET DBID

RMAN> restore controlfile from autobackup;

Starting restore at 27-OCT-2013 13:39:07

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=19 device type=DISK

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel ORA_DISK_1: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp found in the recovery area

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20131027

channel ORA_DISK_1: restoring control file from AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp

channel ORA_DISK_1: control file restore from AUTOBACKUP complete

output file name=/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlb9v_.ctl

output file name=/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlc18_.ctl

Finished restore at 27-OCT-2013 13:39:11

RMAN> switch database to copy;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of switch to copy command at 10/27/2013 13:39:29

ORA-01507: database not mounted

RMAN> startup force mount;

Oracle instance started

database mounted

Total System Global Area     534462464 bytes

Fixed Size                     2230072 bytes

Variable Size                289409224 bytes

Database Buffers             239075328 bytes

Redo Buffers                   3747840 bytes

RMAN> switch database to copy;

Starting implicit crosscheck backup at 27-OCT-2013 13:39:51

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=18 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=19 device type=DISK

Crosschecked 1 objects

Crosschecked 8 objects

Finished implicit crosscheck backup at 27-OCT-2013 13:39:55

Starting implicit crosscheck copy at 27-OCT-2013 13:39:55

using channel ORA_DISK_1

using channel ORA_DISK_2

Crosschecked 4 objects

Finished implicit crosscheck copy at 27-OCT-2013 13:39:55

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_10_27/o1_mf_s_829919249_96twn4mv_.bkp

datafile 1 switched to datafile copy "/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf"

datafile 2 switched to datafile copy "/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf"

datafile 3 switched to datafile copy "/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf"

datafile 4 switched to datafile copy "/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf"

RMAN> recover database;

Starting recover at 27-OCT-2013 13:40:32

using channel ORA_DISK_1

using channel ORA_DISK_2

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=136

channel ORA_DISK_1: reading from backup piece /oracle/datafilecopy/pmonf3vo_1_1.dbf

channel ORA_DISK_1: piece handle=/oracle/datafilecopy/pmonf3vo_1_1.dbf tag=MIB_UPDATE

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_10_27/o1_mf_1_136_96tyl4hh_.arc thread=1 sequence=136

channel default: deleting archived log(s)

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_10_27/o1_mf_1_136_96tyl4hh_.arc RECID=357 STAMP=829921236

unable to find archived log

archived log thread=1 sequence=137

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 10/27/2013 13:40:39

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 137 and starting SCN of 1719314

RMAN> recover database until sequence 137;

Starting recover at 27-OCT-2013 13:41:01

using channel ORA_DISK_1

using channel ORA_DISK_2

starting media recovery

media recovery complete, elapsed time: 00:00:01

Finished recover at 27-OCT-2013 13:41:05

RMAN> alter database open resetlogs;

database opened

RMAN> list incarnation;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       DB01     1452485914       PARENT  1          19-JUL-2013 20:04:42

2       2       DB01     1452485914       PARENT  769197     06-SEP-2013 13:09:43

3       3       DB01     1452485914       PARENT  780332     06-SEP-2013 20:36:41

4       4       DB01     1452485914       PARENT  780436     06-SEP-2013 20:42:24

5       5       DB01     1452485914       PARENT  780949     06-SEP-2013 20:54:43

6       6       DB01     1452485914       PARENT  889522     07-SEP-2013 10:44:26

7       7       DB01     1452485914       PARENT  890476     07-SEP-2013 11:05:47

8       8       DB01     1452485914       PARENT  890779     07-SEP-2013 11:13:35

9       9       DB01     1452485914       PARENT  913752     08-SEP-2013 09:01:06

10      10      DB01     1452485914       PARENT  919351     08-SEP-2013 11:25:57

11      11      DB01     1452485914       PARENT  943416     08-SEP-2013 15:24:48

12      12      DB01     1452485914       PARENT  947930     08-SEP-2013 18:00:17

13      13      DB01     1452485914       PARENT  989580     08-SEP-2013 18:35:12

14      14      DB01     1452485914       CURRENT 1719315    27-OCT-2013 13:41:17

RMAN>

LAX:(SYS@db01)> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

LAX:(SYS@db01)> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlb9v_.ctl

/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlc18_.ctl

LAX:(SYS@db01)> select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_1_96tymg8b_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_1_96tymh0r_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_2_96tymx11_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_2_96tymxl7_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_3_96tyncm1_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_3_96tynd6l_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_4_96tyntrt_.log

/oracle/oradata/LAX_DB01/onlinelog/o1_mf_4_96tynvc0_.log

8 rows selected.

LAX:(SYS@db01)> @pr "select * from v$database"

DBID                          : 1452485914

NAME                          : DB01

CREATED                       : 19-jul-2013 20:04:42

RESETLOGS_CHANGE#             : 1719315

RESETLOGS_TIME                : 27-oct-2013 13:41:17

PRIOR_RESETLOGS_CHANGE#       : 989580

PRIOR_RESETLOGS_TIME          : 08-sep-2013 18:35:12

LOG_MODE                      : ARCHIVELOG

CHECKPOINT_CHANGE#            : 1719318

ARCHIVE_CHANGE#               : 0

CONTROLFILE_TYPE              : CURRENT

CONTROLFILE_CREATED           : 19-jul-2013 20:04:43

CONTROLFILE_SEQUENCE#         : 19137

CONTROLFILE_CHANGE#           : 1719533

CONTROLFILE_TIME              : 27-oct-2013 13:47:09

OPEN_RESETLOGS                : NOT ALLOWED

VERSION_TIME                  : 27-oct-2013 13:39:44

OPEN_MODE                     : READ WRITE

PROTECTION_MODE               : MAXIMUM PERFORMANCE

PROTECTION_LEVEL              : MAXIMUM PERFORMANCE

REMOTE_ARCHIVE                : ENABLED

ACTIVATION#                   : 1461195099

SWITCHOVER#                   : 1461195099

DATABASE_ROLE                 : PRIMARY

ARCHIVELOG_CHANGE#            : 0

ARCHIVELOG_COMPRESSION        : DISABLED

SWITCHOVER_STATUS             : NOT ALLOWED

DATAGUARD_BROKER              : DISABLED

GUARD_STATUS                  : NONE

SUPPLEMENTAL_LOG_DATA_MIN     : NO

SUPPLEMENTAL_LOG_DATA_PK      : NO

SUPPLEMENTAL_LOG_DATA_UI      : NO

FORCE_LOGGING                 : NO

PLATFORM_ID                   : 13

PLATFORM_NAME                 : Linux x86 64-bit

RECOVERY_TARGET_INCARNATION#  : 14

LAST_OPEN_INCARNATION#        : 14

CURRENT_SCN                   : 1719554

FLASHBACK_ON                  : NO

SUPPLEMENTAL_LOG_DATA_FK      : NO

SUPPLEMENTAL_LOG_DATA_ALL     : NO

DB_UNIQUE_NAME                : lax_db01

STANDBY_BECAME_PRIMARY_SCN    : 0

FS_FAILOVER_STATUS            : DISABLED

FS_FAILOVER_CURRENT_TARGET    :

FS_FAILOVER_THRESHOLD         : 0

FS_FAILOVER_OBSERVER_PRESENT  :

FS_FAILOVER_OBSERVER_HOST     :

CONTROLFILE_CONVERTED         : NO

PRIMARY_DB_UNIQUE_NAME        :

SUPPLEMENTAL_LOG_DATA_PL      : NO

MIN_REQUIRED_CAPTURE_CHANGE#  :

-------------------------

PL/SQL procedure successfully completed.

LAX:(SYS@db01)> show parameter db_create

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_create_file_dest                  string      /oracle/oradata

db_create_online_log_dest_1          string      /oracle/oradata

db_create_online_log_dest_2          string      /oracle/oradata

db_create_online_log_dest_3          string

db_create_online_log_dest_4          string

db_create_online_log_dest_5          string

LAX:(SYS@db01)> alter system set db_create_file_dest='/oracle/datafilecopy';

System altered.

LAX:(SYS@db01)> create tablespace testing datafile size 16m;

Tablespace created.

LAX:(SYS@db01)> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSTEM_FNO-1_pbonf3p6.dbf

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-SYSAUX_FNO-2_pconf3pm.dbf

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-UNDOTBS_FNO-3_p9onf3nk.dbf

/oracle/datafilecopy/data_D-DB01_I-1452485914_TS-USER_DATA_FNO-4_paonf3on.dbf

/oracle/datafilecopy/LAX_DB01/datafile/o1_mf_testing_96v0nk2p_.dbf

LAX:(SYS@db01)>