Move Hold Archivelog in Oracle DB

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
yoyolutAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
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
 
George K.Commented:
0
 
sdstuberCommented:
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
 
yoyolutAuthor Commented:
ok thanks it's not possible...
0
All Courses

From novice to tech pro — start learning today.