Useful RMAN Commands

Few important RMAN Commands. Stay tuned, I am compiling a RMAN article for those who are NOT DBA, yet want to have proper backups for their databases.

Oracle DBA Zone

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 …

View original post 270 more words

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.