Home » RDBMS Server » Server Administration » changing archive log destination (Oracle 10g R2/ Solaris 10)
changing archive log destination [message #514841] Wed, 06 July 2011 20:04 Go to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Good day!

Just to validate from you experts if in case I change the destination file of my archive logs, does it require a restart of the database?

Thank you in advance.
Re: changing archive log destination [message #514843 is a reply to message #514841] Wed, 06 July 2011 20:19 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
>Just to validate from you experts if in case I change the destination file of my archive logs, does it require a restart of the database?

What prevents you from testing it yourself?

Re: changing archive log destination [message #514845 is a reply to message #514843] Wed, 06 July 2011 21:00 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Sir, I'm referring to a production server.

I just read from some forums that this does not require a restart.

Thanks.
Re: changing archive log destination [message #514846 is a reply to message #514845] Wed, 06 July 2011 21:10 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
>Sir, I'm referring to a production server.
Surely you have a TEST DB upon which you can run a simple test

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: changing archive log destination [message #514847 is a reply to message #514846] Wed, 06 July 2011 21:23 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

I'm sorry to tell you Sir in our case, we don't have yet.
We had for 9i, 8i & 7... I would not post it anyway,
if we can test it.

This production server was once maintained by our outsourcer.
It was turned-over to us 2 years ago where the setting of
it's archive log is via FLASH_RECOVERY_AREA.

Thanks.


Re: changing archive log destination [message #514848 is a reply to message #514847] Wed, 06 July 2011 21:28 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
>It was turned-over to us 2 years ago
Does this mean that no changes have been made on this system since then?
Re: changing archive log destination [message #514849 is a reply to message #514848] Wed, 06 July 2011 21:38 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Unfortunately yes. It was not properly turned-over to
us, and no good documentations at all.

Please give me the answer for my post, does it require a restart or not.

Thank you.
Re: changing archive log destination [message #514851 is a reply to message #514849] Wed, 06 July 2011 22:19 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
SQL> desc v$parameter
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 NUM						    NUMBER
 NAME						    VARCHAR2(80)
 TYPE						    NUMBER
 VALUE						    VARCHAR2(4000)
 DISPLAY_VALUE					    VARCHAR2(4000)
 ISDEFAULT					    VARCHAR2(9)
 ISSES_MODIFIABLE				    VARCHAR2(5)
 ISSYS_MODIFIABLE				    VARCHAR2(9)
 ISINSTANCE_MODIFIABLE				    VARCHAR2(5)
 ISMODIFIED					    VARCHAR2(10)
 ISADJUSTED					    VARCHAR2(5)
 ISDEPRECATED					    VARCHAR2(5)
 ISBASIC					    VARCHAR2(5)
 DESCRIPTION					    VARCHAR2(255)
 UPDATE_COMMENT 				    VARCHAR2(255)
 HASH						    NUMBER
Re: changing archive log destination [message #514862 is a reply to message #514841] Thu, 07 July 2011 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All parameters are described in Database Reference, check with the one of your version.

Regards
Michel

Re: changing archive log destination [message #514866 is a reply to message #514849] Thu, 07 July 2011 01:25 Go to previous messageGo to next message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
I understand why you would like some re-assurance before attempting to make untested changes on a production system. Do not worry: you can issue the appropriate ALTER SYSTEM commands while the system is running.

But the commands may not work. I do not have a 10g database, so I can't test, but when doing this with 11g recently I did find some problems with Standard Edition. I can't remember the details, but I think that if you are using Enterprise Edition, you can change from the FRA to log_archive_Dest_n no problem; but SE didn't let me change from FRA to log_archive_dest and log_archive_duplex_dest.

Try it - you will not crash the database.
Re: changing archive log destination [message #515398 is a reply to message #514841] Mon, 11 July 2011 06:34 Go to previous message
raj9999
Messages: 49
Registered: June 2011
Member
Reym21,

You doesnt need a restart for changing the destination file of your archive logs.
You can do it easily with "alter system set" command.
Previous Topic: rebuild index and recreate them
Next Topic: Unable to use more than 2GB memory for Oracle in Windows 2003
Goto Forum:
  


Current Time: Thu Oct 02 09:51:45 CDT 2014

Total time taken to generate the page: 0.28911 seconds