Oracle RMAN备份深入解析--联机备份
RMAN> list backup of database;List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Full 1.13G DISK 00:01:21 03-JUL-14
BP Key: 17 Status: AVAILABLECompressed: NOTag: TAG20140703T171545
Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1
List of Datafiles in backup set 17
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/system01.dbf
2 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/sysaux01.dbf
3 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs1.dbf
4 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/users01.dbf
5 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/example01.dbf
6 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/tbs1.dbf
7 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs2.dbf
8 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/perftbs01.dbf
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
16 31.11M DISK 00:00:01 03-JUL-14
BP Key: 16 Status: AVAILABLECompressed: NOTag: TAG20140703T171541
Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0kpcfu5t_1_1
List of Archived Logs in backup set 16
Thrd Seq Low SCN Low TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 13 2051289 03-JUL-14 2066660 03-JUL-14
1 14 2066660 03-JUL-14 2066663 03-JUL-14
1 15 2066663 03-JUL-14 2066666 03-JUL-14
1 16 2066666 03-JUL-14 2066878 03-JUL-14
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18 104.00K DISK 00:00:00 03-JUL-14
BP Key: 18 Status: AVAILABLECompressed: NOTag: TAG20140703T171712
Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0mpcfu8o_1_1
List of Archived Logs in backup set 18
Thrd Seq Low SCN Low TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 17 2066878 03-JUL-14 2066956 03-JUL-14
页:
[1]