|
-
 Originally Posted by prodadmin
btw delete noprompt backup of database completed before 'sysdate-1' is not deleting backups on standby.
Thanks
You are running this command while connected to the standby database i assume
BTW a better comman would be something like
DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO SBT COMPLETED BEFORE ‘SYSDATE-7
You will be deleting those backups of archivelogs that have been already backed up.You are absolutely sure you have backups of archivelogs
You might also be interested in setting the following config on standby database
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE
This will enable automatic deletion of archived logs
on the standby database
(where backups are being taken)
that are outside of the retention period
or have already been backed up to tape,
if additional space is needed for new backups or archived logs
regards
Hrishy
Last edited by hrishy; 11-20-2008 at 05:24 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|