How to delete RMAN backup and set configuration parameter in oracle 8.1.7.4 [message #221150] |
Sat, 24 February 2007 08:11 |
rtjk
Messages: 33 Registered: February 2005
|
Member |
|
|
Hai All,
I want to delete the RMAN backup using script.Oracle Version is 8.1.7.4. Solaris 5.8 Os.DB Backup is using RMAN.Bkup policy is as follows.(thru cron)
Incremental level 1 backup on mon-saturday
Incremental level 0 on sunday.
Backup information is stored in catalog schema which is in target database(Same DB).
Now my doubt is how to set configuration parameter in 8.1.7.4
If I give the command as "show all" it is throwing the RMAN-00569: = ERROR MESSAGE STACK FOLLOWS == line.
I can able to delete the backup using change backuppiece <piecenumber> delete by allocating a maintenance channel;
But I want to delete the backup using script.
Any command is available to delete .
I tried this script , but no luck.
connect catalog $RMAN/$RMANPWD
connect target
allocate channel for maintenance type disk;
run
{
delete noprompt backup of database completed before 'sysdate-7';
release channel;
}
Can any body help me in this please
Thanks in advance
Jay
|
|
|
|
|