How to Configure and use Flashback Database
Reply
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.
