|
isk2
RMAN> list backup of spfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 9.36M DISK 00:00:04 19-FEB-15
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20150219T011148
Piece Name: /u02/09pvkh4o_1_1
SPFILE Included: Modification time: 19-FEB-15
SPFILE db_unique_name: TEST
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 80.00K DISK 00:00:01 19-FEB-15
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20150219T024005
Piece Name: /u02/disk2/0epvkmak_1_1
SPFILE Included: Modification time: 19-FEB-15
SPFILE db_unique_name: TEST
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 9.36M DISK 00:00:04 19-FEB-15
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20150219T011148
Piece Name: /u02/09pvkh4o_1_1
Control File Included: Ckp SCN: 3198153 Ckp time: 19-FEB-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 9.33M DISK 00:00:06 19-FEB-15
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20150219T024005
Piece Name: /u02/disk2/0bpvkm86_1_1
Control File Included: Ckp SCN: 3201429 Ckp time: 19-FEB-15
RMAN>
RMAN> list backup of datafile 1;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 703.80M DISK 00:00:59 19-FEB-15
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 3198130 19-FEB-15 /u01/app/oracle/oradata/test/system01.dbf
Backup Set Copy #1 of backup set 1
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:59 19-FEB-15 NO TAG20150219T011148
List of Backup Pieces for backup set 1 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
1 1 AVAILABLE /u02/06pvkh2l_1_1
2 2 AVAILABLE /u02/06pvkh2l_2_1
3 3 AVAILABLE /u02/06pvkh2l_3_1
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 703.77M DISK 00:01:19 19-FEB-15
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 3201428 19-FEB-15 /u01/app/oracle/oradata/test/system01.dbf
Backup Set Copy #1 of backup set 4
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:19 19-FEB-15 NO TAG20150219T024005
List of Backup Pieces for backup set 4 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
6 1 AVAILABLE /u02/disk1/0apvkm85_1_1
7 2 AVAILABLE /u02/disk2/0apvkm85_2_1
8 3 AVAILABLE /u02/disk1/0apvkm85_3_1
RMAN>
|