configuring dataguard
Dear Friend
Database version: 10.2.0
OS: windows XP
I m configuring dataguard. but out of all efforts cudnt resolve this error
SQL> CREATE SPFILE FROM pfile='D:\oracle10g\product\10.2.0\db_2\database\initPRIM.ora';
CREATE SPFILE FROM pfile='D:\oracle10g\product\10.2.0\db_2\database\initPRIM.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 146 found in the input file
have a look on my pfile
------------------------------
prim.__db_cache_size=188743680
prim.__java_pool_size=4194304
prim.__large_pool_size=4194304
prim.__shared_pool_size=83886080
prim.__streams_pool_size=0
*.audit_file_dest=’D:\oracle10g\product\10.2.0/admin/PRIM/adump’
*.background_dump_dest=’D:\oracle10g\product\10.2.0/admin/PRIM/bdump’
*.compatible=’10.2.0.1.0’
*.control_files=’D:\oracle10g\product\10.2.0/oradata/PRIM/\control01.ctl’,’D:\oracle10g\product\10.2.0/oradata/
PRIM/\control02.ctl’,’D:\oracle10g\product\10.2.0/oradata/PRIM/\control03.ctl’
*.core_dump_dest=’D:\oracle10g\product\10.2.0/admin/PRIM/cdump’
*.db_block_size=8192
*.db_domain=’’
*.db_file_multiblock_read_count=16
*.db_name=’PRIM’
*.db_recovery_file_dest=’D:\oracle10g\product\10.2.0/flash_recovery_area’
*.db_recovery_file_dest_size=2147483648
*.dispatchers=’(PROTOCOL=TCP) (SERVICE=PRIMXDB)’
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=95420416
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.sga_target=287309824
*.undo_management=’AUTO’
*.undo_tablespace=’UNDOTBS1’
*.user_dump_dest=’D:\oracle10g\product\10.2.0/admin/PRIM/udump’
db_name=PRIM
db_unique_name=PRIM
LOG_ARCHIVE_CONFIG=’DG_CONFIG=(PRIM,STAN)’
LOG_ARCHIVE_DEST_1=
’LOCATION=D:\oracle10g\product\10.2.0\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
DB_FILE_NAME_CONVERT=’D:\oracle10g\product\10.2.0\oradata\STAN\DATAFILE’,’D:\oracle10g\product\10.2.0\oradata\P
RIM\DATAFILE’
LOG_FILE_NAME_CONVERT=’D:\oracle10g\product\10.2.0\oradata\STAN\ONLINELOG’,’D:\oracle10g\product\10.2.0\oradata
\PRIM\ONLINELOG’,’D:\oracle10g\product\10.2.0\flash_recovery_area\STAN\ONLINELOG’,’D:\oracle10g\product\10.2.0\
flash_recovery_area\PRIM\ONLINELOG’
thanks and regards,