Databases Reference
In-Depth Information
Once you make the backup with OSB and RMAN, check the backup status by issuing the
list backup
command in
RMAN (we use bold text in the output of the
backup
command, to show details about the tape devices used in the backup):
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
221 Full 1.23G SBT_TAPE 00:04:28 09-NOV-12
BP Key: 232 Status: AVAILABLE Compressed: NO Tag: TAG20121109T112411
Handle: amnpsbar_1_1 Media: RMAN-DEFAULT-000001
List of Datafiles in backup set 221
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2558079 09-NOV-12 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 2443713 25-OCT-12 /u01/app/oracle/oradata/orcl/example01.dbf
3 Full 2558079 09-NOV-12 /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 Full 2558079 09-NOV-12 /u01/app/oracle/oradata/orcl/undotbs01.dbf
5 Full 2558079 09-NOV-12 /u01/app/oracle/oradata/orcl/cattbs_01.dbf
6 Full 2443701 25-OCT-12 /u01/app/oracle/oradata/orcl/users01.dbf
7 Full 2558079 09-NOV-12 /u01/app/oracle/oradata/orcl/virt_catalog_01.dbf
8 Full 2558079 09-NOV-12 /u01/app/oracle/oradata/orcl/test01_01.dbf
9 Full 2558079 09-NOV-12 /u01/app/oracle/oradata/orcl/test02_01.dbf
10 Full 2530714 27-OCT-12 /u01/app/oracle/oradata/orcl/demo01.dbf
222
Full 9.75M SBT_TAPE 00:00:28 09-NOV-12
BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20121109T112847
Handle: c-1316762630-20121109-00 Media: RMAN-DEFAULT-000001
Control File Included: Ckp SCN: 2558193 Ckp time: 09-NOV-12
RMAN>
To test OSB's integration with RMAN, let's now delete the backups you've made with OSB. The output of the
delete backup
command shows that RMAN is using OSB as it's supposed to.
RMAN> delete backup;
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=38 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=37 device type=DISK
...
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
232 221 1 1 AVAILABLE SBT_TAPE amnpsbar_1_1
233 222 1 1 AVAILABLE SBT_TAPE c-1316762630-20121109-00
Do you really want to delete the above objects (enter YES or NO)?
