Database Reference
In-Depth Information
You could also list a specific restore point, as in this example:
RMAN> list restore point robert;
SCN RSP Time Type Time Name
---------------- --------- ---------- --------- ----
1219891 18-OCT-13 ROBERT
RMAN> list restore point davep;
SCN RSP Time Type Time Name
---------------- --------- ---------- --------- ----
Seeing the LIST ALL SCRIPT NAMES Command in Action
The LIST ALL SCRIPT NAMES command generates a report with the names of all scripts in
the recovery catalog. This command is available for use only when you are connected to the
recovery catalog. Here is an example of the LIST ALL SCRIPT NAMES command where you
find one script in the recovery catalog called db_backup_script :
RMAN> list all script names;
List of Stored Scripts in Recovery Catalog
Scripts of Target Database ORCL
Script Name
Description
-----------------------------------
db_backup_script
Examples of Listing Backup-Related Information
DBAs will, from time to time, want to know what backups have been made on their database.
The LIST command provides all sorts of information on database backups. For example, if
you want to see what full backups of your database are available, then you can run the LIST
BACKUP OF DATABASE command:
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 176.72M DISK 00:06:02 11-OCT-13
BP Key: 2 Status: EXPIRED Compressed: YES Tag: TAG20131011T142622
Piece Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_11\
O1_MF_NNNDF_TAG20131011T142622_4H22ZOMK_.BKP
List of Datafiles in backup set 2
Search WWH ::




Custom Search