Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 667
  • Last Modified:

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
0
yoyolut
Asked:
yoyolut
  • 2
1 Solution
 
George K.Commented:
0
 
sdstuberCommented:
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now