How to set NULL on LOG_ARCHIVE_DEST_N [message #625061] |
Wed, 01 October 2014 00:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #625070 is a reply to message #625064] |
Wed, 01 October 2014 02:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68653 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Tlg13team wrote on Wed, 01 October 2014 08:26I 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).
|
|
|