List backup on rman prompt for particular time period in oracle

List RMAN backup command for particular time period

Checked list of archive backup on rman prompt

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-08' and '25-DEC-2008';


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s