Standby Default LOG_ARCHIVE_DEST
Hi All,
on my standby i've parametera in init.ora
standby_archive_dest='Location=E:\oracle\oradata\archive'
##LOG_ARCHIVE_DEST_1='Location=E:\oracle\oradata\archive'
but the LOG_ARCHIVE_DEST_1 is remarked only standby_archive_dest is active.
so when i start the standby and see this thing
SQL> select * from V$archive_dest;
SQL> column DEST_NAME format a30
SQL> /
DEST_ID DEST_NAME STATUS BINDING NAME_SP TARGET ARCHIVER SCHEDULE DESTINATION
---------- ------------------------------ --------- --------- ------- ------- ---------- -------- ---------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 BAD PARAM OPTIONAL SYSTEM LOCAL ARCH INACTIVE LOCATION=E:\Oracle\Oradata\archive
2 LOG_ARCHIVE_DEST_2 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
3 LOG_ARCHIVE_DEST_3 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
4 LOG_ARCHIVE_DEST_4 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
5 LOG_ARCHIVE_DEST_5 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
6 LOG_ARCHIVE_DEST_6 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
7 LOG_ARCHIVE_DEST_7 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
8 LOG_ARCHIVE_DEST_8 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
9 LOG_ARCHIVE_DEST_9 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
10 LOG_ARCHIVE_DEST_10 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
11 LOG_ARCHIVE_DEST_11 VALID MANDATORY SYSTEM LOCAL ARCH ACTIVE E:\Oracle\Oradata\archive
why the status of first parameter status is BAD PARAM?
i fix it like alter system set log_archive_dest_1=' ';
then
SQL> alter system set log_archive_dest_1='';
System altered.
SQL> select * from V$archive_dest;
DEST_ID DEST_NAME STATUS BINDING NAME_SP TARGET ARCHIVER SCHEDULE DESTINATION
---------- ------------------------------ --------- --------- ------- ------- ---------- -------- ---------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
2 LOG_ARCHIVE_DEST_2 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
3 LOG_ARCHIVE_DEST_3 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
4 LOG_ARCHIVE_DEST_4 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
5 LOG_ARCHIVE_DEST_5 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
6 LOG_ARCHIVE_DEST_6 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
7 LOG_ARCHIVE_DEST_7 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
8 LOG_ARCHIVE_DEST_8 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
9 LOG_ARCHIVE_DEST_9 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
10 LOG_ARCHIVE_DEST_10 INACTIVE OPTIONAL SYSTEM LOCAL ARCH INACTIVE
11 LOG_ARCHIVE_DEST_11 VALID OPTIONAL SYSTEM LOCAL ARCH ACTIVE E:\Oracle\Oradata\archive
11 rows selected.
but some time i freshly restart my standby DB, it gives me the same BAD PARAM status. why is it so?
i dont have spfile and i dont want it.otherwise i could have easily type scop=both;
Ora-9.2
win 2k server
Thanx in Advance!!