Summary
As per http://dba-amsterdam.blogspot.nl/2015/03/RMAN-PITR-Background-Table-Recovery-12c.html I have this Oracle 12c new feature working with a tradition database.
However when I tried with my 12c Container Database, the first attempt failed with a fairly trival error: http://dba-amsterdam.blogspot.nl/2015/03/rman-06024-no-backup-of-control-file.html
More interestingly this 2nd attempt of recovering a table in a pluggable database (i.e. PDB3 below), failed in a far more elusive manner:
- I have backups from from around SCN 2792428 onwards
- RMAN is trying to recover pdb3 to SCN 2868390
- Unfortunately the PITR recovery script want to restore the parent container database (i.e. CDBORCL) to archived log sequence 70 / SCN 2664814
I haven't got a root cause for this issue/failure, it appears that we are trying to restore the container db to an earlier point i.e. before I had run my initial backup of CDB/PDB3. I imagine this relates to the rather minimal initial backups I took, for a real project I would be keeping multiple backups? Still if I was going to be using Containers and Pluggable databases for a real-world project, I would want to test my backup strategy and the point in time recovery extra carefully.
Details
Basically the setup was the same as before, i.e. I run an RMAN backup on the database, archivelog and controlfile i.e. around SCN 2792428 … so I should be able to restore to SCN after this. Please see Appendix B for the
Some time later (SCN 2868390) I add small table and add some data
SQL> create table dave.test_table(col1 varchar2(30));
Table created.
SQL> insert into dave.test_table values ('blah');
1 row created.
SQL> SELECT current_scn FROM V$DATABASE;
CURRENT_SCN
-----------
2868385
SQL> commit;
Commit complete.
SQL> SELECT current_scn FROM V$DATABASE;
CURRENT_SCN
-----------
2868390
SQL> insert into dave.test_table values ('blah2');
1 row created.
SQL> commit;
Commit complete.
I then ran from rman:
RECOVER TABLE dave.test_table OF PLUGGABLE DATABASE pdb3 until scn 2868390 AUXILIARY DESTINATION '/u01/aux' REMAP TABLE 'DAVE'.'TEST_TABLE':'TEST_TABLE_RECOVERED';
However as the logs (appendix A) this fails:
RMAN-06025: no backup of archived log for thread 1 with sequence 70 and starting SCN of 2664814 found to restore
although the backup details (see Appendix B - RMAN list backup details) below indicate that we have backups from around SCN 2792428 onwards i.e. comfortable before the PITR at SCN 2868390?
Appendix A ... full rman log, including
RMAN> RECOVER TABLE dave.test_table OF PLUGGABLE DATABASE pdb3 until scn 2868390 AUXILIARY DESTINATION '/u01/aux' REMAP TABLE 'DAVE'.'TEST_TABLE':'TEST_TABLE_RECOVERED';
Starting recover at 16-MAR-15
current log archived
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Creating automatic instance, with SID='guej'
initialization parameters used for automatic instance:
db_name=CDBORCL
db_unique_name=guej_pitr_pdb3_CDBORCL
compatible=12.1.0.0.0
db_block_size=8192
db_files=200
sga_target=1G
processes=80
diagnostic_dest=/u01
db_create_file_dest=/u01/aux
log_archive_dest_1='location=/u01/aux'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDBORCL
Oracle instance started
Total System Global Area 1068937216 bytes
Fixed Size 2296576 bytes
Variable Size 281019648 bytes
Database Buffers 780140544 bytes
Redo Buffers 5480448 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until scn 2868390;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET until clause
Starting restore at 16-MAR-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=7 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874530648_bjgkps2b_.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874530648_bjgkps2b_.bkp tag=TAG20150316T211048
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/aux/CDBORCL/controlfile/o1_mf_bjgkywvd_.ctl
Finished restore at 16-MAR-15
sql statement: alter database mount clone database
sql statement: alter system archive log current
contents of Memory Script:
{
# set requested point in time
set until scn 2868390;
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile 1 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
set newname for clone tempfile 1 to new;
set newname for clone tempfile 5 to new;
# switch all tempfiles
switch clone tempfile all;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile 1, 4, 3, 14, 15;
switch clone datafile all;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u01/aux/CDBORCL/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 5 to /u01/aux/CDBORCL/datafile/o1_mf_temp_%u_.tmp in control file
Starting restore at 16-MAR-15
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/aux/CDBORCL/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/aux/CDBORCL/datafile/o1_mf_undotbs1_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/aux/CDBORCL/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkmzch_.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkmzch_.bkp tag=TAG20150316T210919
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00014 to /u01/aux/CDBORCL/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00015 to /u01/aux/CDBORCL/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgknrqc_.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgknrqc_.bkp tag=TAG20150316T210919
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 16-MAR-15
datafile 1 switched to datafile copy
input datafile copy RECID=12 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_system_bjgkz52x_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=13 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_undotbs1_bjgkz536_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=14 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgkz528_.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=15 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_system_bjgl085n_.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=16 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgl0864_.dbf
contents of Memory Script:
{
# set requested point in time
set until scn 2868390;
# online the datafiles restored or switched
sql clone "alter database datafile 1 online";
sql clone "alter database datafile 4 online";
sql clone "alter database datafile 3 online";
sql clone 'PDB3' "alter database datafile
14 online";
sql clone 'PDB3' "alter database datafile
15 online";
# recover and open database read only
recover clone database tablespace "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB3":"SYSTEM", "PDB3":"SYSAUX";
sql clone 'alter database open read only';
}
executing Memory Script
executing command: SET until clause
sql statement: alter database datafile 1 online
sql statement: alter database datafile 4 online
sql statement: alter database datafile 3 online
sql statement: alter database datafile 14 online
sql statement: alter database datafile 15 online
Starting recover at 16-MAR-15
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 84 is already on disk as file /u01/fast_recovery_area/CDBORCL/archivelog/2015_03_16/o1_mf_1_84_bjgkpqd3_.arc
archived log for thread 1 with sequence 85 is already on disk as file /u01/fast_recovery_area/CDBORCL/archivelog/2015_03_16/o1_mf_1_85_bjgky8hw_.arc
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgl0864_.dbf deleted
auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_system_bjgl085n_.dbf deleted
auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgkz528_.dbf deleted
auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_undotbs1_bjgkz536_.dbf deleted
auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_system_bjgkz52x_.dbf deleted
auxiliary instance file /u01/aux/CDBORCL/controlfile/o1_mf_bjgkywvd_.ctl deleted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/16/2015 21:16:18
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 70 and starting SCN of 2664814 found to restore
Appendix B - RMAN list backup details
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5 36.34M DISK 00:00:00 15-MAR-15
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142321
Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_annnn_TAG20150315T142321_bjc5gs94_.bkp
List of Archived Logs in backup set 5
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 78 2781205 15-MAR-15 2792295 15-MAR-15
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 56.00K DISK 00:00:00 15-MAR-15
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142511
Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_annnn_TAG20150315T142511_bjc5l7m4_.bkp
List of Archived Logs in backup set 6
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 79 2792295 15-MAR-15 2792422 15-MAR-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 1.33G DISK 00:00:18 15-MAR-15
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142512
Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5l8wf_.bkp
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2792428 15-MAR-15 /u01/oradata/cdborcl/system01.dbf
3 Full 2792428 15-MAR-15 /u01/oradata/cdborcl/sysaux01.dbf
4 Full 2792428 15-MAR-15 /u01/oradata/cdborcl/undotbs01.dbf
6 Full 2792428 15-MAR-15 /u01/oradata/cdborcl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 1.24G DISK 00:00:16 15-MAR-15
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142512
Piece Name: /u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5m29v_.bkp
List of Datafiles in backup set 8
Container ID: 5, PDB Name: PDB3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
14 Full 2792437 15-MAR-15 /u01/oradata/cdborcl/pdb3/system01.dbf
15 Full 2792437 15-MAR-15 /u01/oradata/cdborcl/pdb3/sysaux01.dbf
16 Full 2792437 15-MAR-15 /u01/oradata/cdborcl/pdb3/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9 Full 752.21M DISK 00:00:08 15-MAR-15
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142512
Piece Name: /u01/fast_recovery_area/CDBORCL/115447DBB3BA056DE0530100007FB780/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5mwf4_.bkp
List of Datafiles in backup set 9
Container ID: 6, PDB Name: PDB4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
20 Full 2792447 15-MAR-15 /u01/oradata/cdborcl/pdb4/system01.dbf
21 Full 2792447 15-MAR-15 /u01/oradata/cdborcl/pdb4/sysaux01.dbf
22 Full 2792447 15-MAR-15 /u01/oradata/cdborcl/pdb4/pdb4_users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 751.98M DISK 00:00:10 15-MAR-15
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142512
Piece Name: /u01/fast_recovery_area/CDBORCL/113065F11B2B3357E0530100007F557D/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5ncpk_.bkp
List of Datafiles in backup set 10
Container ID: 4, PDB Name: PDB2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
12 Full 2792453 15-MAR-15 /u01/oradata/cdborcl/pdb2/system01.dbf
13 Full 2792453 15-MAR-15 /u01/oradata/cdborcl/pdb2/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Full 741.55M DISK 00:00:08 15-MAR-15
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142512
Piece Name: /u01/fast_recovery_area/CDBORCL/11043883E1AC1CBAE0530100007F7552/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5nvtr_.bkp
List of Datafiles in backup set 11
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1929877 11-MAR-15 /u01/oradata/cdborcl/pdbseed/system01.dbf
7 Full 1929877 11-MAR-15 /u01/oradata/cdborcl/pdbseed/sysaux01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12 4.50K DISK 00:00:00 15-MAR-15
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142651
Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_annnn_TAG20150315T142651_bjc5ocm4_.bkp
List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 80 2792422 15-MAR-15 2792468 15-MAR-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13 Full 17.20M DISK 00:00:01 15-MAR-15
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20150315T142652
Piece Name: /u01/fast_recovery_area/CDBORCL/autobackup/2015_03_15/o1_mf_s_874420012_bjc5of16_.bkp
SPFILE Included: Modification time: 15-MAR-15
SPFILE db_unique_name: CDBORCL
Control File Included: Ckp SCN: 2792477 Ckp time: 15-MAR-15
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14 110.55M DISK 00:00:00 16-MAR-15
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20150316T210917
Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_annnn_TAG20150316T210917_bjgkmy4d_.bkp
List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 79 2792295 15-MAR-15 2792422 15-MAR-15
1 80 2792422 15-MAR-15 2792468 15-MAR-15
1 81 2792468 15-MAR-15 2823573 16-MAR-15
1 82 2823573 16-MAR-15 2849663 16-MAR-15
1 83 2849663 16-MAR-15 2868230 16-MAR-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15 Full 1.36G DISK 00:00:18 16-MAR-15
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20150316T210919
Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkmzch_.bkp
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2868236 16-MAR-15 /u01/oradata/cdborcl/system01.dbf
3 Full 2868236 16-MAR-15 /u01/oradata/cdborcl/sysaux01.dbf
4 Full 2868236 16-MAR-15 /u01/oradata/cdborcl/undotbs01.dbf
6 Full 2868236 16-MAR-15 /u01/oradata/cdborcl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16 Full 1.24G DISK 00:00:16 16-MAR-15
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20150316T210919
Piece Name: /u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgknrqc_.bkp
List of Datafiles in backup set 16
Container ID: 5, PDB Name: PDB3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
14 Full 2868247 16-MAR-15 /u01/oradata/cdborcl/pdb3/system01.dbf
15 Full 2868247 16-MAR-15 /u01/oradata/cdborcl/pdb3/sysaux01.dbf
16 Full 2868247 16-MAR-15 /u01/oradata/cdborcl/pdb3/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Full 752.29M DISK 00:00:07 16-MAR-15
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20150316T210919
Piece Name: /u01/fast_recovery_area/CDBORCL/115447DBB3BA056DE0530100007FB780/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkoky1_.bkp
List of Datafiles in backup set 17
Container ID: 6, PDB Name: PDB4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
20 Full 2868280 16-MAR-15 /u01/oradata/cdborcl/pdb4/system01.dbf
21 Full 2868280 16-MAR-15 /u01/oradata/cdborcl/pdb4/sysaux01.dbf
22 Full 2868280 16-MAR-15 /u01/oradata/cdborcl/pdb4/pdb4_users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Full 752.02M DISK 00:00:07 16-MAR-15
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20150316T210919
Piece Name: /u01/fast_recovery_area/CDBORCL/113065F11B2B3357E0530100007F557D/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkos17_.bkp
List of Datafiles in backup set 18
Container ID: 4, PDB Name: PDB2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
12 Full 2868283 16-MAR-15 /u01/oradata/cdborcl/pdb2/system01.dbf
13 Full 2868283 16-MAR-15 /u01/oradata/cdborcl/pdb2/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19 Full 741.55M DISK 00:00:08 16-MAR-15
BP Key: 20 Status: AVAILABLE Compressed: NO Tag: TAG20150316T210919
Piece Name: /u01/fast_recovery_area/CDBORCL/11043883E1AC1CBAE0530100007F7552/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkp877_.bkp
List of Datafiles in backup set 19
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1929877 11-MAR-15 /u01/oradata/cdborcl/pdbseed/system01.dbf
7 Full 1929877 11-MAR-15 /u01/oradata/cdborcl/pdbseed/sysaux01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
20 36.50K DISK 00:00:00 16-MAR-15
BP Key: 21 Status: AVAILABLE Compressed: NO Tag: TAG20150316T211047
Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_annnn_TAG20150316T211047_bjgkpqml_.bkp
List of Archived Logs in backup set 20
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 84 2868230 16-MAR-15 2868300 16-MAR-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21 Full 17.20M DISK 00:00:01 16-MAR-15
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20150316T211048
Piece Name: /u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874530648_bjgkps2b_.bkp
SPFILE Included: Modification time: 16-MAR-15
SPFILE db_unique_name: CDBORCL
Control File Included: Ckp SCN: 2868309 Ckp time: 16-MAR-15
RMAN> backup archivelog all;
Starting backup at 16-MAR-15
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=79 RECID=8 STAMP=874419911
input archived log thread=1 sequence=80 RECID=9 STAMP=874420011
input archived log thread=1 sequence=81 RECID=10 STAMP=874461302
input archived log thread=1 sequence=82 RECID=11 STAMP=874501239
input archived log thread=1 sequence=83 RECID=12 STAMP=874530557
input archived log thread=1 sequence=84 RECID=13 STAMP=874530647
input archived log thread=1 sequence=85 RECID=14 STAMP=874530888
input archived log thread=1 sequence=86 RECID=15 STAMP=874530916
input archived log thread=1 sequence=87 RECID=16 STAMP=874531090
channel ORA_DISK_1: starting piece 1 at 16-MAR-15
channel ORA_DISK_1: finished piece 1 at 16-MAR-15
piece handle=/u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_annnn_TAG20150316T211810_bjgl4lcg_.bkp tag=TAG20150316T211810 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 16-MAR-15
Starting Control File and SPFILE Autobackup at 16-MAR-15
piece handle=/u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874531093_bjgl4oly_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 16-MAR-15
RMAN> Connection to 127.0.0.1 closed by remote host.
Connection to 127.0.0.1 closed.
No comments:
Post a Comment