Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Delete Archive LOg with RMAN
alireza.mmm
post Apr 16 2017, 09:53 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 16-April 17
Member No.: 51,910



i have oracle 11gR2 and i want to delete archive log from primary database when that archive log applied on standby server AND that archive log backed up 1 times.

i set this config "CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY in primary Rman
and run in primary rman this commad : "delete archivelog all backed up 1 times to disk;"

but delete all archive log !!!!!!! even archive log that not backed up...


please help me to create script delete archive log in primary server that exist backed up 1 times AND applied on standby
Go to the top of the page
 
+Quote Post
mkumar
post Apr 24 2017, 03:41 PM
Post #2


Newbie
*

Group: Members
Posts: 2
Joined: 24-April 17
Member No.: 51,928



QUOTE (alireza.mmm @ Apr 16 2017, 10:53 AM) *
i have oracle 11gR2 and i want to delete archive log from primary database when that archive log applied on standby server AND that archive log backed up 1 times.

i set this config "CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY in primary Rman
and run in primary rman this commad : "delete archivelog all backed up 1 times to disk;"

but delete all archive log !!!!!!! even archive log that not backed up...


please help me to create script delete archive log in primary server that exist backed up 1 times AND applied on standby




CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;

run {
crosscheck archivelog all;
backup as backupset archivelog all delete input;
}
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th April 2017 - 08:41 PM