This isn't the Oracle Suggested Backup script, but this is my RMAN script for a good, solid RMAN backup. It will need slight tweaking if you decide to use it.
backup check logical database;
sql 'alter system archive log current';
backup archivelog all delete all input;
allocate channel for maintenance device type disk;
RUN {
crosscheck backup of database;
crosscheck backup of controlfile;
crosscheck archivelog all;}
delete force noprompt expired backup of database;
delete force noprompt expired backup of controlfile;
delete force noprompt expired archivelog all;
delete force noprompt obsolete redundancy 5;
sql "ALTER DATABASE BACKUP CONTROLFILE TO TRACE";
sql "ALTER DATABASE BACKUP CONTROLFILE TO ''D:\FRA\SBY01\SBY01_CONTROLFILE_BACKUP.CTL'' REUSE";
sql "CREATE PFILE=''C:\oracle\product\10.2.0\db_1\admin\SBY01\pfile\INITSBY01.INI'' FROM SPFILE";
exit;
No comments:
Post a Comment