Search This Blog

Total Pageviews

Monday 4 July 2011

Oracle 10g RMAN DURATION

RMAN duration



RMAN> BACKUP DURATION 1:00 TABLESPACE anuj;

RMAN > BACKUP DURATION 3:00 DATABASE PLUS ARCHIVELOGS;


DURATION hh:mm -> Specifies a maximum time for a backup command to run , if backup not
complete upto this time , then RMAN backup will stop



RMAN> backup device type disk format='/home/oracle/RMAN/reportA%U.bkp' as compressed backupset duration 1:00 minimize load database;



to check RMAN BACKUP

select message,time_remaining from v$session_longops where sid=XXX and sofar<>totalwork;



[PARTIAL][MINIMIZE (TIME|LOAD)] -> With disk backups, you can use MINIMIZE TIME run the backup at maximum speed (default)

MINIMIZE LOAD to slow the rate of backup to lessen the load on the system. With MINIMIZE LOAD the backup will take the full specified duration.

No comments:

Oracle DBA

anuj blog Archive