Category Archives: Backup and Recovery
ORA-00376: file 92 cannot be read at this time
Table Block Curruption during DataPump Backup
ORA-01248: file 11 was created in the future of incomplete recovery
Environment: 2 Node GRID(RAC/ASM) Oracle Database v11.2.0.3.0 on RHEL 6.4
At our client setup, faced some issues with SAN storage. So DB got down as there was communication issue between DB server and SAN storage.
After SAN storage restart by H/w team,
– First we not able to open DB because of inconsistent files error might be due to “Storage” issue.
· To resolve issue we have tried to recover from previous success RMAN DB backup(27th Nov14) but we are not able to up the DB.
Commands to analysis the Database Health:-
ERROR at line 1: ORA-01248: file 11 was created in the future of incomplete recovery
select '#' || ts.name || '#' as tablespace_name, ts.ts#, '#' || dh.name || '#' as filename, dh.file#, dh.status, dh.error, dh. fuzzy, dh.creation_change#, to_char(dh.creation_time, 'DD-MON-YYYY HH24:MI:SS') as creation_time, to_char(dh.checkpoint_change#, '999999999999999') as checkpoint_change#, to_char(dh.checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time, to_char(dh.resetlogs_change#, '999999999999999') as resetlogs_change#, to_char(dh.resetlogs_time, 'DD-MON-YYYY HH24:MI:SS') as resetlogs_time, to_char(dh.bytes, '9,999,999,999,990') as bytes from v$datafile_header dh, v$tablespace ts where ts.ts# = dh.ts# and ( dh.status <> 'ONLINE' or dh.checkpoint_change# <> (select checkpoint_change# from v$database) ); TABLESPACE_NAME TS# FILENAME FILE# STATUS ERROR FUZ CREATION_CHANGE# CREATION_TIME CHECKPOINT_CHANG CHECKPOINT_TIME RESETLOGS_CHANGE RESETLOGS_TIME BYTES #SYSTEM# 0 #+DATA/orcldb/datafile/system.262.821898691# 1 ONLINE NO 7 17-SEP-2011 09:46:08 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 8,954,839,040 #SYSAUX# 1 #+DATA/orcldb/datafile/sysaux.260.821898691# 2 ONLINE NO 2188 17-SEP-2011 09:46:16 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 786,432,000 #UNDOTBS1# 2 #+DATA/orcldb/datafile/undotbs1.261.821898691# 3 ONLINE 992580 17-SEP-2011 10:22:44 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 2,820,669,440 #USERS# 4 #+DATA/orcldb/datafile/users.259.821898691# 4 ONLINE NO 18919 17-SEP-2011 09:46:40 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 5,242,880 #UNDOTBS2# 5 #+DATA/orcldb/datafile/undotbs2.257.821898845# 5 ONLINE NO 1040830 27-JUL-2013 17:14:04 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 104,857,600 #TBSORCL21# 6 #+DATA/orcldb/datafile/TBSORCL21.268.865415781# 11 ONLINE NO 483159051 04-DEC-2014 09:16:22 483159051 04-DEC-2014 09:16:22 995548 27-JUL-2013 17:12:39 104,857,600 #TBSORCL21# 6 #+DATA/orcldb/datafile/TBSORCL21.dbf# 6 ONLINE NO 1357459 29-JUL-2013 11:23:18 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 34,357,706,752 #TBSORCL4# 7 #+DATA/orcldb/datafile/TBSORCL4.dbf# 7 ONLINE NO 1358352 29-JUL-2013 11:29:47 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 104,857,600 #TBSORCL# 8 #+DATA/orcldb/datafile/TBSORCL.dbf# 8 ONLINE NO 1359063 29-JUL-2013 11:31:14 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 104,857,600 #SPRELITAAAITISALUNA# 9 #+DATA/orcldb/datafile/sprelitaaaitisaluna.dbf# 9 ONLINE NO 1359528 29-JUL-2013 11:32:10 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 171,966,464 #TESTSPR# 10 #+DATA/orcldb/datafile/testspr.dbf# 10 ONLINE NO 1360064 29-JUL-2013 11:33:11 282258621 29-NOV-2014 19:09:17 995548 27-JUL-2013 17:12:39 137,232,384
column error format a15 select error, fuzzy, status, checkpoint_change#, to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time, count(*) from v$datafile_header group by error, fuzzy, status, checkpoint_change#, checkpoint_time order by checkpoint_change#, checkpoint_time; ERROR FUZ STATUS CHECKPOINT_CHANGE# CHECKPOINT_TIME COUNT(*) NO ONLINE 282258621 29-NOV-2014 19:09:17 10 NO ONLINE 483159051 04-DEC-2014 09:16:22 1
select * from X$KCCLH, (select min(checkpoint_change#) df_min_scn, min(checkpoint_change#) df_max_scn from v$datafile_header where status='ONLINE') df where LHLOS in (select first_change# from v$log) or df.df_min_scn between LHLOS and LHNXS or df.df_max_scn between LHLOS and LHNXS; ADDR INDX INST_ID LHRID LHTSM LHSTM LHTHP LHTNP LHSEQ LHLOS LHLOT LHNXS LHNAM LHRLS LHRLC LHIC DF_MIN_SCN DF_MAX_SCN ---------------- -------------------- ------------- ------------- ------------- 00002ABB0A844EB8 147 2 673 11/29/2014 19:09:17 864932957 1 671 401 280405574 11/29/2014 17:52:06 282258621 995548 07/27/2013 17:12:39 2 282258621 282258621 00002ABB0A844EB8 148 2 674 11/29/2014 20:16:31 864936991 1 673 402 282258621 11/29/2014 19:09:17 284112603 995548 07/27/2013 17:12:39 2 282258621 282258621 00002ABB0A844EB8 150 2 676 11/29/2014 21:20:18 864940818 2 672 273 280405964 11/29/2014 17:52:08 285970919 995548 07/27/2013 17:12:39 2 282258621 282258621 00002ABB0A844EB8 289 2 815 12/04/2014 05:45:29 865403129 2 811 309 474881799 12/04/2014 02:05:02 478657004 995548 07/27/2013 17:12:39 2 282258621 282258621 00002ABB0A844EB8 291 2 817 12/04/2014 08:50:16 865414216 1 816 508 480525399 12/04/2014 07:28:32 482400653 995548 07/27/2013 17:12:39 2 282258621 282258621
select AL.*, DF.min_checkpoint_change#, DF.min_checkpoint_time from v$archived_log AL, (select min(checkpoint_change#) min_checkpoint_change#, min(checkpoint_time) min_checkpoint_time from v$datafile_header where status='ONLINE') DF where DF.min_checkpoint_change# between AL.first_change# and AL.next_change# order by AL.first_change#; RECID STAMP NAME DEST_ID THREAD# SEQUENCE# RESETLOGS_CHANGE# RESETLOGS_TIME RESETLOGS_ID FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME BLOCKS BLOCK_SIZE CREATOR REGISTR STA ARC APPLIED DEL STATUS COMPLETION_TIME DIC DIC END BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION# IS_ COM FAL END_OF_RED BAC MIN_CHECKPOINT_CHANGE# MIN_CHECKPOINT_TIME 829 870401153 +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_401.270.870386333 1 1 401 995548 27-JUL-2013 17:12:39 821898759 280405574 29-NOV-2014 17:52:06 282258621 29-NOV-2014 19:09:17 1879169 512 RMAN RMAN NO YES NO NO A 31-JAN-2015 02:05:53 NO NO NO 0 0 0 NO NO NO NO 282258621 29-NOV-2014 19:09:17 846 870401153 +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_273.398.870386455 1 2 273 995548 27-JUL-2013 17:12:39 821898759 280405964 29-NOV-2014 17:52:08 285970919 29-NOV-2014 21:20:18 7331 512 RMAN RMAN NO YES NO NO A 31-JAN-2015 02:05:53 NO NO NO 0 0 0 NO NO NO NO 282258621 29-NOV-2014 19:09:17 828 870401153 +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_402.265.870386333 1 1 402 995548 27-JUL-2013 17:12:39 821898759 282258621 29-NOV-2014 19:09:17 284112603 29-NOV-2014 20:16:31 1879536 512 RMAN RMAN NO YES NO NO A 31-JAN-2015 02:05:53 NO NO NO 0 0 0 NO NO NO NO 282258621 29-NOV-2014 19:09:17
Note: There are various other commands as well but above one are related to rca.
Recommendation-1
1/ According to the results of the query on V$DATAFILE_HEADER in above, all of the 10 datafiles have CHECKPOINT_TIME='29-NOV-2014 19:09:17', while the datafile# 11, '+DATA/orcldb/datafile/TBSORCL21.268.865415781' has CHECKPOINT_TIME='04-DEC-2014 09:16:22'. 2/ Before you can normally open the database, all of the datafiles must not be fuzzy and have similar CHECKPOINT_CHANGE#/TIME. If you want to recover the database before '04-DEC-2014 09:16:22', then you need to restore the datafile# 11 from a backup taken before the said date. However, if you want to recover the database beyond ''04-DEC-2014 09:16:22', then recover the database by applying the archivelogs generated since '29-NOV-2014 19:09:17'.
Action-1
spool log to rman_df11_restore01.log set echo on show all; report schema; list incarnation; list backup summary; list backup; list copy; list backup of datafile 11; list copy of datafile 11; run { set until time "to_date('29-NOV-2014 19:09:17','DD-MON-RRRR HH24:MI:SS')"; restore datafile 11; } spool log off Important Note: Before running the RMAN commands posted above, please issue the following OS command to set the NLS_DATE_FORMAT, as shown below. This will allow to display the date, as well as, the time information, which will help us in our analysis. NLS_DATE_FORMAT="DD-MON-RRRR HH24:MI:SS" export NLS_DATE_FORMAT
Spooling started in log file: /home/oracle/rman_df11_restore01.log Recovery Manager11.2.0.3.0 RMAN> set echo on echo set on RMAN> show all; RMAN configuration parameters for database with db_unique_name orcldb are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default 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 PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 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 '+FRA/orcldb/snapshot/snapcf_orcldb.f'; RMAN> report schema; RMAN-06139: WARNING: control file is not current for REPORT SCHEMA Report of database schema for database with db_unique_name orcldb List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 8540 SYSTEM *** +DATA/orcldb/datafile/system.262.821898691 2 750 SYSAUX *** +DATA/orcldb/datafile/sysaux.260.821898691 3 5040 UNDOTBS1 *** +DATA/orcldb/datafile/undotbs1.261.821898691 4 5 USERS *** +DATA/orcldb/datafile/users.259.821898691 5 100 UNDOTBS2 *** +DATA/orcldb/datafile/undotbs2.257.821898845 6 32766 TBSORCL21 *** +DATA/orcldb/datafile/TBSORCL21.dbf 7 100 TBSORCL4 *** +DATA/orcldb/datafile/TBSORCL4.dbf 8 100 TBSORCL *** +DATA/orcldb/datafile/TBSORCL.dbf 9 164 SPRELITAAAITISALUNA *** +DATA/orcldb/datafile/sprelitaaaitisaluna.dbf 10 130 TESTSPR *** +DATA/orcldb/datafile/testspr.dbf 11 100 TBSORCL21 *** +DATA/orcldb/datafile/TBSORCL21.268.865415781 List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 65 TEMP 32767 +DATA/orcldb/tempfile/temp.258.821898785 RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 orcldb 489766533 PARENT 1 17-SEP-2011 09:46:04 2 2 orcldb 489766533 CURRENT 995548 27-JUL-2013 17:12:39 RMAN> list backup summary; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- -------------------- ------- ------- ---------- --- 528 B F A DISK 27-NOV-2014 02:15:31 41 1 NO TAG20141127T020531 530 B A A DISK 27-NOV-2014 02:15:37 1 1 NO TAG20141127T021536 531 B F A DISK 27-NOV-2014 02:15:38 1 1 NO TAG20141127T021538 532 B A A DISK 30-NOV-2014 02:08:33 14 1 NO TAG20141130T020512 533 B A A DISK 04-DEC-2014 02:12:17 30 1 NO TAG20141204T020512 534 B A A DISK 04-DEC-2014 02:19:48 30 1 NO TAG20141204T020512 RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ -------------------- 528 Full 40.59G DISK 00:09:59 27-NOV-2014 02:15:31 List of Datafiles in backup set 528 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 1 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/system.262.821898691 2 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/sysaux.260.821898691 3 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/undotbs1.261.821898691 4 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/users.259.821898691 5 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/undotbs2.257.821898845 6 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/TBSORCL21.dbf 7 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/TBSORCL4.dbf 8 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/TBSORCL.dbf 9 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/sprelitaaaitisaluna.dbf 10 Full 266654965 27-NOV-2014 02:05:32 +DATA/orcldb/datafile/testspr.dbf Backup Set Copy #1 of backup set 528 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ -------------------- ---------- --- DISK 00:09:59 27-NOV-2014 02:15:31 NO TAG20141127T020531 List of Backup Pieces for backup set 528 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 2250 1 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_1_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2251 2 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_2_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2252 3 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_3_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2253 4 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_4_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2254 5 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_5_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2255 6 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_6_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2256 7 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_7_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2257 8 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_8_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2258 9 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_9_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2259 10 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_10_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2260 11 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_11_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2261 12 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_12_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2262 13 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_13_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2263 14 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_14_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2264 15 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_15_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2265 16 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_16_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2266 17 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_17_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2267 18 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_18_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2268 19 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_19_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2269 20 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_20_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2270 21 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_21_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2271 22 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_22_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2272 23 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_23_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2273 24 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_24_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2274 25 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_25_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2275 26 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_26_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2276 27 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_27_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2277 28 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_28_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2278 29 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_29_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2279 30 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_30_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2280 31 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_31_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2281 32 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_32_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2282 33 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_33_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2283 34 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_34_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2284 35 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_35_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2285 36 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_36_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2286 37 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_37_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2287 38 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_38_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2288 39 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_39_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2289 40 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_40_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 2290 41 AVAILABLE /backup/rmanbackup/rman_bkp_hrpokgbc_41_1_orcldb_20141127_DATAFILE_FULL_27_11_2014 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ -------------------- 530 2.72M DISK 00:00:00 27-NOV-2014 02:15:37 BP Key: 2292 Status: AVAILABLE Compressed: NO Tag: TAG20141127T021536 Piece Name: /backup/rmanbackup/rman_bkp_htpokgu9_1_1_orcldb_20141127_ARCHIVELOG_27_11_2014 List of Archived Logs in backup set 530 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 392 266654808 27-NOV-2014 02:05:02 266659229 27-NOV-2014 02:15:34 2 269 266654803 27-NOV-2014 02:05:02 266659220 27-NOV-2014 02:15:33 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ -------------------- 531 Full 17.70M DISK 00:00:00 27-NOV-2014 02:15:38 BP Key: 2293 Status: AVAILABLE Compressed: NO Tag: TAG20141127T021538 Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/c-489766533-20141127-00 SPFILE Included: Modification time: 05-OCT-2014 10:01:39 SPFILE db_unique_name: orcldb Control File Included: Ckp SCN: 266659252 Ckp time: 27-NOV-2014 02:15:38 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ -------------------- 532 13.56G DISK 00:03:20 30-NOV-2014 02:08:33 List of Archived Logs in backup set 532 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 393 266659229 27-NOV-2014 02:15:34 267703333 28-NOV-2014 18:10:36 1 394 267703333 28-NOV-2014 18:10:36 269280814 29-NOV-2014 08:49:28 1 395 269280814 29-NOV-2014 08:49:28 271140117 29-NOV-2014 10:42:31 1 396 271140117 29-NOV-2014 10:42:31 272990133 29-NOV-2014 12:16:31 1 397 272990133 29-NOV-2014 12:16:31 274841558 29-NOV-2014 13:42:54 1 398 274841558 29-NOV-2014 13:42:54 276695763 29-NOV-2014 15:04:47 1 399 276695763 29-NOV-2014 15:04:47 278550497 29-NOV-2014 16:26:34 1 400 278550497 29-NOV-2014 16:26:34 280405574 29-NOV-2014 17:52:06 1 401 280405574 29-NOV-2014 17:52:06 282258621 29-NOV-2014 19:09:17 1 402 282258621 29-NOV-2014 19:09:17 284112603 29-NOV-2014 20:16:31 1 403 284112603 29-NOV-2014 20:16:31 285970693 29-NOV-2014 21:20:17 1 404 285970693 29-NOV-2014 21:20:17 287825008 29-NOV-2014 22:21:37 1 405 287825008 29-NOV-2014 22:21:37 289679608 29-NOV-2014 23:24:06 1 406 289679608 29-NOV-2014 23:24:06 291531088 30-NOV-2014 00:32:49 1 407 291531088 30-NOV-2014 00:32:49 293381547 30-NOV-2014 02:05:04 2 270 266659220 27-NOV-2014 02:15:33 269280971 29-NOV-2014 08:49:29 2 271 269280971 29-NOV-2014 08:49:29 274842253 29-NOV-2014 13:42:56 2 272 274842253 29-NOV-2014 13:42:56 280405964 29-NOV-2014 17:52:08 2 273 280405964 29-NOV-2014 17:52:08 285970919 29-NOV-2014 21:20:18 2 274 285970919 29-NOV-2014 21:20:18 291532108 30-NOV-2014 00:32:52 2 275 291532108 30-NOV-2014 00:32:52 293381201 30-NOV-2014 02:05:02 Backup Set Copy #1 of backup set 532 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ -------------------- ---------- --- DISK 00:03:20 30-NOV-2014 02:08:32 NO TAG20141130T020512 List of Backup Pieces for backup set 532 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 2294 1 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_1_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2295 2 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_2_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2296 3 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_3_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2297 4 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_4_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2298 5 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_5_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2299 6 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_6_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2300 7 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_7_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2301 8 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_8_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2302 9 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_9_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2303 10 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_10_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2304 11 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_11_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2305 12 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_12_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2306 13 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_13_1_orcldb_20141130_ARCHIVELOG_30_11_2014 2307 14 AVAILABLE /backup/rmanbackup/rman_bkp_hvposdep_14_1_orcldb_20141130_ARCHIVELOG_30_11_2014 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ -------------------- 533 29.63G DISK 00:07:04 04-DEC-2014 02:12:17 List of Archived Logs in backup set 533 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 408 293381547 30-NOV-2014 02:05:04 295175276 30-NOV-2014 04:17:26 1 409 295175276 30-NOV-2014 04:17:26 297016933 30-NOV-2014 07:00:54 1 410 297016933 30-NOV-2014 07:00:54 298864673 30-NOV-2014 09:19:21 1 411 298864673 30-NOV-2014 09:19:21 300707705 30-NOV-2014 11:03:06 1 412 300707705 30-NOV-2014 11:03:06 302554351 30-NOV-2014 12:39:02 1 413 302554351 30-NOV-2014 12:39:02 304413355 30-NOV-2014 14:01:22 1 414 304413355 30-NOV-2014 14:01:22 306305119 30-NOV-2014 14:56:00 1 415 306305119 30-NOV-2014 14:56:00 308195481 30-NOV-2014 15:48:49 1 416 308195481 30-NOV-2014 15:48:49 310084603 30-NOV-2014 16:40:47 1 417 310084603 30-NOV-2014 16:40:47 311973986 30-NOV-2014 17:31:36 1 418 311973986 30-NOV-2014 17:31:36 313857575 30-NOV-2014 18:20:34 1 419 313857575 30-NOV-2014 18:20:34 315750179 30-NOV-2014 19:07:45 1 420 315750179 30-NOV-2014 19:07:45 317646575 30-NOV-2014 19:51:40 1 421 317646575 30-NOV-2014 19:51:40 319546900 30-NOV-2014 20:31:05 1 422 319546900 30-NOV-2014 20:31:05 321449269 30-NOV-2014 21:08:00 1 423 321449269 30-NOV-2014 21:08:00 323352618 30-NOV-2014 21:44:16 1 424 323352618 30-NOV-2014 21:44:16 325253052 30-NOV-2014 22:22:08 1 425 325253052 30-NOV-2014 22:22:08 327149419 30-NOV-2014 23:03:09 1 426 327149419 30-NOV-2014 23:03:09 329043209 30-NOV-2014 23:49:08 1 427 329043209 30-NOV-2014 23:49:08 330930031 01-DEC-2014 00:42:54 1 428 330930031 01-DEC-2014 00:42:54 332813156 01-DEC-2014 01:39:53 1 429 332813156 01-DEC-2014 01:39:53 334686832 01-DEC-2014 03:09:16 1 430 334686832 01-DEC-2014 03:09:16 336479909 01-DEC-2014 05:06:37 1 431 336479909 01-DEC-2014 05:06:37 338351182 01-DEC-2014 07:09:34 1 432 338351182 01-DEC-2014 07:09:34 340226062 01-DEC-2014 08:45:18 1 433 340226062 01-DEC-2014 08:45:18 342106822 01-DEC-2014 09:54:59 1 434 342106822 01-DEC-2014 09:54:59 343990168 01-DEC-2014 10:54:41 1 435 343990168 01-DEC-2014 10:54:41 345878328 01-DEC-2014 11:50:51 1 436 345878328 01-DEC-2014 11:50:51 347770928 01-DEC-2014 12:40:44 1 437 347770928 01-DEC-2014 12:40:44 349661540 01-DEC-2014 13:34:24 1 438 349661540 01-DEC-2014 13:34:24 351551690 01-DEC-2014 14:28:20 1 439 351551690 01-DEC-2014 14:28:20 353440861 01-DEC-2014 15:19:58 1 440 353440861 01-DEC-2014 15:19:58 355331208 01-DEC-2014 16:10:08 2 276 293381201 30-NOV-2014 02:05:02 297017049 30-NOV-2014 07:00:55 2 277 297017049 30-NOV-2014 07:00:55 302554994 30-NOV-2014 12:39:05 2 278 302554994 30-NOV-2014 12:39:05 308196833 30-NOV-2014 15:48:52 2 279 308196833 30-NOV-2014 15:48:52 313858712 30-NOV-2014 18:20:37 2 280 313858712 30-NOV-2014 18:20:37 319547815 30-NOV-2014 20:31:07 2 281 319547815 30-NOV-2014 20:31:07 325253833 30-NOV-2014 22:22:09 2 282 325253833 30-NOV-2014 22:22:09 330930209 01-DEC-2014 00:42:55 2 283 330930209 01-DEC-2014 00:42:55 336480530 01-DEC-2014 05:06:40 2 284 336480530 01-DEC-2014 05:06:40 342107564 01-DEC-2014 09:55:01 2 285 342107564 01-DEC-2014 09:55:01 347772319 01-DEC-2014 12:40:46 2 286 347772319 01-DEC-2014 12:40:46 353441416 01-DEC-2014 15:19:59 Backup Set Copy #1 of backup set 533 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ -------------------- ---------- --- DISK 00:07:04 04-DEC-2014 02:12:17 NO TAG20141204T020512 List of Backup Pieces for backup set 533 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 2308 1 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_1_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2309 2 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_2_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2310 3 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_3_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2311 4 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_4_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2312 5 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_5_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2313 6 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_6_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2314 7 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_7_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2315 8 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_8_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2316 9 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_9_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2317 10 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_10_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2318 11 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_11_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2319 12 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_12_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2320 13 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_13_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2321 14 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_14_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2322 15 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_15_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2323 16 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_16_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2324 17 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_17_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2325 18 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_18_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2326 19 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_19_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2327 20 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_20_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2328 21 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_21_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2329 22 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_22_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2330 23 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_23_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2331 24 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_24_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2332 25 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_25_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2333 26 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_26_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2334 27 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_27_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2335 28 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_28_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2336 29 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_29_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2337 30 AVAILABLE /backup/rmanbackup/rman_bkp_i1pp9jap_30_1_orcldb_20141204_ARCHIVELOG_04_12_2014 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ -------------------- 534 29.63G DISK 00:07:22 04-DEC-2014 02:19:48 List of Archived Logs in backup set 534 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 441 355331208 01-DEC-2014 16:10:08 357219056 01-DEC-2014 17:03:46 1 442 357219056 01-DEC-2014 17:03:46 359108215 01-DEC-2014 17:58:06 1 443 359108215 01-DEC-2014 17:58:06 360997732 01-DEC-2014 18:49:25 1 444 360997732 01-DEC-2014 18:49:25 362891438 01-DEC-2014 19:34:38 1 445 362891438 01-DEC-2014 19:34:38 364792369 01-DEC-2014 20:14:13 1 446 364792369 01-DEC-2014 20:14:13 366694378 01-DEC-2014 20:54:30 1 447 366694378 01-DEC-2014 20:54:30 368595352 01-DEC-2014 21:34:44 1 448 368595352 01-DEC-2014 21:34:44 370499421 01-DEC-2014 22:16:09 1 449 370499421 01-DEC-2014 22:16:09 372404109 01-DEC-2014 22:53:28 1 450 372404109 01-DEC-2014 22:53:28 374300198 01-DEC-2014 23:35:54 1 451 374300198 01-DEC-2014 23:35:54 376192607 02-DEC-2014 00:21:01 1 452 376192607 02-DEC-2014 00:21:01 378077691 02-DEC-2014 01:16:21 1 453 378077691 02-DEC-2014 01:16:21 379954440 02-DEC-2014 02:29:38 1 454 379954440 02-DEC-2014 02:29:38 381753810 02-DEC-2014 04:02:31 1 455 381753810 02-DEC-2014 04:02:31 383625520 02-DEC-2014 05:54:26 1 456 383625520 02-DEC-2014 05:54:26 385497446 02-DEC-2014 07:43:28 1 457 385497446 02-DEC-2014 07:43:28 387374483 02-DEC-2014 09:02:52 1 458 387374483 02-DEC-2014 09:02:52 389258444 02-DEC-2014 10:02:59 1 459 389258444 02-DEC-2014 10:02:59 391143370 02-DEC-2014 11:00:48 1 460 391143370 02-DEC-2014 11:00:48 393031238 02-DEC-2014 11:56:26 1 461 393031238 02-DEC-2014 11:56:26 394920721 02-DEC-2014 12:51:18 1 462 394920721 02-DEC-2014 12:51:18 396813149 02-DEC-2014 13:42:53 1 463 396813149 02-DEC-2014 13:42:53 398702559 02-DEC-2014 14:38:54 1 464 398702559 02-DEC-2014 14:38:54 400590746 02-DEC-2014 15:34:38 1 465 400590746 02-DEC-2014 15:34:38 402479975 02-DEC-2014 16:30:12 1 466 402479975 02-DEC-2014 16:30:12 404366251 02-DEC-2014 17:27:10 1 467 404366251 02-DEC-2014 17:27:10 406257579 02-DEC-2014 18:17:07 1 468 406257579 02-DEC-2014 18:17:07 408154834 02-DEC-2014 19:00:51 1 469 408154834 02-DEC-2014 19:00:51 410055405 02-DEC-2014 19:43:19 1 470 410055405 02-DEC-2014 19:43:19 411958987 02-DEC-2014 20:22:30 1 471 411958987 02-DEC-2014 20:22:30 413864825 02-DEC-2014 20:57:55 1 472 413864825 02-DEC-2014 20:57:55 415772442 02-DEC-2014 21:32:23 1 473 415772442 02-DEC-2014 21:32:23 417659388 02-DEC-2014 22:09:16 2 287 353441416 01-DEC-2014 15:19:59 359109379 01-DEC-2014 17:58:09 2 288 359109379 01-DEC-2014 17:58:09 364793432 01-DEC-2014 20:14:15 2 289 364793432 01-DEC-2014 20:14:15 370500508 01-DEC-2014 22:16:11 2 290 370500508 01-DEC-2014 22:16:11 376192988 02-DEC-2014 00:21:02 2 291 376192988 02-DEC-2014 00:21:02 381753921 02-DEC-2014 04:02:31 2 292 381753921 02-DEC-2014 04:02:31 387374927 02-DEC-2014 09:02:53 2 293 387374927 02-DEC-2014 09:02:53 393031775 02-DEC-2014 11:56:27 2 294 393031775 02-DEC-2014 11:56:27 398702648 02-DEC-2014 14:38:54 2 295 398702648 02-DEC-2014 14:38:54 404367460 02-DEC-2014 17:27:13 2 296 404367460 02-DEC-2014 17:27:13 410056811 02-DEC-2014 19:43:22 2 297 410056811 02-DEC-2014 19:43:22 415773210 02-DEC-2014 21:32:24 Backup Set Copy #1 of backup set 534 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ -------------------- ---------- --- DISK 00:07:22 04-DEC-2014 02:19:48 NO TAG20141204T020512 List of Backup Pieces for backup set 534 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 2338 1 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_1_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2339 2 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_2_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2340 3 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_3_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2341 4 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_4_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2342 5 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_5_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2343 6 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_6_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2344 7 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_7_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2345 8 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_8_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2346 9 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_9_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2347 10 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_10_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2348 11 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_11_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2349 12 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_12_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2350 13 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_13_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2351 14 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_14_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2352 15 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_15_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2353 16 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_16_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2354 17 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_17_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2355 18 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_18_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2356 19 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_19_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2357 20 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_20_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2358 21 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_21_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2359 22 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_22_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2360 23 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_23_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2361 24 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_24_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2362 25 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_25_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2363 26 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_26_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2364 27 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_27_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2365 28 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_28_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2366 29 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_29_1_orcldb_20141204_ARCHIVELOG_04_12_2014 2367 30 AVAILABLE /backup/rmanbackup/rman_bkp_i2pp9joa_30_1_orcldb_20141204_ARCHIVELOG_04_12_2014 RMAN> list copy; specification does not match any datafile copy in the repository specification does not match any control file copy in the repository List of Archived Log Copies for database with db_unique_name orcldb ===================================================================== Key Thrd Seq S Low Time ------- ---- ------- - -------------------- 826 1 392 A 27-NOV-2014 02:05:02 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_392.267.870386331 838 1 393 A 27-NOV-2014 02:15:34 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_393.283.870386441 831 1 394 A 28-NOV-2014 18:10:36 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_394.277.870386335 840 1 395 A 29-NOV-2014 08:49:28 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_395.280.870386441 839 1 396 A 29-NOV-2014 10:42:31 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_396.282.870386441 837 1 397 A 29-NOV-2014 12:16:31 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_397.279.870386441 833 1 398 A 29-NOV-2014 13:42:54 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_398.275.870386335 835 1 399 A 29-NOV-2014 15:04:47 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_399.281.870386335 836 1 400 A 29-NOV-2014 16:26:34 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_400.276.870386441 829 1 401 A 29-NOV-2014 17:52:06 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_401.270.870386333 828 1 402 A 29-NOV-2014 19:09:17 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_402.265.870386333 834 1 403 A 29-NOV-2014 20:16:31 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_403.278.870386335 841 1 404 A 29-NOV-2014 21:20:17 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_404.393.870386441 832 1 405 A 29-NOV-2014 22:21:37 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_405.272.870386335 830 1 406 A 29-NOV-2014 23:24:06 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_406.274.870386335 842 1 407 A 30-NOV-2014 00:32:49 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_407.394.870386441 868 1 408 A 30-NOV-2014 02:05:04 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_408.420.870387171 878 1 409 A 30-NOV-2014 04:17:26 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_409.430.870387279 867 1 410 A 30-NOV-2014 07:00:54 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_410.419.870387171 869 1 411 A 30-NOV-2014 09:19:21 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_411.421.870387171 879 1 412 A 30-NOV-2014 11:03:06 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_412.431.870387279 857 1 413 A 30-NOV-2014 12:39:02 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_413.409.870387065 862 1 414 A 30-NOV-2014 14:01:22 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_414.414.870387065 856 1 415 A 30-NOV-2014 14:56:00 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_415.408.870386959 871 1 416 A 30-NOV-2014 15:48:49 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_416.423.870387173 860 1 417 A 30-NOV-2014 16:40:47 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_417.412.870387065 875 1 418 A 30-NOV-2014 17:31:36 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_418.427.870387277 864 1 419 A 30-NOV-2014 18:20:34 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_419.416.870387065 851 1 420 A 30-NOV-2014 19:07:45 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_420.403.870386957 850 1 421 A 30-NOV-2014 19:51:40 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_421.402.870386957 870 1 422 A 30-NOV-2014 20:31:05 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_422.422.870387173 881 1 423 A 30-NOV-2014 21:08:00 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_423.433.870387383 849 1 424 A 30-NOV-2014 21:44:16 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_424.401.870386957 877 1 425 A 30-NOV-2014 22:22:08 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_425.429.870387279 855 1 426 A 30-NOV-2014 23:03:09 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_426.407.870386959 858 1 427 A 30-NOV-2014 23:49:08 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_427.410.870387065 873 1 428 A 01-DEC-2014 00:42:54 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_428.425.870387277 874 1 429 A 01-DEC-2014 01:39:53 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_429.426.870387277 876 1 430 A 01-DEC-2014 03:09:16 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_430.428.870387279 872 1 431 A 01-DEC-2014 05:06:37 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_431.424.870387173 880 1 432 A 01-DEC-2014 07:09:34 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_432.432.870387279 866 1 433 A 01-DEC-2014 08:45:18 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_433.418.870387171 863 1 434 A 01-DEC-2014 09:54:59 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_434.415.870387065 861 1 435 A 01-DEC-2014 10:54:41 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_435.413.870387065 853 1 436 A 01-DEC-2014 11:50:51 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_436.405.870386957 852 1 437 A 01-DEC-2014 12:40:44 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_437.404.870386957 854 1 438 A 01-DEC-2014 13:34:24 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_438.406.870386959 865 1 439 A 01-DEC-2014 14:28:20 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_439.417.870387171 859 1 440 A 01-DEC-2014 15:19:58 Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_440.411.870387065 771 1 474 A 02-DEC-2014 22:09:16 Name: +FRA/orcldb/archivelog/2014_12_02/thread_1_seq_474.351.865291583 773 1 475 A 02-DEC-2014 22:46:23 Name: +FRA/orcldb/archivelog/2014_12_02/thread_1_seq_475.352.865293843 774 1 476 A 02-DEC-2014 23:24:03 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_476.354.865296515 775 1 477 A 03-DEC-2014 00:08:34 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_477.355.865299389 777 1 478 A 03-DEC-2014 00:56:29 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_478.356.865303511 778 1 479 A 03-DEC-2014 02:05:10 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_479.358.865309161 779 1 480 A 03-DEC-2014 03:39:21 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_480.359.865316487 781 1 481 A 03-DEC-2014 05:41:27 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_481.360.865322749 782 1 482 A 03-DEC-2014 07:25:48 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_482.362.865327729 783 1 483 A 03-DEC-2014 08:48:48 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_483.363.865331865 785 1 484 A 03-DEC-2014 09:57:44 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_484.364.865335329 786 1 485 A 03-DEC-2014 10:55:27 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_485.366.865338603 787 1 486 A 03-DEC-2014 11:50:02 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_486.367.865341793 789 1 487 A 03-DEC-2014 12:43:12 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_487.368.865345067 790 1 488 A 03-DEC-2014 13:37:47 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_488.370.865348267 791 1 489 A 03-DEC-2014 14:31:06 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_489.371.865351367 793 1 490 A 03-DEC-2014 15:22:47 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_490.372.865354593 794 1 491 A 03-DEC-2014 16:16:33 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_491.374.865357729 795 1 492 A 03-DEC-2014 17:08:49 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_492.375.865360923 797 1 493 A 03-DEC-2014 18:02:02 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_493.376.865363537 798 1 494 A 03-DEC-2014 18:45:36 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_494.378.865365977 799 1 495 A 03-DEC-2014 19:26:17 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_495.379.865368307 801 1 496 A 03-DEC-2014 20:05:07 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_496.380.865370613 802 1 497 A 03-DEC-2014 20:43:33 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_497.382.865372803 803 1 498 A 03-DEC-2014 21:20:02 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_498.383.865374789 805 1 499 A 03-DEC-2014 21:53:09 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_499.384.865376911 806 1 500 A 03-DEC-2014 22:28:31 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_500.386.865379277 807 1 501 A 03-DEC-2014 23:07:57 Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_501.387.865381817 809 1 502 A 03-DEC-2014 23:50:16 Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_502.388.865384929 810 1 503 A 04-DEC-2014 00:42:08 Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_503.390.865388651 812 1 504 A 04-DEC-2014 01:44:10 Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_504.392.865389907 813 1 505 A 04-DEC-2014 02:05:07 Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_505.350.865395725 815 1 506 A 04-DEC-2014 03:42:05 Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_506.348.865403127 816 1 507 A 04-DEC-2014 05:45:26 Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_507.349.865409313 817 1 508 A 04-DEC-2014 07:28:32 Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_508.346.865414217 956 1 509 A 04-DEC-2014 08:50:16 Name: +FRA/orcldb/archivelog/2014_12_05/thread_1_seq_509.344.865504341 953 1 510 A 05-DEC-2014 09:52:20 Name: +FRA/orcldb/archivelog/2014_12_07/thread_1_seq_510.345.865643287 954 1 511 A 07-DEC-2014 00:28:06 Name: +FRA/orcldb/archivelog/2014_12_07/thread_1_seq_511.342.865649103 952 1 512 A 07-DEC-2014 02:05:02 Name: +FRA/orcldb/archivelog/2014_12_08/thread_1_seq_512.339.865804589 951 1 513 A 08-DEC-2014 21:16:28 Name: +FRA/orcldb/archivelog/2014_12_10/thread_1_seq_513.341.865951355 949 1 514 A 10-DEC-2014 14:02:35 Name: +FRA/orcldb/archivelog/2014_12_11/thread_1_seq_514.338.865994705 948 1 515 A 11-DEC-2014 02:05:04 Name: +FRA/orcldb/archivelog/2014_12_12/thread_1_seq_515.335.866144541 946 1 516 A 12-DEC-2014 19:42:21 Name: +FRA/orcldb/archivelog/2014_12_14/thread_1_seq_516.337.866253903 945 1 517 A 14-DEC-2014 02:05:03 Name: +FRA/orcldb/archivelog/2014_12_15/thread_1_seq_517.332.866395837 944 1 518 A 15-DEC-2014 17:30:36 Name: +FRA/orcldb/archivelog/2014_12_17/thread_1_seq_518.331.866547803 942 1 519 A 17-DEC-2014 11:43:22 Name: +FRA/orcldb/archivelog/2014_12_18/thread_1_seq_519.333.866599505 941 1 520 A 18-DEC-2014 02:05:04 Name: +FRA/orcldb/archivelog/2014_12_19/thread_1_seq_520.328.866746863 939 1 521 A 19-DEC-2014 19:01:02 Name: +FRA/orcldb/archivelog/2014_12_21/thread_1_seq_521.327.866858705 938 1 522 A 21-DEC-2014 02:05:04 Name: +FRA/orcldb/archivelog/2014_12_22/thread_1_seq_522.326.867004305 937 1 523 A 22-DEC-2014 18:31:44 Name: +FRA/orcldb/archivelog/2014_12_24/thread_1_seq_523.324.867151875 936 1 524 A 24-DEC-2014 11:31:13 Name: +FRA/orcldb/archivelog/2014_12_25/thread_1_seq_524.325.867204305 934 1 525 A 25-DEC-2014 02:05:04 Name: +FRA/orcldb/archivelog/2014_12_26/thread_1_seq_525.322.867345485 933 1 526 A 26-DEC-2014 17:18:04 Name: +FRA/orcldb/archivelog/2014_12_28/thread_1_seq_526.319.867463505 931 1 527 A 28-DEC-2014 02:05:05 Name: +FRA/orcldb/archivelog/2014_12_29/thread_1_seq_527.321.867610709 929 1 528 A 29-DEC-2014 18:58:29 Name: +FRA/orcldb/archivelog/2014_12_31/thread_1_seq_528.318.867762723 928 1 529 A 31-DEC-2014 13:12:02 Name: +FRA/orcldb/archivelog/2015_01_01/thread_1_seq_529.317.867809105 926 1 530 A 01-JAN-2015 02:05:05 Name: +FRA/orcldb/archivelog/2015_01_02/thread_1_seq_530.314.867960171 924 1 531 A 02-JAN-2015 20:02:50 Name: +FRA/orcldb/archivelog/2015_01_04/thread_1_seq_531.312.868068303 923 1 532 A 04-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_05/thread_1_seq_532.313.868211281 922 1 533 A 05-JAN-2015 17:48:00 Name: +FRA/orcldb/archivelog/2015_01_07/thread_1_seq_533.310.868330951 921 1 534 A 07-JAN-2015 03:02:31 Name: +FRA/orcldb/archivelog/2015_01_08/thread_1_seq_534.307.868413905 919 1 535 A 08-JAN-2015 02:05:05 Name: +FRA/orcldb/archivelog/2015_01_09/thread_1_seq_535.309.868545933 917 1 536 A 09-JAN-2015 14:45:32 Name: +FRA/orcldb/archivelog/2015_01_10/thread_1_seq_536.306.868662819 916 1 537 A 10-JAN-2015 23:13:38 Name: +FRA/orcldb/archivelog/2015_01_11/thread_1_seq_537.305.868673105 914 1 538 A 11-JAN-2015 02:05:04 Name: +FRA/orcldb/archivelog/2015_01_12/thread_1_seq_538.302.868815959 912 1 539 A 12-JAN-2015 17:45:58 Name: +FRA/orcldb/archivelog/2015_01_14/thread_1_seq_539.300.868956203 911 1 540 A 14-JAN-2015 08:43:22 Name: +FRA/orcldb/archivelog/2015_01_15/thread_1_seq_540.298.869018703 909 1 541 A 15-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_16/thread_1_seq_541.296.869162717 907 1 542 A 16-JAN-2015 18:05:16 Name: +FRA/orcldb/archivelog/2015_01_18/thread_1_seq_542.295.869277903 906 1 543 A 18-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_19/thread_1_seq_543.294.869417763 905 1 544 A 19-JAN-2015 16:56:03 Name: +FRA/orcldb/archivelog/2015_01_21/thread_1_seq_544.292.869538385 904 1 545 A 21-JAN-2015 02:26:25 Name: +FRA/orcldb/archivelog/2015_01_22/thread_1_seq_545.293.869623505 902 1 546 A 22-JAN-2015 02:05:05 Name: +FRA/orcldb/archivelog/2015_01_23/thread_1_seq_546.290.869754475 898 1 547 A 23-JAN-2015 14:27:54 Name: +FRA/orcldb/archivelog/2015_01_25/thread_1_seq_547.288.869881487 901 1 548 A 25-JAN-2015 01:44:46 Name: +FRA/orcldb/archivelog/2015_01_25/thread_1_seq_548.286.869882709 897 1 549 A 25-JAN-2015 02:05:08 Name: +FRA/orcldb/archivelog/2015_01_26/thread_1_seq_549.284.870019983 895 1 550 A 26-JAN-2015 16:13:03 Name: +FRA/orcldb/archivelog/2015_01_28/thread_1_seq_550.266.870155813 894 1 551 A 28-JAN-2015 05:56:52 Name: +FRA/orcldb/archivelog/2015_01_29/thread_1_seq_551.263.870228305 827 2 269 A 27-NOV-2014 02:05:02 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_269.273.870386331 843 2 270 A 27-NOV-2014 02:15:33 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_270.395.870386441 844 2 271 A 29-NOV-2014 08:49:29 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_271.396.870386451 845 2 272 A 29-NOV-2014 13:42:56 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_272.397.870386455 846 2 273 A 29-NOV-2014 17:52:08 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_273.398.870386455 847 2 274 A 29-NOV-2014 21:20:18 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_274.399.870386455 848 2 275 A 30-NOV-2014 00:32:52 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_275.400.870386455 892 2 276 A 30-NOV-2014 02:05:02 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_276.444.870387385 889 2 277 A 30-NOV-2014 07:00:55 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_277.441.870387385 884 2 278 A 30-NOV-2014 12:39:05 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_278.436.870387385 886 2 279 A 30-NOV-2014 15:48:52 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_279.438.870387385 890 2 280 A 30-NOV-2014 18:20:37 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_280.442.870387385 891 2 281 A 30-NOV-2014 20:31:07 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_281.443.870387385 888 2 282 A 30-NOV-2014 22:22:09 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_282.440.870387385 882 2 283 A 01-DEC-2014 00:42:55 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_283.434.870387385 883 2 284 A 01-DEC-2014 05:06:40 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_284.435.870387385 885 2 285 A 01-DEC-2014 09:55:01 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_285.437.870387385 887 2 286 A 01-DEC-2014 12:40:46 Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_286.439.870387385 772 2 298 A 02-DEC-2014 21:32:24 Name: +FRA/orcldb/archivelog/2014_12_02/thread_2_seq_298.353.865293845 776 2 299 A 02-DEC-2014 23:24:03 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_299.357.865303511 780 2 300 A 03-DEC-2014 02:05:11 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_300.361.865322751 784 2 301 A 03-DEC-2014 07:25:51 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_301.365.865335329 788 2 302 A 03-DEC-2014 10:55:28 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_302.369.865345069 792 2 303 A 03-DEC-2014 13:37:47 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_303.373.865354595 796 2 304 A 03-DEC-2014 16:16:33 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_304.377.865363537 800 2 305 A 03-DEC-2014 18:45:37 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_305.381.865370615 804 2 306 A 03-DEC-2014 20:43:34 Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_306.385.865376915 808 2 307 A 03-DEC-2014 22:28:34 Name: +FRA/orcldb/archivelog/2014_12_04/thread_2_seq_307.389.865384931 811 2 308 A 04-DEC-2014 00:42:10 Name: +FRA/orcldb/archivelog/2014_12_04/thread_2_seq_308.391.865389903 814 2 309 A 04-DEC-2014 02:05:02 Name: +FRA/orcldb/archivelog/2014_12_04/thread_2_seq_309.347.865403129 957 2 310 A 04-DEC-2014 05:45:29 Name: +FRA/orcldb/archivelog/2014_12_05/thread_2_seq_310.343.865504343 955 2 311 A 05-DEC-2014 09:52:21 Name: +FRA/orcldb/archivelog/2014_12_07/thread_2_seq_311.340.865649105 950 2 312 A 07-DEC-2014 02:05:05 Name: +FRA/orcldb/archivelog/2014_12_11/thread_2_seq_312.336.865994705 947 2 313 A 11-DEC-2014 02:05:05 Name: +FRA/orcldb/archivelog/2014_12_14/thread_2_seq_313.334.866253905 943 2 314 A 14-DEC-2014 02:05:03 Name: +FRA/orcldb/archivelog/2014_12_18/thread_2_seq_314.330.866599507 940 2 315 A 18-DEC-2014 02:05:06 Name: +FRA/orcldb/archivelog/2014_12_21/thread_2_seq_315.329.866858705 935 2 316 A 21-DEC-2014 02:05:04 Name: +FRA/orcldb/archivelog/2014_12_25/thread_2_seq_316.323.867204305 932 2 317 A 25-DEC-2014 02:05:03 Name: +FRA/orcldb/archivelog/2014_12_28/thread_2_seq_317.320.867463503 930 2 318 A 28-DEC-2014 02:05:03 Name: +FRA/orcldb/archivelog/2014_12_31/thread_2_seq_318.316.867762725 927 2 319 A 31-DEC-2014 13:12:05 Name: +FRA/orcldb/archivelog/2015_01_01/thread_2_seq_319.315.867809103 925 2 320 A 01-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_04/thread_2_seq_320.311.868068305 920 2 321 A 04-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_08/thread_2_seq_321.308.868413903 918 2 322 A 08-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_10/thread_2_seq_322.304.868662821 915 2 323 A 10-JAN-2015 23:13:40 Name: +FRA/orcldb/archivelog/2015_01_11/thread_2_seq_323.303.868673103 913 2 324 A 11-JAN-2015 02:05:02 Name: +FRA/orcldb/archivelog/2015_01_14/thread_2_seq_324.299.868956205 910 2 325 A 14-JAN-2015 08:43:24 Name: +FRA/orcldb/archivelog/2015_01_15/thread_2_seq_325.301.869018703 908 2 326 A 15-JAN-2015 02:05:02 Name: +FRA/orcldb/archivelog/2015_01_18/thread_2_seq_326.297.869277903 903 2 327 A 18-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_22/thread_2_seq_327.291.869623503 899 2 328 A 22-JAN-2015 02:05:03 Name: +FRA/orcldb/archivelog/2015_01_25/thread_2_seq_328.287.869881489 900 2 329 A 25-JAN-2015 01:44:47 Name: +FRA/orcldb/archivelog/2015_01_25/thread_2_seq_329.289.869882705 896 2 330 A 25-JAN-2015 02:05:04 Name: +FRA/orcldb/archivelog/2015_01_28/thread_2_seq_330.285.870155815 893 2 331 A 28-JAN-2015 05:56:53 Name: +FRA/orcldb/archivelog/2015_01_29/thread_2_seq_331.264.870228303 RMAN> list backup of datafile 11; specification does not match any backup in the repository RMAN> list copy of datafile 11; specification does not match any datafile copy in the repository RMAN> run { 2> set until time "to_date('29-NOV-2014 19:09:17','DD-MON-RRRR HH24:MI:SS')"; 3> restore datafile 11; 4> } executing command: SET until clause Starting restore at 31-JAN-2015 04:42:12 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=10 instance=orcldb2 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 01/31/2015 04:42:12 RMAN-20201: datafile not found in the recovery catalog RMAN-06010: error while looking up datafile: 11 RMAN> spool log off;
Analysis
1/ The datafile# 11 was created on ’04-DEC-2014 09:16:22′.
2/ That explains why datafile# 11 has no backup taken before ’04-DEC-2014 09:16:22′.
3/ By the way, how far do you want to recover the database? Please provide the exact date and time that you want to recover the database.
Action-2
Let say we need to recover database till 27Nov 14.
As mentioned, the 10 datafiles have CHECKPOINT_TIME='29-NOV-2014 19:09:17', and the datafile# 11, '+DATA/orcldb/datafile/TBSORCL21.268.865415781' has CHECKPOINT_TIME='04-DEC-2014 09:16:22'. However, you want to recover the database to November 27th. I suggest to perform the following: 1/ First, make a copy of the current controlfile. RMAN> backup current controlfile format '/tmp/controlfile.rmanbkup'; 2/ Next, shutdown the database. SQL> shutdown immediate; 3/ Startup nomount. SQL> startup nomount; 4/ Restore the controlfile. RMAN> restore controlfile from '/u01/app/oracle/product/11.2.0/db_1/dbs/c-489766533-20141127-00'; 5/ Mount the database; RMAN> sql "alter database mount"; 6/ Catalog the RMAN backuppieces. RMAN> catalog start with '/backup/rmanbackup/'; 7/ Restore the database. RMAN> restore database; 8/ Recover the database. run { set until time "to_date('27-NOV-2014 02:15:37','DD-MON-RRRR HH24:MI:SS')"; recover database; } 9/ After the recovery is completed, run the following SQL statement to verify the status and checkpoint of the datafiles. If the query return 1 row with STATUS='ONLINE', FUZZY='NO' and CHECKPOINT_CHANGE#/TIME, the proceed to open the database. select error, fuzzy, status, checkpoint_change#, to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time, count(*) from v$datafile_header group by error, fuzzy, status, checkpoint_change#, checkpoint_time order by checkpoint_change#, checkpoint_time; 10/ Open the database. RMAN> alter database open resetlogs;
I am getting error in fourth point. find below log.. RMAN> restore controlfile from '/u01/app/oracle/product/11.2.0/db_1/dbs/c-489766533-20141127-00'; Starting restore at 31-JAN-15 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 01/31/2015 05:26:13 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece RMAN> exit "c-489766533-20141127-00" file is not available at mentioned location..
Find all files from "'/u01/app/oracle/product/11.2.0/db_1/dbs" location. -bash-3.2$ ll total 36496 -rw-r----- 1 oracle oinstall 18808832 Jan 31 01:55 c-489766533-20141204-00 -rw-rw---- 1 oracle oinstall 1544 Jan 31 05:25 hc_orcldb2.dat -rw-r----- 1 oracle oinstall 1660 Jan 30 18:34 initorcldb2.ora -rw-r--r-- 1 oracle oinstall 2851 Jul 27 2013 init.ora -rw-r----- 1 oracle oinstall 1536 Jul 27 2013 orapworcldb2 -rw-r----- 1 oracle oinstall 18497536 Jul 29 2013 snapcf_orcldb2.f -bash-3.2$
Recommendation-2
1/ Before you do any RMAN restore, please run the following OS commands, as shown here. If the required RMAN backuppieces containing the datafiles are not in the directory '/backup/rmanbackup/', then proceed to the next step, which is to restore the datafiles. uname -a id env | grep ORACLE ps -ef | grep smon ls -l /backup/rmanbackup/ 2/ I suggest to perform the following: a. First, make sure the database is already mounted. b. Offline the datafile# 11. SQL> alter database datafile 11 offline drop; c. Restore the database. spool log to rman_db_restore01.log set echo on run { set until time "to_date('27-NOV-2014 02:15:37','DD-MON-RRRR HH24:MI:SS')"; restore database; } spool log off Important Note: Before running the RMAN commands posted above, please issue the following OS command to set the NLS_DATE_FORMAT, as shown below. This will allow to display the date, as well as, the time information, which will help us in our analysis. NLS_DATE_FORMAT="DD-MON-RRRR HH24:MI:SS" export NLS_DATE_FORMAT d. Recover the database. spool log to rman_db_recover01.log set echo on run { set until time "to_date('27-NOV-2014 02:15:37','DD-MON-RRRR HH24:MI:SS')"; recover database; } spool log off e. After the recovery is completed, run the following SQL statement to verify the status and checkpoint of the datafiles. If the query return 1 row with STATUS='ONLINE', FUZZY='NO' and CHECKPOINT_CHANGE#/TIME, the proceed to open the database. select error, fuzzy, status, checkpoint_change#, to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time, count(*) from v$datafile_header group by error, fuzzy, status, checkpoint_change#, checkpoint_time order by checkpoint_change#, checkpoint_time; f. Open the database. RMAN> alter database open resetlogs;
🙂
Efficient Database cloning with direct NFS and CloneDB
The price we pay for the speedup of the insert
The Great artical by uhesse
The outcome of NOLOGGING operations, should the affected datafiles get damaged before we manage to take a backup of them.
As you probably know, we are allowed to suppress the usual redo protocol generation for certain statements, especially for
CREATE TABLE AS SELECT, INSERT INTO … SELECT and CREATE INDEX. If we can take a backup of the related datafiles after these
operations, everything is ok. We simply saved time during the above mentioned operations. But what if the datafiles actually
get damaged?
Hands On
http://uhesse.com/2009/09/15/how-do-nologging-operations-affect-recovery/
Oracle Data Guard – OTN Thread
NOLOGGING tables and recovery of database (and standby)
Even if you have tables with NOLOGGING minimal logging with respect to table structure changes are recorded, so in the case
of recovery, you can recover the database with nologging tables from the last full backup but data changes after the full
backup can not be recovered on the nologging tables.
You should avoid this situation by saying
SQL> alter database force logging;
on the Primary – best before creation of the Standby. Else you will lose the objects created with nologging in case of a failover.
If nologging operations have been done on the Primary already, but no damage there yet – better recreate the Standby after force
logging on the Primary.
1. So basically, if we are using Dataguard, NOLOGGING is not a good idea.
exactly.
2. What actually happens there? does the standby is not maintained at all?
No. It is maintained.
3. only the NOLOGGING objects will be in a corrupt/unusable state?
Yes
4. Will the standby have the DDL changes on NOLOGGING objects?
yes
5. Is it possible to find out such corrupt objects (if we are switching to the standby)?
You use them and get error messages.
6. Also, even if we are FORCE LOGGING, if we truncate a table or partition, will we brake the standby?
no. the truncate is reproduced on the standby.
https://community.oracle.com/thread/2146256?start=0&tstart=0
How to Recover !!!!!
No way, still last valid datafile backup
http://docs.oracle.com/cd/E11882_01/server.112/e41134/scenarios.htm#i1015738
13.4 Recovering After the NOLOGGING Clause Is Specified
In some SQL statements, the user has the option of specifying the NOLOGGING clause, which indicates that the database operation is not logged in the online redo log file. Even though the user specifies the clause, a redo record is still written to the online redo log file. However, there is no data associated with this record. This can result in log application or data access errors at the standby site and manual recovery might be required to resume applying log files.
Note:
To avoid these problems, Oracle recommends that you always specify the FORCE LOGGING clause in the CREATE DATABASE or ALTER DATABASE statements. See the Oracle Database Administrator’s Guide.
13.4.1 Recovery Steps for Logical Standby Databases
For logical standby databases, when SQL Apply encounters a redo record for an operation performed on an interesting table with the NOLOGGING clause, it stops with the following error: ORA-16211 unsupported record found in the archived redo log.
To recover after the NOLOGGING clause is specified, re-create one or more tables from the primary database, as described in Section 10.5.5.
Note:
In general, use of the NOLOGGING clause is not recommended. Optionally, if you know in advance that operations using the NOLOGGING clause will be performed on certain tables in the primary database, you might want to prevent the application of SQL statements associated with these tables to the logical standby database by using the DBMS_LOGSTDBY.SKIP procedure.
13.4.2 Recovery Steps for Physical Standby Databases
When the archived redo log file is copied to the standby site and applied to the physical standby database, a portion of the datafile is unusable and is marked as being unrecoverable. When you either fail over to the physical standby database, or open the standby database for read-only access, and attempt to read the range of blocks that are marked as UNRECOVERABLE, you will see error messages similar to the following:
ORA-01578: ORACLE data block corrupted (file # 1, block # 2521)
ORA-01110: data file 1: ‘/oracle/dbs/stdby/tbs_1.dbf’
ORA-26040: Data block was loaded using the NOLOGGING option
To recover after the NOLOGGING clause is specified, you need to copy the datafile that contains the missing redo data from the primary site to the physical standby site. Perform the following steps:
Step 1 Determine which datafiles should be copied.
Follow these steps:
Query the primary database:
SQL> SELECT NAME, UNRECOVERABLE_CHANGE# FROM V$DATAFILE; NAME UNRECOVERABLE ----------------------------------------------------- ------------- /oracle/dbs/tbs_1.dbf 5216 /oracle/dbs/tbs_2.dbf 0 /oracle/dbs/tbs_3.dbf 0 /oracle/dbs/tbs_4.dbf 0 4 rows selected.
Query the standby database:
SQL> SELECT NAME, UNRECOVERABLE_CHANGE# FROM V$DATAFILE; NAME UNRECOVERABLE ----------------------------------------------------- ------------- /oracle/dbs/stdby/tbs_1.dbf 5186 /oracle/dbs/stdby/tbs_2.dbf 0 /oracle/dbs/stdby/tbs_3.dbf 0 /oracle/dbs/stdby/tbs_4.dbf 0 4 rows selected.
Compare the query results of the primary and standby databases.
Compare the value of the UNRECOVERABLE_CHANGE# column in both query results.
If the value of the UNRECOVERABLE_CHANGE# column in the primary database is greater than the same column in the standby database, then the datafile needs to be copied from the primary site to the standby site.
In this example, the value of the UNRECOVERABLE_CHANGE# in the primary database for the tbs_1.dbf datafile is greater, so you need
to copy the tbs_1.dbf datafile to the standby site.
Step 2 On the primary site, back up the datafile you need to copy to the standby site.
Issue the following SQL statements:
SQL> ALTER TABLESPACE system BEGIN BACKUP; SQL> EXIT; Copy the needed datafile to a local directory. SQL> ALTER TABLESPACE system END BACKUP;
Step 3 Copy the datafile to the standby database.
Copy the datafile that contains the missing redo data from the primary site to a location on the physical standby site where files related to recovery are stored.
Step 4 On the standby database, restart Redo Apply.
Issue the following SQL statement:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
You might get the following error messages (possibly in the alert log) when you try to restart Redo Apply:
ORA-00308: cannot open archived log ‘standby1’
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘/oracle/dbs/stdby/tbs_1.dbf’
If you get the ORA-00308 error and Redo Apply does not terminate automatically, you can cancel recovery by issuing the following SQL statement from another terminal window:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
These error messages are returned when one or more log files in the archive gap have not been successfully applied. If you receive these errors, manually resolve the gaps, and repeat Step 4. See Section 6.4.3.1 for information about manually resolving an archive gap.
13.4.3 Determining If a Backup Is Required After Unrecoverable Operations
If you performed unrecoverable operations on your primary database, determine if a new backup operation is required by following these steps:
Query the V$DATAFILE view on the primary database to determine the system change number (SCN) or the time at which the Oracle database generated the most recent invalidated redo data.
Issue the following SQL statement on the primary database to determine if you need to perform another backup:
SQL> SELECT UNRECOVERABLE_CHANGE#,TO_CHAR(UNRECOVERABLE_TIME, 'mm-dd-yyyy hh:mi:ss') FROM V$DATAFILE;
If the query in the previous step reports an unrecoverable time for a datafile that is more recent than the time when the datafile was last backed up, then make another backup of the datafile in question.
See Oracle Database Reference for more information about the V$DATAFILE view.
Ref
How to check Corruption in Database ?
The primary tool for checking for corruption in an Oracle database is DBVERIFY. It can be used to perform a physical data structure integrity check on data files whether the database is online or offline. The big benefit of this is that DBVERIFY can be used to check backup data files without adding load to the database server. You invoke DBVERIFY from the operating system command line like this:
$ dbv file=data01.dbf logfile=verify.log blocksize=8192 feedback=100
In this example data01.dbf is the data file to check, and the tablespace this file belongs to has a block size of 8192 bytes. The feedback parameter tells DBVERIFY to draw a period on the screen after every 100 pages (blocks) of the file are verified.
In the log file you’ll see output like this:
DBVERIFY – Verification starting : FILE = data01.dbf
DBVERIFY – Verification complete
Total Pages Examined : 640
Total Pages Processed (Data) : 631
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 9
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
The Total Pages Failing values show the number of blocks that failed either the data block or index block checking routine. The Total Pages Marked Corrupt figure shows the number of blocks for which the cache header is invalid, thereby making it impossible for DBVERIFY to identify the block type. And the Total Pages Influx is the number of blocks for which DBVERIFY could not get a consistent image. (This could happen if the database is open when DBVERIFY is run. DBVERIFY reads blocks multiple times to try to get a consistent image, but DBVERIFY cannot get a consistent image of pages that are in flux.)
If you want to verify only a portion of a data file, you can specify a starting and ending block when running DBVERIFY. If you want to verify the entire database, you can generate a short shell script to run DBVERIFY on every data file in the database. You can do this easily using SQL*Plus:
SQL> SPOOL dbv_on_all_files.sh
SQL> SELECT ‘dbv file=’ || file_name ||
2 ‘ logfile=file’ || ROWNUM ||
3 ‘.log blocksize=8192′
4 FROM dba_data_files;
SQL> SPOOL OFF
After running the shell script you can quickly scan all of the DBVERIFY log files with Unix commands like:
$ grep Failing file*.log
$ grep Corrupt file*.log
$ grep Influx file*.log
You can also use DBVERIFY to validate a single data or index segment. To do this you must be logged onto the database with SYSDBA privileges. During the verification the segment is locked; if the segment is an index then the parent table is also locked.
There are other ways to check for database corruption besides DBVERIFY. You can take a full database export, with the dump file optionally specified as a null device. This will read every row in every user table in the database, discovering any corrupted data blocks along the way. However, this technique does not access every index entry or the entire data dictionary.
If you want to check one table and all of its indexes, you can use the ANALYZE statement to read every row of the table, read every entry in each of the table’s indexes, and make sure the table and index data are consistent with each other:
SQL> ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE;
This will lock the table, preventing DML on the table, unless you specify the ONLINE keyword. Online validation reduces the amount of validation performed to allow for concurrency.
There are several ways to check for corruption in an Oracle database, but the DBVERIFY tool is the most versatile. DBVERIFY does not limit concurrency or DML while it is running, and it can be run against a database backup. Just remember that if DBVERIFY detects corruption in your database and you are planning to recover the corrupt file from a backup, you should perform a DBVERIFY validation on the backup file before beginning the recovery. This will tell you if the corruption exists in the backup also.
VLDB – Migration
migrating to new server – datapump export
Export/Import File Copy + Upgrade Script DB link + Direct Load Insert (Entire) DB link + Direct Load Insert (Delta) DataGuard + Upgrade Script DataGuard + Transportable Tablespace
Reduced Business Downtime
[Oracle-l] Database upgrade for big database
1. Create standby server for 10g on new server 2. Install Oracle 11g with all required Paches 3. stop the primary and activate the Standby server 4. Upgrade the Standby server with 11g Software already installed
This process will save in installing Oracle 11g and performing any datapump export/import and save big downtime to few hours
only while upgrading the environment.
datapump import (impdp) using NETWORK_LINK option
Flashback Database
Flashback Database: A Primer
Oracle 10g’s brilliant alternative to database point in time recovery is the the Flashback Database feature. With this feature in place you can do almost everything that you can with point in time recovery, without actually having to go through all the disruptions and hassle that a PITR necessarily entails.
How to enable Flashback in oracle database 11g
Note:
From 11GR2 we donot have to bounce the database to alter flashback.
controlfile autobackup in 11.2.0.1
rman target / RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default 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 PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 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/db_1/dbs/snapcf_orcl.f'; # default
sqlplus / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> ALTER TABLESPACE HR 2 ADD DATAFILE;
Tablespace altered.
-bash-3.2$ pwd /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2014_07_12 -bash-3.2$ ls -ltr total 56160 -rw-r----- 1 oracle oinstall 9568256 Jul 12 16:17 o1_mf_s_852740246_9w24l0hv_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 16:38 o1_mf_s_852741517_9w25ss1s_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 16:52 o1_mf_s_852742363_9w26n78n_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 18:09 o1_mf_s_852746957_9w2c3s9h_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 18:32 o1_mf_s_852748332_9w2dgoqq_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 18:56 o1_mf_s_852749758_9w2fv831_.bkp -bash-3.2$ -bash-3.2$ ls -ltr | wc -l 7
“Within few minutes…”
-bash-3.2$ ll total 65520 -rw-r----- 1 oracle oinstall 9568256 Jul 12 16:17 o1_mf_s_852740246_9w24l0hv_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 16:38 o1_mf_s_852741517_9w25ss1s_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 16:52 o1_mf_s_852742363_9w26n78n_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 18:09 o1_mf_s_852746957_9w2c3s9h_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 18:32 o1_mf_s_852748332_9w2dgoqq_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 18:56 o1_mf_s_852749758_9w2fv831_.bkp -rw-r----- 1 oracle oinstall 9568256 Jul 12 21:34 o1_mf_s_852759231_9w2q3bdk_.bkp -bash-3.2$ ls -ltr | wc -l 8
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsynta010.htm#RCMRF113
Starting with Oracle 11g Release 2, RMAN creates a single autobackup file encompassing all of the structural changes that have occurred within a few minutes of each other rather than creating a new backup of the controlfile on each structural change to the database.
In 10g, as well, when you add a datafile to a tablespace, CONTROLFILE AUTOBACKUP creates a backup of the controlfile automatically when you alter the database structure (e.g. adding new datafile(s)).
However, if you are creating a tablespace with 10 datafiles (eg. “CREATE TABLESPACE x datafile ..” and then followed by 9 “ALTER TABLESPACE x ADD DATAFILE …” commands), you would find 10 distinct backups of the controlfile being “autocreated”.
So the “improvement” in 11g is that Oracle will wait “a few minutes” to see if you have multiple changes to the database structure before deciding on a controlfile autobackup. That way, you will likely see only 1 controlfile autobackup after having added all 10 datafiles.