Home » Server Options » Data Guard » Deleting Logs in Standby (10.2.0.4.0)
Deleting Logs in Standby [message #490801] Thu, 27 January 2011 07:42 Go to next message
kartheedba
Messages: 4
Registered: September 2010
Junior Member
Hi All,

I've a primary database and a physical standby.Logs are shipping perfectly from primary to standby.The logs that are applied on the standby are getting stored in a mount point(LINUX-/opt2) which consumes more space(160 GB). Will that be right if I go ahead and delete them?
My rman configurations in primary is:
RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 4;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle10g/product/10.2.0/dbs/snapcf_rtc.f'; # default.

Appreciate all suggestions.
Thanks and Regards
Karthik

Re: Deleting Logs in Standby [message #490808 is a reply to message #490801] Thu, 27 January 2011 08:39 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
you can delete the archives at physical standby,once they are applied successfully.
however,you should consider your backup/retention policy before deleting archives from primary/all locations.
Re: Deleting Logs in Standby [message #490901 is a reply to message #490808] Fri, 28 January 2011 02:13 Go to previous message
kartheedba
Messages: 4
Registered: September 2010
Junior Member
Thank you so much knight
Previous Topic: Manual standby Oracle 11.1 standard edition : cannot register logfile
Next Topic: Parameter db_file_name_convert
Goto Forum:
  


Current Time: Tue Aug 11 17:49:27 CDT 2020