Useful RMAN Commands

Posted: April 18, 2012 in RMAN

Show all of the RMAN parameters for the database

RMAN> show all;

Configure the disk channel to the format /backup/ora_df%t_s%s_s%p’

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/backup/ora_df%t_s%s_s%p’;

Configure the disk channel to the format +FLASHDG

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘+FLASHDG’;

Backup the database using the standard RMAN parameters

RMAN> backup database;

List all of the current backups for the database

RMAN> list backup;

 

List Backup summary

RMAN> list summary;

 

Crosscheck backups to see if they still exist

RMAN> crosscheck backup;

 

Crosscheck archive logs to see if they still exist

RMAN> crosscheck archivelog all;

 

Remove any expired backup

RMAN> delete expired backup;

Remove any expired archivelos

RMAN> delete expired archivelog;

Backup the database and archivelogs using the standard RMAN parameters and delete the archivelogs after the backup

RMAN> backup archivelog all delete input;

And

RMAN> run

2> {

3> backup database;

4> backup  archivelog all delete input;

5> }

Report of files that need backup due to unrecoverable operations

RMAN> report unrecoverable;

Report the obsolete backups and archivelogs

RMAN> report obsolete;

 

Delete the obsolete backups and archivelogs

RMAN> delete obsolete;

 

List all of the archivelogs

RMAN> list archivelog all;

Delete a specifed backupset

RMAN> delete backupset 1344

Sample backup command

RMAN> run

2> {

3> backup database;

4> sql “alter system switch logfile”;

5> backup archivelog all delete input;

6> sql “alter database backup controlfile to trace”;

7> }

Backup archive logs from scn 680

RMAN> run

2> {

3> ALLOCATE CHANNEL d1 DEVICE TYPE disk

4> FORMAT = ‘/app/oracle/admin/TEST/backup/df_%d_%s_%p.bak’;

5> backup as compressed backupset archivelog from sequence 680;

6> }

Backup archive logs and delete them up to scn 679

RMAN> run

2> {

3> ALLOCATE CHANNEL d1 DEVICE TYPE disk

4> FORMAT = ‘/app/oracle/admin/TEST/backup/df_%d_%s_%p.bak’;

5> backup as compressed backupset archivelog high sequence 679 delete input;

6> }

 

Point in time recovery

RMAN> run{

2> set until time “to_date(’05/07/11 09:00:00′ , ‘dd/mm/yy hh24:mi:ss’)”;

3> restore database;

4> recover database;

5> alter database open resetlogs;}

Delete archive logs up to scn 650

RMAN> delete archivelog high sequence 650;

list archivelogs from yesterday.

RMAN> list archivelog time between “sysdate -1” and “sysdate”

Delete archivelogs backed up 1 time to disk

RMAN> delete archive log all backed up 1 times to disk;

Delete backups older than 7 days

RMAN> delete backup completed before ‘sysdate -7’;

Restore archivelog between to scn numbers

RMAN> restore archivelog scn between 547484587 and 547662805;

Check For Logical And Physical Block Corruption

RMAN> backup check logical validate database;

Comments
  1. satish says:

    good commands thanks

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s