Solved

Move Hold Archivelog in Oracle DB

Posted on 2010-11-10
4
650 Views
Last Modified: 2013-12-19
Hi,

I have to move my archivelog directory.

So I modify the pfile to use the new directory, It work's fin, the new archive log is created on the new directory.

But i have a litle problem with my Hold logfile archive. on this views v$ARCHIVED_LOG i show that hold archivelog don't use the new directory.

It's a big problem for my backup software which try to use the hold directory.

So my question is How to say on Oracle that the old archivelog are in the new folder ?

Thanks,
Yoann

PS I use an 9iR2
0
Comment
Question by:yoyolut
  • 2
4 Comments
 
LVL 13

Expert Comment

by:George K.
ID: 34101438
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 34101518
Simple answer: you can't.

but you don't need to.  

The v$archived_log tells you where Oracle wrote the file,  if you move, delete or modify the file once written, the database doesn't know or need to know.

The location is only important for the purposes of writing the file to backups (which the database isn't involved in)  or in the restoration of logs (in which case the database isn't up anyway and you tell the it where the files are when you do the restore)
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 34101546
The location is also important for log mining, but again, if you need to do that you declare the location of the files when you begin the mining
0
 

Author Comment

by:yoyolut
ID: 34102059
ok thanks it's not possible...
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
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.

776 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