| HELP!!! please log_archive_dest_2 [message #125169] |
Thu, 23 June 2005 11:35  |
Zakkhalid
Messages: 47
Registered: April 2005
|
Member |
|
|
my setting for log_archive_dest_2
is as following
show parameter log_archive_dest_2;
log_archive_dest_2 service="stdbydb1_standby", AR
CH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=300
register
but I need to make it mandatory.
I'm using a spfile ...
I've tried alter system set=....
but with no luck...
I'm using 9206
thanking you all inadvance...
|
|
|
|
|
|
|
|
|
|
| Re: HELP!!! please log_archive_dest_2 [message #125295 is a reply to message #125169] |
Fri, 24 June 2005 05:12  |
Zakkhalid
Messages: 47
Registered: April 2005
|
Member |
|
|
hi
thanks for the responses...
I keep the following error...
alter system set LOG_ARCHIVE_MIN_SUCCEED_DEST=2
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16020: less destinations available than specified by
LOG_ARCHIVE_MIN_SUCCEED_DEST
This is probably because the second option is optional ... still not sure how to make it mandatory....
|
|
|
|
| Re: HELP!!! please log_archive_dest_2 [message #125300 is a reply to message #125295] |
Fri, 24 June 2005 05:24 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
2 ways:
1.Use alter system command.
Specify parameter log_archive_dest_2 as MAndatatory instead of Optional. do specify all other settings as well.
2. Create pfile from spfile.
Modify the parameter log_archive_dest_2 in pfile.
Bounce ur database using this pfile.
Recreate the spfile after the database has started.
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
