Home » RDBMS Server » Server Administration » How to set NULL on LOG_ARCHIVE_DEST_N (Oracle, 11g R2, solaris 5.10)
How to set NULL on LOG_ARCHIVE_DEST_N [message #625061] Wed, 01 October 2014 00:48 Go to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Hello,

I want delete path of "LOG_ARCHIVE_DEST_1" on database. How to do it?


select dest_name, destination
from v$archive_dest
where status='VALID'

result:
DEST_NAME	DESTINATION
LOG_ARCHIVE_DEST_1	/u01/app/oracle/product/11.2.0/db_1/dbs/arch
LOG_ARCHIVE_DEST_3	/bkp/archive2

[Updated on: Wed, 01 October 2014 00:54]

Report message to a moderator

Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625063 is a reply to message #625061] Wed, 01 October 2014 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It depends if you started from a pfile or spfile.
For the former, remove the line from the file.
For the latter, "alter system reset log_archive_dest_1"
Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625064 is a reply to message #625063] Wed, 01 October 2014 01:26 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
I works on RAC environment. May I do one node or all nodes?
Do I disable archive log mode before do it?
Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625069 is a reply to message #625064] Wed, 01 October 2014 02:09 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
I did below command then fixed.

alter system set LOG_ARCHIVE_DEST_1='';
Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625070 is a reply to message #625064] Wed, 01 October 2014 02:28 Go to previous message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Tlg13team wrote on Wed, 01 October 2014 08:26
I works on RAC environment. May I do one node or all nodes?
Do I disable archive log mode before do it?


For all nodes:
alter system reset log_archive_dest_1 sid='*';

You still didn't tell us if you work with a pfile or a spfile.

Quote:
I did below command then fixed.


Setting to null or resetting parameter is not the same thing.
Setting to null is OK to fix the problem in the current instances (without restarting them).

Previous Topic: Which is better for a lot of sessions in oracle database?
Next Topic: Actual Database Size
Goto Forum:
  


Current Time: Thu Feb 22 07:30:23 CST 2018

Total time taken to generate the page: 0.01560 seconds