Home » RDBMS Server » Server Administration » changing name / destination of archive log files ?
changing name / destination of archive log files ? [message #50868] Thu, 11 April 2002 10:38 Go to next message
R. Stein
Messages: 4
Registered: April 2002
Junior Member
hi,

I want to change the name and destination (directory) of the archive log files of a running oracle 9i production database.

do I just have to shutdown the database, modify the log_archive_dest_1 and log_archive_format parameters and start up the database again ?

or are there any other things to do like move the old archive files to the new destination, rename them etc ?

tnx.

Report message to a moderator

Re: changing name / destination of archive log files ? [message #50869 is a reply to message #50868] Thu, 11 April 2002 10:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yes.
do the changes.
secure the old and new destinations with filesystem permissions.

Report message to a moderator

Re: changing name / destination of archive log files ? [message #50892 is a reply to message #50868] Fri, 12 April 2002 07:11 Go to previous message
R. Stein
Messages: 4
Registered: April 2002
Junior Member
Tnx, it worked this way.

although to make them permanent I had to issue
CREATE SPFILE from PFILE='.....' on the inactive
(shutdown) instance.

Report message to a moderator

Previous Topic: Re: ORA-08103: object no longer exists
Next Topic: Runtime Performance on tables loaded direct vs. conventional
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 09 18:44:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.