-
Hi All,
I have problem to startup the primary database for my standby database setup. Both Primary and Standby are the same host.
Primary - initmydb.ora
log_archive_start = true
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
log_archive_dest_1="d:\oracle\oradata\mydb\archive\"
log_archive_dest_state_1=ENABLE
log_archive_dest_2="SERVICE=STBY MANDATORY REOPEN=30"
log_archive_dest_state_2=ENABLE
Standby - initstby.ora
log_archive_start = true
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
standby_archive_dest="d:\oracle\oradata\stby\archive"
db_file_name_convert="d:\oracle\oradata\mydb","d:\oracle\oradata\stby"
log_file_name_convert="d:\oracle\oradata\mydb\archive","d:\oracle\oradata\stby\archive"
lock_name_space=STBY
I can managed to startup the secondary with nomount mode and startby database successfully but not the primary database.
I have following error message when I start primary DB :
SQL> startup pfile=d:\oracle\admin\mydb\pfile\initmydb.ora
LRM-00101: unknown parameter name 'SERVICE'
LRM-00101: unknown parameter name 'SERVICE'
LRM-00111: no closing quote for value '30"
log_ar'
ORA-01078: failure in processing system parameters
Thanks for any feedback given.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|