Solved

archive-destination

Posted on 2014-11-12
5
130 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
  • 2
  • 2
5 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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 34

Expert Comment

by:Mark Geerlings
Comment Utility
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
Comment Utility
could you please tell me the commands for that.
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
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
Comment Utility
Thank you.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
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…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

763 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now