Solved

archive-destination

Posted on 2014-11-12
5
145 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 500 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 Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

705 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