ORA-01078,LRM-00123 in dataguard configuration
710205Mar 3 2010 — edited Mar 3 2010i'm in middle of dataguard configuration...
in the doc which i'm using they have mentioned to edit the primary ora file and make some necessary changes,
i did those changes,
but at the time of spfile creation it is throwing an error like ora-01078,lrm-00123,
i'm attaching both the content below,
i need u guys help please,
i doc which i have.
****db_name=PRIM****
****db_unique_name=PRIM****
****LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STAN)'****
****LOG_ARCHIVE_DEST_1=****
****'LOCATION=F:\Oracle\flash_recovery_area\PRIM\ARCHIVELOG****
****VALID_FOR=(ALL_LOGFILES,ALL_ROLES)****
****DB_UNIQUE_NAME=PRIM'****
****LOG_ARCHIVE_DEST_2=****
****'SERVICE=STAN LGWR ASYNC****
****VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)****
****DB_UNIQUE_NAME=STAN'****
****LOG_ARCHIVE_DEST_STATE_1=ENABLE****
****LOG_ARCHIVE_DEST_STATE_2=ENABLE****
****LOG_ARCHIVE_FORMAT=%t_%s_%r.arc****
****LOG_ARCHIVE_MAX_PROCESSES=30****
****remote_login_passwordfile='EXCLUSIVE'****
****FAL_SERVER=STAN****
****FAL_CLIENT=PRIM****
****STANDBY_FILE_MANAGEMENT=AUTO****
****# Specify the location of the standby DB datafiles followed by the primary location;****
****DB_FILE_NAME_CONVERT='E:\oracle\product\10.2.0\oradata\STAN\DATAFILE','E:\oracle\product\10.2.0\oradata\PRIM\DATAFILE'****
****# Specify the location of the standby DB online redo log files followed by the primary location LOG_FILE_NAME_CONVERT=’E:\oracle\product\10.2.0\oradata\STAN\ONLINELOG’,’E:\oracle\product\10.2.0\oradata\PRIM\ONLINELOG’,’F:\Oracle\flash_recovery_area\STAN\ONLINELOG’,’F:\Oracle\flash_recovery_area\PRIM\ONLINELOG’****
the file which is after changes
db_name=orcm
db_unique_name=orcm
LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcm,orcl)'
LOG_ARCHIVE_DEST_1=
*'LOCATION=F:\Oracle\product\10.2.0\flash_recovery_area\orcm\ARCHIVELOG*
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=orcm'
LOG_ARCHIVE_DEST_2=
*'SERVICE=STAN LGWR ASYNC*
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=orcl'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
remote_login_passwordfile='EXCLUSIVE'
FAL_SERVER=orcl
FAL_CLIENT=orcm
STANDBY_FILE_MANAGEMENT=AUTO
*# Specify the location of the standby DB datafiles followed by the primary location;*
DB_FILE_NAME_CONVERT=
*'E:\oracle\product\10.2.0\oradata\orcl\DATAFILE',*
*'E:\oracle\product\10.2.0\oradata\orcm\DATAFILE'*
*# Specify the location of the standby DB online redo log files followed by the primary*
location;
LOG_FILE_NAME_CONVERT=’E:\oracle\product\10.2.0\oradata\orcl\ONLINELOG’,
*’E:\oracle\product\10.2.0\oradata\orcm\ONLINELOG’,*
*’E:\Oracle\product\10.2.0\flash_recovery_area\orcl\ONLINELOG’,*
*’E:\Oracle\product\10.2.0\flash_recovery_area\orcm\ONLINELOG’*