| Deleting Logs in Standby [message #490801] |
Thu, 27 January 2011 07:42  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
