RMAN Hands On

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;

To delete all Archivelogs withou backing them up:
delete archivelog all;

To backup all archivelogs which are not already backed up atleast one time –And then perfome deletion
delete archivelog all backed up 1 times to device type disk;

To delete archivelog upto a time which are not already backed up.
If they are already backed up, RMAN will juste delete them. If they are not backed up atleast one time, then RMAN will back them up first before deleting
delete archivelog until time ‘2007-04-30:09:30:50’ backed up 1 times to device type disk;

To delete archivelog upto a time (without backing them up):
delete archivelog until time “to_date(‘OCT 31 2008 23:00:00′,’Mon DD YYYY HH24:MI:SS’)”;

To delete archivelog two days or older which are not already backed up.
[If they are already backed up, RMAN will juste delete them. If they are not backed up atleast one time, then RMAN will back them up first before deleting]
delete archivelog until time ‘sysdate-2’ backed up 1 times to device type disk;

To delete archivelogs “immediately” which are older than 2 days
delete force archivelog until time ‘sysdate-2’;

To delete all archivelogs that are not backed up atleast one time, and then delete them
backup archivelog all not backed up 1 times delete input;

#Monitor the RMAN Backup jobs

REM RMAN Progress
alter session set nls_date_format='dd/mm/yy hh24:mi:ss'
/
select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
sysdate + TIME_REMAINING/3600/24 end_at
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%'
/
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