Last active
December 17, 2015 05:49
-
-
Save akinsgre/5561254 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RMAN> run { | |
2> set until time "to_date('05/09/2013 06:10', 'MM/DD/YYYY HH:MI')"; | |
3> restore database; | |
4> recover database ; | |
5> } | |
executing command: SET until clause | |
Starting restore at 11-MAY-13 | |
using target database control file instead of recovery catalog | |
allocated channel: ORA_DISK_1 | |
channel ORA_DISK_1: SID=129 device type=DISK | |
RMAN-00571: =========================================================== | |
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== | |
RMAN-00571: =========================================================== | |
RMAN-03002: failure of restore command at 05/11/2013 15:21:22 | |
RMAN-06026: some targets not found - aborting restore | |
RMAN-06023: no backup or copy of datafile 19 found to restore | |
RMAN-06023: no backup or copy of datafile 18 found to restore | |
RMAN-06023: no backup or copy of datafile 17 found to restore | |
RMAN-06023: no backup or copy of datafile 16 found to restore | |
RMAN-06023: no backup or copy of datafile 15 found to restore | |
RMAN-06023: no backup or copy of datafile 14 found to restore | |
RMAN-06023: no backup or copy of datafile 13 found to restore | |
RMAN-06023: no backup or copy of datafile 12 found to restore | |
RMAN-06023: no backup or copy of datafile 11 found to restore | |
RMAN-06023: no backup or copy of datafile 10 found to restore | |
RMAN-06023: no backup or copy of datafile 9 found to restore | |
RMAN-06023: no backup or copy of datafile 8 found to restore | |
RMAN-06023: no backup or copy of datafile 7 found to restore | |
RMAN-06023: no backup or copy of datafile 6 found to restore | |
RMAN-06023: no backup or copy of datafile 5 found to restore | |
RMAN-06023: no backup or copy of datafile 4 found to restore | |
RMAN-06023: no backup or copy of datafile 3 found to restore | |
RMAN-06023: no backup or copy of datafile 2 found to restore | |
RMAN-06023: no backup or copy of datafile 1 found to restore |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RMAN> list backupset | |
2> ; | |
List of Backup Sets | |
=================== | |
BS Key Type LV Size | |
------- ---- -- ---------- | |
1022 Incr 1 126.23M | |
List of Datafiles in backup set 1022 | |
File LV Type Ckp SCN Ckp Time Name | |
---- -- ---- ---------- -------------------- ---- | |
1 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/system01.dbf | |
2 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/sysaux01.dbf | |
3 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/undotbs01.dbf | |
4 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/users01.dbf | |
5 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/DATA_1 | |
6 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/DATA_1.2 | |
7 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/DATA_1.3 | |
8 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/DATA_1.4 | |
9 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/INDEX_1 | |
10 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/INDEX_1.2 | |
11 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/INDEX_1.3 | |
12 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/INDEX_1.4 | |
13 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/INDEX_1.5 | |
14 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/DATA_2 | |
15 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/DATA_2.2 | |
16 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/PCS_1.DAT | |
17 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/PCS_1.2 | |
18 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/PCS_U1.DAT | |
19 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/INDEX2 | |
20 1 Incr 11377376 May 11 2013 02:00:31 /u01/app/oracle/oradata/pcs/rman_data_01.dbf | |
Backup Set Copy #1 of backup set 1022 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:01:17 May 11 2013 02:02:17 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1022 Copy #1 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1046 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rvqnwy7_.bkp | |
Backup Set Copy #2 of backup set 1022 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:01:17 May 11 2013 15:28:59 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1022 Copy #2 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1749 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx6ztkg_.bkp | |
Backup Set Copy #3 of backup set 1022 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:01:17 May 11 2013 15:31:33 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1022 Copy #3 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1905 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx74od9_.bkp | |
BS Key Type LV Size Device Type Elapsed Time Completion Time | |
------- ---- -- ---------- ----------- ------------ -------------------- | |
1023 Full 9.67M DISK 00:00:00 May 11 2013 02:02:26 | |
BP Key: 1047 Status: AVAILABLE Compressed: NO Tag: TAG20130511T020226 | |
Piece Name: /u01/app/oracle/flash_recovery_area/PCS/autobackup/2013_05_11/o1_mf_s_815104831_8rvqqlcp_.bkp | |
SPFILE Included: Modification time: May 11 2013 02:00:44 | |
SPFILE db_unique_name: PCS | |
Control File Included: Ckp SCN: 11377376 Ckp time: May 11 2013 02:00:31 | |
BS Key Type LV Size | |
------- ---- -- ---------- | |
1453 Incr 1 125.01M | |
List of Datafiles in backup set 1453 | |
File LV Type Ckp SCN Ckp Time Name | |
---- -- ---- ---------- -------------------- ---- | |
1 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/system01.dbf | |
2 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/sysaux01.dbf | |
3 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/undotbs01.dbf | |
4 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/users01.dbf | |
5 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1 | |
6 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1.2 | |
7 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1.3 | |
8 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1.4 | |
9 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1 | |
10 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.2 | |
11 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.3 | |
12 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.4 | |
13 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.5 | |
14 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_2 | |
15 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_2.2 | |
16 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/PCS_1.DAT | |
17 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/PCS_1.2 | |
18 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/PCS_U1.DAT | |
19 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX2 | |
20 1 Incr 11085661 May 09 2013 02:00:33 /u01/app/oracle/oradata/pcs/rman_data_01.dbf | |
Backup Set Copy #1 of backup set 1453 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 14:03:34 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1453 Copy #1 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1497 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_09/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rpgwl68_.bkp | |
Backup Set Copy #2 of backup set 1453 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:29:00 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1453 Copy #2 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1750 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx6zvng_.bkp | |
Backup Set Copy #3 of backup set 1453 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:31:34 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1453 Copy #3 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1906 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx74pgz_.bkp | |
BS Key Type LV Size | |
------- ---- -- ---------- | |
1454 Incr 1 124.16M | |
List of Datafiles in backup set 1454 | |
File LV Type Ckp SCN Ckp Time Name | |
---- -- ---- ---------- -------------------- ---- | |
1 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/system01.dbf | |
2 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/sysaux01.dbf | |
3 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/undotbs01.dbf | |
4 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/users01.dbf | |
5 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/DATA_1 | |
6 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/DATA_1.2 | |
7 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/DATA_1.3 | |
8 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/DATA_1.4 | |
9 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/INDEX_1 | |
10 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/INDEX_1.2 | |
11 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/INDEX_1.3 | |
12 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/INDEX_1.4 | |
13 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/INDEX_1.5 | |
14 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/DATA_2 | |
15 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/DATA_2.2 | |
16 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/PCS_1.DAT | |
17 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/PCS_1.2 | |
18 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/PCS_U1.DAT | |
19 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/INDEX2 | |
20 1 Incr 11224414 May 10 2013 02:00:36 /u01/app/oracle/oradata/pcs/rman_data_01.dbf | |
Backup Set Copy #1 of backup set 1454 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 14:03:36 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1454 Copy #1 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1498 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_10/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rs38obj_.bkp | |
Backup Set Copy #2 of backup set 1454 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:29:01 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1454 Copy #2 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1751 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx6zwot_.bkp | |
Backup Set Copy #3 of backup set 1454 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:31:35 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1454 Copy #3 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1907 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx74qjf_.bkp | |
BS Key Type LV Size | |
------- ---- -- ---------- | |
1560 Incr 1 121.25M | |
List of Datafiles in backup set 1560 | |
File LV Type Ckp SCN Ckp Time Name | |
---- -- ---- ---------- -------------------- ---- | |
1 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/system01.dbf | |
2 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/sysaux01.dbf | |
3 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/undotbs01.dbf | |
4 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/users01.dbf | |
5 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/DATA_1 | |
6 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/DATA_1.2 | |
7 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/DATA_1.3 | |
8 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/DATA_1.4 | |
9 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/INDEX_1 | |
10 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/INDEX_1.2 | |
11 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/INDEX_1.3 | |
12 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/INDEX_1.4 | |
13 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/INDEX_1.5 | |
14 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/DATA_2 | |
15 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/DATA_2.2 | |
16 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/PCS_1.DAT | |
17 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/PCS_1.2 | |
18 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/PCS_U1.DAT | |
19 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/INDEX2 | |
20 1 Incr 10787691 May 07 2013 02:00:38 /u01/app/oracle/oradata/pcs/rman_data_01.dbf | |
Backup Set Copy #1 of backup set 1560 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:10:00 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1560 Copy #1 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1622 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_07/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rk64q5g_.bkp | |
Backup Set Copy #2 of backup set 1560 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:29:02 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1560 Copy #2 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1752 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx6zxq4_.bkp | |
Backup Set Copy #3 of backup set 1560 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:31:36 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1560 Copy #3 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1908 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx74rks_.bkp | |
BS Key Type LV Size | |
------- ---- -- ---------- | |
1561 Incr 1 127.57M | |
List of Datafiles in backup set 1561 | |
File LV Type Ckp SCN Ckp Time Name | |
---- -- ---- ---------- -------------------- ---- | |
1 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/system01.dbf | |
2 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/sysaux01.dbf | |
3 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/undotbs01.dbf | |
4 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/users01.dbf | |
5 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1 | |
6 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1.2 | |
7 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1.3 | |
8 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_1.4 | |
9 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1 | |
10 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.2 | |
11 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.3 | |
12 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.4 | |
13 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX_1.5 | |
14 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_2 | |
15 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/DATA_2.2 | |
16 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/PCS_1.DAT | |
17 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/PCS_1.2 | |
18 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/PCS_U1.DAT | |
19 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/INDEX2 | |
20 1 Incr 10944083 May 08 2013 02:00:33 /u01/app/oracle/oradata/pcs/rman_data_01.dbf | |
Backup Set Copy #1 of backup set 1561 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:10:02 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1561 Copy #1 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1623 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_08/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rmtjp6h_.bkp | |
Backup Set Copy #2 of backup set 1561 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:29:03 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1561 Copy #2 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1753 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx6zyrk_.bkp | |
Backup Set Copy #3 of backup set 1561 | |
Device Type Elapsed Time Completion Time Compressed Tag | |
----------- ------------ -------------------- ---------- --- | |
DISK 00:00:00 May 11 2013 15:31:37 NO ORA_OEM_LEVEL_0 | |
List of Backup Pieces for backup set 1561 Copy #3 | |
BP Key Pc# Status Piece Name | |
------- --- ----------- ---------- | |
1909 1 AVAILABLE /u01/app/oracle/flash_recovery_area/PCS/backupset/2013_05_11/o1_mf_nnnd1_ORA_OEM_LEVEL_0_8rx74sm7_.bkp | |
BS Key Type LV Size Device Type Elapsed Time Completion Time | |
------- ---- -- ---------- ----------- ------------ -------------------- | |
1760 Full 9.73M DISK 00:00:01 May 11 2013 15:29:05 | |
BP Key: 1781 Status: AVAILABLE Compressed: NO Tag: TAG20130511T152904 | |
Piece Name: /u01/app/oracle/flash_recovery_area/PCS/autobackup/2013_05_11/o1_mf_s_815153344_8rx700yc_.bkp | |
SPFILE Included: Modification time: May 11 2013 15:12:20 | |
SPFILE db_unique_name: PCS | |
Control File Included: Ckp SCN: 11545877 Ckp time: May 11 2013 15:29:04 | |
BS Key Type LV Size Device Type Elapsed Time Completion Time | |
------- ---- -- ---------- ----------- ------------ -------------------- | |
1918 Full 9.73M DISK 00:00:00 May 11 2013 15:31:39 | |
BP Key: 1939 Status: AVAILABLE Compressed: NO Tag: TAG20130511T153139 | |
Piece Name: /u01/app/oracle/flash_recovery_area/PCS/autobackup/2013_05_11/o1_mf_s_815153499_8rx74vdp_.bkp | |
SPFILE Included: Modification time: May 11 2013 15:12:20 | |
SPFILE db_unique_name: PCS | |
Control File Included: Ckp SCN: 11546234 Ckp time: May 11 2013 15:31:39 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment