?
Solved

archive-destination

Posted on 2014-11-12
5
Medium Priority
?
146 Views
Last Modified: 2014-11-14
When we receive the following message is received: ORA-00257 archiver is stuck. Connect internal only, until freed.

We can  take backup of archivelogs and remove them .

How we will the backup of archive logs .
0
Comment
Question by:jeevan mathew
[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
  • 2
5 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40438287
To get the database back up and running:  Copy off some of the older ones to a different disk.  Back them up later.

>>We can  take backup of archivelogs and remove them .

Yes.  Removal of them after appropriate backups is common.

>>How we will the backup of archive logs

That depends on how you back up your database and what backup strategies you have in place.

You typically want individual files on multiple tapes in case one tape snaps.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40438495
The easiest way to remove them is if you use Oracle's RMAN utility to back up your database and your archived redo logs.  You can then configure RMAN to automatically remove the archived redo logs after they have been backed up once (or twice, or whatever number you are comfortable with).

If you use some other tool to backup your Oracle database and archived redo log files, you may be able to add a command in that tool (or in a script that calls that tool) to remove archived redo logs that are older than a certain time frame (like maybe a day or two or three).
0
 

Author Comment

by:jeevan mathew
ID: 40438845
could you please tell me the commands for that.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 40438857
How are you backing up your database now?  It's possible you don't need to use RMAN.

RMAN isn't all that simple to set up.  There is no one set of commands.

Every company/database has different requirements on its disaster recovery.  Most of the time it is bound by policy.  When a policy doesn't exist, it is bound by acceptable risk of data loss.

We cannot provide the 'exact' commands to properly back up your database because we do not know your exact requirements.

Your DBA should already know the disaster recovery/backup requirements.  If they don't, your system security folks or those that make the policies should.

If you don't have any policy, I would strongly encourage you to hire a local Oracle consultant that specializes in disaster recovery to come in and assess your systems and requirements.

Backups are the #1 thing you DO NOT EVER want to be WRONG!!!!!!
0
 

Author Closing Comment

by:jeevan mathew
ID: 40443620
Thank you.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

762 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