Solved

archive-destination

Posted on 2014-11-12
5
141 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)
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 76

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ORA-06504: PL/SQL: Return types of Result Set variables or query do not match 4 103
MULTIPLE DATE QUERY 15 77
exp/imp 25 73
Oracle DBLINKS From 11g to 8i 3 31
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

785 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