?
Solved

need a script to delete the archive logs not required for gg

Posted on 2013-06-21
4
Medium Priority
?
355 Views
Last Modified: 2014-01-11
Hi all,

my oracle database version is 11.2.0.3 and ggs version is 11.2.1.0.5 .
we want to delete the archive logs which are not required by goldengate extract let me know if some one alreay worked on it.
0
Comment
Question by:ajaybelde
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
Franck Pachot earned 1500 total points
ID: 39268088
Hi,
RMAN is suppose to do it when you 'delete archivelog all';
Regards,
Franck.
0
 
LVL 16

Expert Comment

by:Swadhin Ray
ID: 39268919
0
 

Assisted Solution

by:ajaybelde
ajaybelde earned 0 total points
ID: 39760628
after registser the gg process. it auotmaticaly keeps the required archivelogs and delete rest all are not required when a run archive backup
0
 

Author Closing Comment

by:ajaybelde
ID: 39773129
this iwas helpful
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to recover a database from a user managed backup
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question