standby on same server [message #466756] |
Wed, 21 July 2010 00:09 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
Hi I created a primary and physical standby on same server.But the logs are not getting shipped from the primary to the destination i specifiied in remote_archive_dest.When I see the alert log in primary it shows heartceat failed.[password files created for both pimary and secondary and sys passwords are same].
Please help me with this.I have attached the pfiles of both in following post
|
|
|
Re: standby on same server [message #466757 is a reply to message #466756] |
Wed, 21 July 2010 00:11 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
TESTMAIN.ORA
testmain.__db_cache_size=234881024
testmain.__java_pool_size=4194304
testmain.__large_pool_size=4194304
testmain.__shared_pool_size=167772160
testmain.__streams_pool_size=0
*.background_dump_dest='/imp_exp_image_fs/testmain/orabase/bdump'
*.control_files='/imp_exp_image_fs/testmain/oradata/ctrl_01.ctl'
*.core_dump_dest='/imp_exp_image_fs/testmain/orabase/cdump'
*.cursor_sharing='SIMILAR'
*.db_block_size=8192
LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.db_domain='primary'
*.db_file_multiblock_read_count=8
*.db_name='testmain'
*.db_unique_name='testmain'
*.fast_start_mttr_target=30000
*.instance_name='testmain'
*.job_queue_processes=5
*.lock_sga=TRUE
*.log_archive_dest_1='LOCATION=/imp_exp_image_fs/testmain/oraarch MANDATORY'
#*.standby_archive_dest='/imp_exp_image_fs/testalogs'
LOG_ARCHIVE_DEST_2='SERVICE=dbtest_sby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=testsby'
#*.db_file_name_convert=('/sbn_oraarch/testmain/oradata','/imp_exp_image_fs/testsby/oradata')
#*.log_file_name_convert=('/sbn_oraarch/testmain/oradata','/imp_exp_image_fs/testsby/oradata')
*.standby_file_management=AUTO
*.remote_archive_enable=TRUE
#*.lock_name_space='testsby'
*.log_buffer=5242880
LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf
*.log_checkpoint_interval=2500000
*.nls_date_format='yyyymmdd'
*.open_cursors=300
*.optimizer_mode='CHOOSE'
*.os_authent_prefix=''
*.pga_aggregate_target=25165824
*.processes=1000
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.remote_os_authent=true
*.session_max_open_files=20
*.sga_target=400M
*.shared_pool_size=100M
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=900
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/imp_exp_image_fs/testmain/orabase/udump'
TESTSBY
testmain.__db_cache_size=234881024
testmain.__java_pool_size=4194304
testmain.__large_pool_size=4194304
testmain.__shared_pool_size=167772160
testmain.__streams_pool_size=0
*.background_dump_dest='/imp_exp_image_fs/testsby/orabase/bdump'
*.control_files='/imp_exp_image_fs/testsby/oradata/ctrlsby_01.ctl'
*.core_dump_dest='/imp_exp_image_fs/testsby/orabase/cdump'
*.cursor_sharing='SIMILAR'
*.db_block_size=8192
*.db_domain='tandby'
*.db_file_multiblock_read_count=8
*.db_name='testmain'
*.db_unique_name='testsby'
*.fast_start_mttr_target=30000
*.instance_name='testsby'
*.job_queue_processes=5
*.lock_sga=TRUE
*.log_archive_dest_1='LOCATION=/imp_exp_image_fs/testsby/orarch MANDATORY'
*.log_buffer=5242880
*.log_checkpoint_interval=2500000
*.nls_date_format='yyyymmdd'
*.open_cursors=300
*.optimizer_mode='CHOOSE'
*.os_authent_prefix=''
*.pga_aggregate_target=25165824
*.processes=1000
*.query_rewrite_enabled='FALSE'
*.remote_archive_enable='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.remote_os_authent=true
*.session_max_open_files=20
*.sga_target=400M
*.shared_pool_size=100M
*.sort_area_size=524288
*.standby_file_management='AUTO'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=900
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/imp_exp_image_fs/testsby/orabase/udump'
*.db_file_name_convert=('/imp_exp_image_fs/testmain/oradata/','/imp_exp_image_fs/testsby/oradata/')
*.log_file_name_convert=('/imp_exp_image_fs/testmain/oradata/','/imp_exp_image_fs/testsby/oradata/')
*.standby_archive_dest='/imp_exp_image_fs/testalogs'
standby_file_management=AUTO
remote_archive_enable=TRUE
#lock_name_space='testsby'
fal_server='dbtest_main'
fal_client='dbtest_sby'
|
|
|
|
Re: standby on same server [message #466792 is a reply to message #466786] |
Wed, 21 July 2010 03:04 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
Alert log in primary
Wed Jul 21 12:42:15 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 12:47:16 2010
Error 1034 received logging on to the standby
Wed Jul 21 12:47:16 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 12:52:16 2010
Error 1034 received logging on to the standby
Wed Jul 21 12:52:16 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 12:57:17 2010
Error 1034 received logging on to the standby
Wed Jul 21 12:57:17 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 13:02:18 2010
Error 1034 received logging on to the standby
Wed Jul 21 13:02:18 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 13:07:19 2010
Error 1034 received logging on to the standby
Wed Jul 21 13:07:19 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 13:12:20 2010
Error 1034 received logging on to the standby
Wed Jul 21 13:12:20 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 13:17:21 2010
Error 1034 received logging on to the standby
Wed Jul 21 13:17:21 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 13:22:22 2010
Error 1034 received logging on to the standby
Wed Jul 21 13:22:22 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 13:24:26 2010
Thread 1 advanced to log sequence 38
Current log# 2 seq# 38 mem# 0: /imp_exp_image_fs/testmain/oradata/redo02.log
Wed Jul 21 13:27:22 2010
Error 1034 received logging on to the standby
Wed Jul 21 13:27:22 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Wed Jul 21 13:32:23 2010
Error 1034 received logging on to the standby
Wed Jul 21 13:32:23 2010
Errors in file /imp_exp_image_fs/testmain/orabase/bdump/testmain_arc1_7763.trc:
ORA-01034: ORACLE not available
PING[ARC1]: Heartbeat failed to connect to standby 'dbtest_sby'. Error is 1034.
Alert log in standby
Wed Jul 21 11:38:21 2010
alter database mount standby database
Wed Jul 21 11:38:25 2010
Setting recovery target incarnation to 1
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=22, OS id=11674
Wed Jul 21 11:38:26 2010
ARC0: Archival started
ARC1: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Jul 21 11:38:26 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Thread not mounted
ARC1 started with pid=9, OS id=11682
ARC1: Becoming the heartbeat ARCH
ARC1: Thread not mounted
Wed Jul 21 11:38:26 2010
Successful mount of redo thread 1, with mount id 1755451821
Wed Jul 21 11:38:26 2010
Physical Standby Database mounted.
Completed: alter database mount standby database
Wed Jul 21 11:39:09 2010
alter database recover managed standby database disconnect from session
Wed Jul 21 11:39:09 2010
Attempt to start background Managed Standby Recovery process (testsby)
MRP0 started with pid=11, OS id=13317
Wed Jul 21 11:39:09 2010
MRP0: Background Managed Standby Recovery process started (testsby)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 15 processes
Wed Jul 21 11:39:16 2010
Errors in file /imp_exp_image_fs/testsby/orabase/bdump/testsby_mrp0_13317.trc:
ORA-00367: checksum error in log file header
ORA-00341: log 1 of thread 1, wrong log # 4 in header
ORA-00312: online log 1 thread 1: '/imp_exp_image_fs/testsby/oradata/redo01.log'
Clearing online redo logfile 1 /imp_exp_image_fs/testsby/oradata/redo01.log
Clearing online log 1 of thread 1 sequence number 0
Wed Jul 21 11:39:16 2010
Completed: alter database recover managed standby database disconnect from session
Wed Jul 21 11:39:16 2010
Clearing online redo logfile 1 complete
Wed Jul 21 11:39:16 2010
Errors in file /imp_exp_image_fs/testsby/orabase/bdump/testsby_mrp0_13317.trc:
ORA-00367: checksum error in log file header
ORA-00341: log 2 of thread 1, wrong log # 5 in header
ORA-00312: online log 2 thread 1: '/imp_exp_image_fs/testsby/oradata/redo02.log'
Clearing online redo logfile 2 /imp_exp_image_fs/testsby/oradata/redo02.log
Clearing online log 2 of thread 1 sequence number 0
Clearing online redo logfile 2 complete
Wed Jul 21 11:39:16 2010
Errors in file /imp_exp_image_fs/testsby/orabase/bdump/testsby_mrp0_13317.trc:
ORA-00367: checksum error in log file header
ORA-00341: log 3 of thread 1, wrong log # 6 in header
ORA-00312: online log 3 thread 1: '/imp_exp_image_fs/testsby/oradata/redo03.log'
Clearing online redo logfile 3 /imp_exp_image_fs/testsby/oradata/redo03.log
Clearing online log 3 of thread 1 sequence number 0
Clearing online redo logfile 3 complete
Media Recovery Waiting for thread 1 sequence 25
Wed Jul 21 12:55:08 2010
alter database recover managed standby database parallel 16 disconnect from session
Wed Jul 21 12:55:39 2010
ORA-1153 signalled during: alter database recover managed standby database parallel 16 disconnect from session...
[Updated on: Wed, 21 July 2010 03:05] Report message to a moderator
|
|
|
|
|
Re: standby on same server [message #466822 is a reply to message #466798] |
Wed, 21 July 2010 05:33 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
db_file_name_convert & log_file_name_convert parameter missing in primary database?????Those will be required only in case of a switchover right?
The errors in log files are corrected.
whats the problem.
|
|
|
|
|
|
|
Re: standby on same server [message #467001 is a reply to message #466839] |
Thu, 22 July 2010 00:13 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
I tried to manually ship the logs to standby archive dest and register it using 'alter database register' and then the logs are applied.But the logs are not getting shipped from primary automatically wats the problem???network entries are done and tnsping works properly..wat must be done
|
|
|
|