Reply from rjngh2005 on Dec 29 at 12:33 PM The commands I gave you are commands to be issued at the rman prompt.
However if you need more details you will have to query the rman catalog
database.
You will have to connect to the rman catalog database with SQL*Plus and the
userid which you normally connect
and write custom queries
for example...
you could query the rc_backup_set view
desc rc_backup_set;
Name Null? Type
---
DB_KEY NOT NULL NUMBER
DB_ID NOT NULL NUMBER
BS_KEY NOT NULL NUMBER
RECID NUMBER
STAMP NUMBER
SET_STAMP NOT NULL NUMBER
SET_COUNT NOT NULL NUMBER
BACKUP_TYPE VARCHAR2(1)
INCREMENTAL_LEVEL NUMBER
PIECES NOT NULL NUMBER
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
STATUS VARCHAR2(1)
CONTROLFILE_INCLUDED VARCHAR2(7)
INPUT_FILE_SCAN_ONLY VARCHAR2(3)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
| | | ---------------Original Message---------------
From: rjngh2005
Sent: Thursday, December 29, 2011 11:13 AM
Subject: Oracle RMAN Backup Details from RMAN Catalog Database
The RMAN catalog does not have the capability to list the level of backup.
If you are only using level 0 -- this is not an issue I guess.
To list the backups you can use the following commands:
list backup of database summary completed after 'sysdate -15';
list backup of database summary completed between 'sysdate-15' and
'sysdate-10';
remove the word summary in case you want detailed listing of the above
backups.
Do you need more info, or does this help? |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment