-
dataguard issue-archivelogs not getting applied
Hi Guys,
Trying to configure standby(phyiscal) having following issues database version 10g(hp-ux 11.2).
Here are the output for the following queries.
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 WAIT_FOR_GAP 2 10902 0 0
SQL> select * from v$archive_gap;
no rows selected
SQL> SELECT max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
select message from v$dataguard_status;
MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Media Recovery Waiting for thread 1 sequence 12335
Fetching gap sequence in thread 1, gap sequence 12335-12431
FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
MESSAGE
--------------------------------------------------------------------------------
FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 12335-12431
DBID 1860283776 branch 613346304
FAL[client]: All defined FAL servers have been attempted.
MRP0: Background Media Recovery cancelled with status 16037
MRP0: Background Media Recovery process shutdown
Managed Standby Recovery Canceled
MESSAGE
--------------------------------------------------------------------------------
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Media Recovery Waiting for thread 1 sequence 12335
Fetching gap sequence in thread 1, gap sequence 12335-12431
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 12335-12431
11:06AM Artis, Bernard: MESSAGE
--------------------------------------------------------------------------------
DBID 1860283776 branch 613346304
FAL[client]: All defined FAL servers have been attempted.
MRP0: Background Media Recovery cancelled with status 16037
MRP0: Background Media Recovery process shutdown
Managed Standby Recovery Canceled
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Media Recovery Log /u01/app/oracle/arch/RUBIS/1_12335_613346304.dbf
Media Recovery Waiting for thread 2 sequence 10902
Fetching gap sequence in thread 2, gap sequence 10902-10995
MESSAGE
--------------------------------------------------------------------------------
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 10902-10995
DBID 1860283776 branch 613346304
FAL[client]: All defined FAL servers have been attempted.
Thanks in advance
-
SQL> SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG;
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12335 NO
1 12336 NO
1 12337 NO
1 12338 NO
1 12339 NO
1 12340 NO
1 12341 NO
1 12342 NO
1 12343 NO
1 12344 NO
1 12345 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12346 NO
1 12347 NO
1 12348 NO
1 12349 NO
1 12350 NO
1 12351 NO
1 12352 NO
1 12353 NO
1 12354 NO
1 12355 NO
1 12356 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12357 NO
1 12358 NO
1 12359 NO
1 12360 NO
1 12361 NO
1 12362 NO
1 12363 NO
1 12364 NO
11:18AM Artis, Bernard: 1 12365 NO
1 12366 NO
1 12367 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12368 NO
1 12369 NO
1 12370 NO
1 12371 NO
1 12372 NO
1 12373 NO
1 12374 NO
1 12375 NO
1 12376 NO
1 12377 NO
1 12378 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12379 NO
1 12380 NO
1 12381 NO
1 12382 NO
1 12383 NO
1 12384 NO
1 12385 NO
1 12386 NO
1 12387 NO
1 12388 NO
1 12389 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12390 NO
1 12391 NO
1 12392 NO
1 12393 NO
1 12394 NO
1 12395 NO
1 12396 NO
1 12397 NO
1 12398 NO
1 12399 NO
1 12400 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12401 NO
1 12402 NO
11:18AM Artis, Bernard: 1 12403 NO
1 12404 NO
1 12405 NO
1 12406 NO
1 12407 NO
1 12408 NO
1 12409 NO
1 12410 NO
1 12411 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12412 NO
1 12413 NO
1 12414 NO
1 12415 NO
1 12416 NO
1 12417 NO
1 12418 NO
1 12419 NO
1 12420 NO
1 12421 NO
1 12422 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12423 NO
1 12424 NO
1 12425 NO
1 12426 NO
1 12427 NO
1 12428 NO
1 12429 NO
1 12430 NO
1 12431 NO
1 12432 NO
1 12433 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
1 12434 NO
1 12435 NO
1 12436 NO
1 12437 NO
1 12438 NO
104 rows selected.
WHERE TESTP-PRIMARY DATABASE
TESTS STANDBY
##Modification to primary##
*.log_archive_dest_2='SERVICE=TESTS valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=TESTS'
*.db_file_name_convert='/u05/oradata/TESTS','/u05/oradata/TESTP'
*.log_file_name_convert='/u02/origlog/TESTS','/u02/origlog/TESTP','/u03/mirrlog/TESTS','/u03/mirrlog/TESTP'
*.fal_client='TESTP'
*.fal_server='TESTS'
*.standby_file_management='AUTO'
*.STANDBY_ARCHIVE_DEST='/u01/app/oracle/arch/db_2/WTEXP'
##Modifications to standby##
TESTP1.__db_cache_size=1392508928
TESTS.__db_cache_size=1392508928
TESTP1.__java_pool_size=16777216
TESTS.__java_pool_size=16777216
TESTP1.__large_pool_size=16777216
TESTS.__large_pool_size=16777216
TESTP1.__shared_pool_size=452984832
TESTS.__shared_pool_size=452984832
TESTP1.__streams_pool_size=0
TESTS.__streams_pool_size=0
*.archive_lag_target=900
*.audit_file_dest='/u01/app/oracle/admin/TESTS/adump'
*.background_dump_dest='/u01/app/oracle/admin/TESTS/bdump'
*.backup_tape_io_slaves=true
*.cluster_database_instances=1
*.compatible='10.2.0.2.0'
*.control_file_record_keep_time=45
*.core_dump_dest='/u01/app/oracle/admin/TESTS/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/u05/oradata/TESTP','/u05/oradata/TESTS'
*.db_name='TESTP'
*.db_recovery_file_dest='/u04/app/oracle/flash_recovery/TESTS'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='TESTS'
*.fal_client='TESTS'
*.fal_server='TESTP'
*.instance_name='TESTS'
TESTS.instance_number=1
*.job_queue_processes=10
*.local_listener='LISTENER_TESTS'
*.log_archive_config='DG_CONFIG=(TESTP,TESTS)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/arch/TESTS VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TESTS'
*.log_archive_dest_2='SERVICE=TESTP valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=TESTP'
*.log_archive_format='TESTPARCH_%t_%s_%r.dbf'
*.log_file_name_convert='/u02/origlog/TESTP','/u02/origlog/TESTS','/u03/mirrlog/TESTP','/u03/mirrlog/TESTS'
*.open_cursors=300
*.pga_aggregate_target=200M
*.processes=1000
*.remote_listener='LISTENER_TESTS'
*.remote_login_passwordfile='exclusive'
*.sessions=225
*.sga_target=1800M
*.standby_archive_dest='/u01/app/oracle/arch/TESTS'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
TESTS1.undo_tablespace='UNDO_01'
*.user_dump_dest='/u01/app/oracle/admin/TESTS/udump'
-
-
FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
This means that you don't have TNS set up correctly on your standby for it to be able to pull the logs across the network once it has discovered a gap. Either:
Fix your TNS.
or
Manually copy the logs across to your standby and register the logs.
Assistance is Futile...
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
|