Tag Archives: Rman List commands

List backup on RMAN prompt for particular time period in oracle

List RMAN backup command for particular time period

Checked list of archive backup between time range

RMAN> list backup of archivelog time between "to_date('20-MAR-2013 00:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('25-MAR-2013 00:00:00','DD-MON-YYYY HH24:MI:SS')";

Checked list of database backup

RMAN> LIST BACKUP OF DATABASE COMPLETED AFTER '(SYSDATE-2)';

Checked list of archivelog backup

RMAN>LIST BACKUP OF ARCHIVELOG  BETWEEN '20-MAR-2013' AND '25-MAR-2013';

List of backup of one datafile:

RMAN>LIST BACKUP OF DATAFILE 1 COMPLETED BETWEEN '06-OCT-2008' and '25-DEC-2008';

Other user full commands:

LIST BACKUP: list all backup sets, copies, and proxy copies of a database, tablespace, data file, archived redo log, control file, or server parameter file.

LIST COPY: list all the images copy of database files and archive log files

LIST archivelog: list all archive log files

List incarnation: list all incarnations of the database (incarnation is created when open database with resetlogs)

List script names: list the name of recovery catalog created.

List failure: it is part of data recovery advisory which list the failure present in database.

LIST BACKUP SUMMARY: provide one line summary for backup Status.

LIST BACKUP BY FILE: List backup of each datafile, archive, control file by file wise

Advertisements