In SQLPLUS:
- Control Files:-
- show parameter control_files;
- Dump Location:-
- show parameter dump;
- select * from v$diag_info;
In RMAN:
- List Backups:-
- list backup of database summary;
- select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key;
- select file#, incremental_level, completion_time, blocks, datafile_blocks from v$backup_datafile where incremental_level > 0 and blocks / datafile_blocks > .5 order by completion_time;
- Verify Logical backup with Physical Backup:-
- crosscheck backup;
- Take Full Backup:-
- backup as backupset database plus archivelog;
- backup incremental level 0 cumulative database plus archivelog;
- backup incremental level 0 database plus archivelog;