Home » Server Options » Data Guard » New Data Guard, logs not shipping across (Oracle 10.2.0.3.0 RHEL4)
New Data Guard, logs not shipping across [message #417765] Tue, 11 August 2009 08:01 Go to next message
Mark Baxter
Messages: 7
Registered: August 2009
Junior Member
Hi,

I have been trying to set up a Data Guard system so as to test something with our application. My test was based around using the "Oracle Data Guard Concepts and Administration" documentation to set up a Physical Standby of a basic Oracle 10.2.0.3.0 installation on Red Hat 4. The basic database has the dummy data included that Oracle offers on installation.

My problem seems to be that the logs just are not shipping over when I switch log files.

On the Primary Database:
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
  2  FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

 SEQUENCE# FIRST_TIME	   NEXT_TIME
---------- --------------- ---------------
	 4 15-JUL-09	   15-JUL-09
	 5 15-JUL-09	   15-JUL-09
	 6 15-JUL-09	   16-JUL-09
	 7 16-JUL-09	   16-JUL-09
	 8 16-JUL-09	   16-JUL-09
	 9 16-JUL-09	   16-JUL-09

... and so on

On the Standby:
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
  2  FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

no rows selected

SQL> 


The Primary (MARKTEST) can tnsping the Standby:
tnsping testmark

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 11-AUG-2009 14:38:09

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.224)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TESTMARK)))
OK (0 msec)


And the Standby can tnsping the Primary:
tnsping marktest

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 11-AUG-2009 14:43:46

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.151)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MARKTEST)))
OK (0 msec)


Looking at the Alert Log on the Standby machine, there are quite a lot of lines of the form "ARC<letter>: Thread not mounted".

Does anyone have any pointers as to what/where I should be looking at to solve my problem?

Thanks in advance for any help received.

For the record, these are the pfiles used:

MARKTEST (PRIMARY):
MARKTEST.__db_cache_size=369098752
MARKTEST.__java_pool_size=4194304
MARKTEST.__large_pool_size=4194304
MARKTEST.__shared_pool_size=150994944
MARKTEST.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/adump'
*.background_dump_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/opt/oracle/product/10.2.0/oradata/MARKTEST/control01.ctl','/opt/oracle/product/10.2.0/oradata/MARKTEST/control02.ctl','/opt/oracle/product/10.2.0/oradata/MARKTEST/control03.ctl'
*.core_dump_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='MARKTEST'
*.db_recovery_file_dest='/opt/oracle/product/10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=MARKTESTXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=1669332992
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=536870912
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/udump'



DB_UNIQUE_NAME='MARKTEST'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(MARKTEST,TESTMARK)'
LOG_ARCHIVE_DEST_1=
 'LOCATION=/opt/oracle/product/10.2.0/oradata/MARKTEST/ 
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=MARKTEST'
LOG_ARCHIVE_DEST_2=
 'SERVICE=TESTMARK LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=TESTMARK'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30


TESTMARK (Standby):
MARKTEST.__db_cache_size=360710144
MARKTEST.__java_pool_size=4194304
MARKTEST.__large_pool_size=4194304
MARKTEST.__shared_pool_size=159383552
MARKTEST.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/adump'
*.background_dump_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/opt/oracle/product/10.2.0/oradata/TESTMARK/control01.ctl','/opt/oracle/product/10.2.0/oradata/TESTMARK/control02.ctl','/opt/oracle/product/10.2.0/oradata/TESTMARK/control03.ctl'
*.core_dump_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='MARKTEST'
*.db_recovery_file_dest='/opt/oracle/product/10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=MARKTESTXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=1669332992
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=536870912
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/product/10.2.0/admin/MARKTEST/udump'


DB_UNIQUE_NAME='TESTMARK'
DB_FILE_NAME_CONVERT='MARKTEST','TESTMARK'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(MARKTEST,TESTMARK)'
LOG_FILE_NAME_CONVERT=
  '/opt/oracle/product/10.2.0/oradata/MARKTEST','/opt/oracle/product/10.2.0/oradata/TESTMARK'
LOG_ARCHIVE_DEST_1=
 'LOCATION=/opt/oracle/product/10.2.0/oradata/TESTMARK/ 
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=TESTMARK'
LOG_ARCHIVE_DEST_2=
 'SERVICE=MARKTEST LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=MARKTEST'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=MARKTEST
FAL_CLIENT=TESTMARK
STANDBY_FILE_MANAGEMENT=AUTO
Re: New Data Guard, logs not shipping across [message #417797 is a reply to message #417765] Tue, 11 August 2009 10:05 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Post alert log from primary & standby database

execute
alert log list 
from primary & standby
Re: New Data Guard, logs not shipping across [message #417842 is a reply to message #417765] Tue, 11 August 2009 14:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What does the following show on the primary:

select destination, status, error
from v$archive_dest;

You may also want to review Oracle 10g - Manually Create a Physical Standby Database Using Data Guard.
Re: New Data Guard, logs not shipping across [message #418001 is a reply to message #417797] Wed, 12 August 2009 08:07 Go to previous messageGo to next message
Mark Baxter
Messages: 7
Registered: August 2009
Junior Member
gentlebabu wrote on Tue, 11 August 2009 17:05

Post alert log from primary & standby database

execute
alert log list 
from primary & standby


Hi. Thanks for the reply.

Unfortunately this command doesn't work and after a google search I am still not sure what it is you want me to post.

Can you be a bit more specific?
Re: New Data Guard, logs not shipping across [message #418003 is a reply to message #418001] Wed, 12 August 2009 08:10 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Sorry for posting; wrong command. Pls try this

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle
Oldest online log sequence     100
Next log sequence to archive   100
Current log sequence           100
Re: New Data Guard, logs not shipping across [message #418009 is a reply to message #417842] Wed, 12 August 2009 08:30 Go to previous messageGo to next message
Mark Baxter
Messages: 7
Registered: August 2009
Junior Member
ebrian wrote on Tue, 11 August 2009 21:57
What does the following show on the primary:

select destination, status, error
from v$archive_dest;

You may also want to review <removed link as I cannot use them until I have 5 or more posts>.



SQL> select destination, status, error
  2  from v$archive_dest;

DESTINATION  STATUS    ERROR

             INACTIVE  INACTIVE


DESTINATION  STATUS  ERROR

       	     INACTIVE  INACTIVE


DESTINATION  STATUS  ERROR

       	     INACTIVE


DESTINATION  STATUS    ERROR

       	     INACTIVE  INACTIVE


DESTINATION  STATUS    ERROR

       	     INACTIVE  INACTIVE


DESTINATION  STATUS    ERROR

USE_DB_RECOVERY_FILE_DEST
ERROR
ORA-19809: limit exceeded for recovery files


10 rows selected.

SQL>



I imagine the ORA-19809 is due to the logs filling up due to not being shipped. I'm not quite sure what to do there - delete them or wait until they start shipping. Any recommendations?

Thanks for the link. I did read that earlier but I found that it was missing some steps/assumed a bit too much so I went with the official Oracle documentation instead.
Re: New Data Guard, logs not shipping across [message #418011 is a reply to message #418003] Wed, 12 August 2009 08:34 Go to previous messageGo to next message
Mark Baxter
Messages: 7
Registered: August 2009
Junior Member
gentlebabu wrote on Wed, 12 August 2009 15:10

Sorry for posting; wrong command. Pls try this

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle
Oldest online log sequence     100
Next log sequence to archive   100
Current log sequence           100



PRIMARY:
SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     61
Next log sequence to archive   61
Current log sequence	       63


STANDBY:
SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /opt/oracle/product/10.2.0/oradata/TESTMARK/
Oldest online log sequence     0
Next log sequence to archive   0
Current log sequence	       0


Re: New Data Guard, logs not shipping across [message #418044 is a reply to message #418009] Wed, 12 August 2009 13:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Try to increase the value of db_recovery_file_dest_size.
Re: New Data Guard, logs not shipping across [message #418047 is a reply to message #418044] Wed, 12 August 2009 13:27 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


post alert log from primary & standby db
Re: New Data Guard, logs not shipping across [message #418577 is a reply to message #417765] Mon, 17 August 2009 07:52 Go to previous messageGo to next message
Mark Baxter
Messages: 7
Registered: August 2009
Junior Member
Sorry for not replying last week. I was ill.

I have now increased the size of db_recovery_file_dest_size so I am no longer getting complaints from there.

Here are the alert logs:

PRIMARY:

Mon Aug 17 14:20:02 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 239075328
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 536870912
  control_files            = /opt/oracle/product/10.2.0/oradata/MARKTEST/control01.ctl, /opt/oracle/product/10.2.0/oradata/MARKTEST/control02.ctl, /opt/oracle/product/10.2.0/oradata/MARKTEST/control03.ctl
  db_block_size            = 8192
  __db_cache_size          = 281018368
  compatible               = 10.2.0.3.0
  log_archive_dest_state_2 = ENABLE
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /opt/oracle/product/10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 4096000000
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MARKTESTXDB)
  job_queue_processes      = 10
  background_dump_dest     = /opt/oracle/product/10.2.0/admin/MARKTEST/bdump
  user_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/udump
  core_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/cdump
  audit_file_dest          = /opt/oracle/product/10.2.0/admin/MARKTEST/adump
  db_name                  = MARKTEST
  open_cursors             = 300
  pga_aggregate_target     = 1669332992
PMON started with pid=2, OS id=1611
PSP0 started with pid=3, OS id=1613
MMAN started with pid=4, OS id=1615
DBW0 started with pid=5, OS id=1617
LGWR started with pid=6, OS id=1619
CKPT started with pid=7, OS id=1621
SMON started with pid=8, OS id=1623
RECO started with pid=9, OS id=1625
CJQ0 started with pid=10, OS id=1627
MMON started with pid=11, OS id=1629
Mon Aug 17 14:20:02 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1631
Mon Aug 17 14:20:02 2009
starting up 1 shared server(s) ...
Mon Aug 17 14:20:02 2009
ALTER DATABASE   MOUNT
Mon Aug 17 14:20:07 2009
Setting recovery target incarnation to 2
Mon Aug 17 14:20:07 2009
Successful mount of redo thread 1, with mount id 3816185490
Mon Aug 17 14:20:07 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Mon Aug 17 14:20:07 2009
ALTER DATABASE OPEN
Mon Aug 17 14:20:07 2009
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=1639
Mon Aug 17 14:20:07 2009
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=17, OS id=1641
Mon Aug 17 14:20:07 2009
ARC0: STARTING ARCH PROCESSES
Mon Aug 17 14:20:07 2009
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon Aug 17 14:20:07 2009
db_recovery_file_dest_size of 3906 MB is 53.58% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Aug 17 14:20:07 2009
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=18, OS id=1643
Mon Aug 17 14:20:11 2009
Thread 1 advanced to log sequence 64
Thread 1 opened at log sequence 64
  Current log# 3 seq# 64 mem# 0: /opt/oracle/product/10.2.0/oradata/MARKTEST/redo03.log
Successful open of redo thread 1
Mon Aug 17 14:20:11 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Aug 17 14:20:11 2009
SMON: enabling cache recovery
Mon Aug 17 14:20:14 2009
Successfully onlined Undo Tablespace 1.
Mon Aug 17 14:20:14 2009
SMON: enabling tx recovery
Mon Aug 17 14:20:14 2009
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1647
Mon Aug 17 14:20:20 2009
Completed: ALTER DATABASE OPEN
Mon Aug 17 14:21:07 2009
Shutting down archive processes
Mon Aug 17 14:21:12 2009
ARCH shutting down
ARC2: Archival stopped



STANDBY:

Mon Aug 17 14:29:09 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 176160768
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 536870912
  control_files            = /opt/oracle/product/10.2.0/oradata/TESTMARK/control01.ctl, /opt/oracle/product/10.2.0/oradata/TESTMARK/control02.ctl, /opt/oracle/product/10.2.0/oradata/TESTMARK/control03.ctl
  db_file_name_convert     = MARKTEST, TESTMARK
  log_file_name_convert    = /opt/oracle/product/10.2.0/oradata/MARKTEST, /opt/oracle/product/10.2.0/oradata/TESTMARK
  db_block_size            = 8192
  __db_cache_size          = 343932928
  compatible               = 10.2.0.3.0
  log_archive_config       = DG_CONFIG=(MARKTEST,TESTMARK)
  log_archive_dest_1       = LOCATION=/opt/oracle/product/10.2.0/oradata/TESTMARK/ 
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=TESTMARK
  log_archive_dest_2       = SERVICE=MARKTEST LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=MARKTEST
  log_archive_dest_state_1 = ENABLE
  log_archive_dest_state_2 = ENABLE
  log_archive_max_processes= 30
  log_archive_format       = %t_%s_%r.arc
  fal_client               = TESTMARK
  fal_server               = MARKTEST
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /opt/oracle/product/10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  standby_file_management  = AUTO
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MARKTESTXDB)
  job_queue_processes      = 10
  background_dump_dest     = /opt/oracle/product/10.2.0/admin/MARKTEST/bdump
  user_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/udump
  core_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/cdump
  audit_file_dest          = /opt/oracle/product/10.2.0/admin/MARKTEST/adump
  db_name                  = MARKTEST
  db_unique_name           = TESTMARK
  open_cursors             = 300
  pga_aggregate_target     = 1669332992
PMON started with pid=2, OS id=12100
PSP0 started with pid=3, OS id=12102
MMAN started with pid=4, OS id=12104
DBW0 started with pid=5, OS id=12106
LGWR started with pid=6, OS id=12108
CKPT started with pid=7, OS id=12110
SMON started with pid=8, OS id=12112
RECO started with pid=9, OS id=12114
CJQ0 started with pid=10, OS id=12116
MMON started with pid=11, OS id=12118
Mon Aug 17 14:29:09 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=12120
Mon Aug 17 14:29:09 2009
starting up 1 shared server(s) ...
Mon Aug 17 14:29:23 2009
ALTER SYSTEM SET db_recovery_file_dest_size='4096000000' SCOPE=BOTH;
Mon Aug 17 14:29:35 2009
alter database mount standby database
Mon Aug 17 14:29:39 2009
Setting recovery target incarnation to 2
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=12142
ARC1 started with pid=17, OS id=12144
ARC2 started with pid=18, OS id=12146
ARC3 started with pid=19, OS id=12148
ARC4 started with pid=20, OS id=12150
ARC5 started with pid=21, OS id=12152
ARC6 started with pid=22, OS id=12154
ARC7 started with pid=23, OS id=12156
ARC8 started with pid=24, OS id=12158
ARC9 started with pid=25, OS id=12160
ARCa started with pid=26, OS id=12162
ARCb started with pid=27, OS id=12164
ARCc started with pid=28, OS id=12166
ARCd started with pid=29, OS id=12168
ARCe started with pid=30, OS id=12170
ARCf started with pid=31, OS id=12172
ARCg started with pid=32, OS id=12174
ARCh started with pid=33, OS id=12176
ARCi started with pid=34, OS id=12178
ARCj started with pid=35, OS id=12180
ARCk started with pid=36, OS id=12182
ARCl started with pid=37, OS id=12184
ARCm started with pid=38, OS id=12186
ARCn started with pid=39, OS id=12188
ARCo started with pid=40, OS id=12190
ARCp started with pid=41, OS id=12192
ARCq started with pid=42, OS id=12194
ARCr started with pid=43, OS id=12196
ARCs started with pid=44, OS id=12198
Mon Aug 17 14:29:40 2009
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCj: Archival started
ARCk: Archival started
ARCl: Archival started
ARCm: Archival started
ARCn: Archival started
ARCo: Archival started
ARCp: Archival started
ARCq: Archival started
ARCr: Archival started
ARCs: Archival started
ARCt: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Aug 17 14:29:40 2009
ARCg: Becoming the 'no FAL' ARCH
ARCg: Becoming the 'no SRL' ARCH
ARCg: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCh: Becoming the heartbeat ARCH
ARCh: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCi: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCj: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCk: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC0: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC2: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC3: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC4: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC5: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC6: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC7: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC8: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC9: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCa: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCb: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCc: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCd: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCe: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCf: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCl: Thread not mounted
Mon Aug 17 14:29:40 2009
ARC1: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCn: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCm: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCo: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCp: Thread not mounted
Mon Aug 17 14:29:40 2009
ARCq: Thread not mounted
Mon Aug 17 14:29:40 2009
Successful mount of redo thread 1, with mount id 3816169935
Mon Aug 17 14:29:40 2009
Physical Standby Database mounted.
Completed: alter database mount standby database
ARCt started with pid=45, OS id=12200
Mon Aug 17 14:44:13 2009
db_recovery_file_dest_size of 3906 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Re: New Data Guard, logs not shipping across [message #418736 is a reply to message #418577] Tue, 18 August 2009 07:27 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for the details. But expectation result not there.

Please swith one of redo log from primary database & then check alert log from primary and standby.

Please post the details from alert log

Thanks
Re: New Data Guard, logs not shipping across [message #419017 is a reply to message #418736] Wed, 19 August 2009 10:46 Go to previous messageGo to next message
Mark Baxter
Messages: 7
Registered: August 2009
Junior Member
gentlebabu wrote on Tue, 18 August 2009 14:27

Thanks for the details. But expectation result not there.

Please swith one of redo log from primary database & then check alert log from primary and standby.

Please post the details from alert log

Thanks


Thanks for the reply.

The primary was started with a normal "startup".

The standby was started with "startup mount" followed by "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;".

Two switches were performed on the primary using "ALTER SYSTEM SWITCH LOGFILE;"

These are the alert logs after that:

PRIMARY:

Wed Aug 19 17:22:01 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 243269632
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 536870912
  control_files            = /opt/oracle/product/10.2.0/oradata/MARKTEST/control01.ctl, /opt/oracle/product/10.2.0/oradata/MARKTEST/control02.ctl, /opt/oracle/product/10.2.0/oradata/MARKTEST/control03.ctl
  db_block_size            = 8192
  __db_cache_size          = 276824064
  compatible               = 10.2.0.3.0
  log_archive_dest_state_2 = ENABLE
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /opt/oracle/product/10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 4096000000
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MARKTESTXDB)
  job_queue_processes      = 10
  background_dump_dest     = /opt/oracle/product/10.2.0/admin/MARKTEST/bdump
  user_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/udump
  core_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/cdump
  audit_file_dest          = /opt/oracle/product/10.2.0/admin/MARKTEST/adump
  db_name                  = MARKTEST
  open_cursors             = 300
  pga_aggregate_target     = 1669332992
PMON started with pid=2, OS id=4459
PSP0 started with pid=3, OS id=4461
MMAN started with pid=4, OS id=4463
DBW0 started with pid=5, OS id=4465
LGWR started with pid=6, OS id=4467
CKPT started with pid=7, OS id=4469
SMON started with pid=8, OS id=4471
RECO started with pid=9, OS id=4473
CJQ0 started with pid=10, OS id=4475
MMON started with pid=11, OS id=4477
Wed Aug 19 17:22:02 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4479
Wed Aug 19 17:22:02 2009
starting up 1 shared server(s) ...
Wed Aug 19 17:22:02 2009
ALTER DATABASE   MOUNT
Wed Aug 19 17:22:06 2009
Setting recovery target incarnation to 2
Wed Aug 19 17:22:06 2009
Successful mount of redo thread 1, with mount id 3816344634
Wed Aug 19 17:22:06 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Aug 19 17:22:06 2009
ALTER DATABASE OPEN
Wed Aug 19 17:22:06 2009
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=4487
Wed Aug 19 17:22:06 2009
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=17, OS id=4489
Wed Aug 19 17:22:06 2009
ARC0: STARTING ARCH PROCESSES
Wed Aug 19 17:22:06 2009
Thread 1 opened at log sequence 68
  Current log# 1 seq# 68 mem# 0: /opt/oracle/product/10.2.0/oradata/MARKTEST/redo01.log
Successful open of redo thread 1
Wed Aug 19 17:22:06 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Aug 19 17:22:06 2009
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Wed Aug 19 17:22:06 2009
SMON: enabling cache recovery
Wed Aug 19 17:22:06 2009
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=18, OS id=4491
Wed Aug 19 17:22:07 2009
Successfully onlined Undo Tablespace 1.
Wed Aug 19 17:22:07 2009
SMON: enabling tx recovery
Wed Aug 19 17:22:07 2009
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=4495
Wed Aug 19 17:22:10 2009
Completed: ALTER DATABASE OPEN
Wed Aug 19 17:22:10 2009
db_recovery_file_dest_size of 3906 MB is 60.48% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 19 17:23:06 2009
Shutting down archive processes
Wed Aug 19 17:23:11 2009
ARCH shutting down
ARC2: Archival stopped
Wed Aug 19 17:23:12 2009
Thread 1 advanced to log sequence 69
  Current log# 2 seq# 69 mem# 0: /opt/oracle/product/10.2.0/oradata/MARKTEST/redo02.log
Wed Aug 19 17:27:38 2009
Thread 1 advanced to log sequence 70
  Current log# 3 seq# 70 mem# 0: /opt/oracle/product/10.2.0/oradata/MARKTEST/redo03.log



STANDBY:

Wed Aug 19 17:26:56 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 184549376
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 536870912
  control_files            = /opt/oracle/product/10.2.0/oradata/TESTMARK/control01.ctl, /opt/oracle/product/10.2.0/oradata/TESTMARK/control02.ctl, /opt/oracle/product/10.2.0/oradata/TESTMARK/control03.ctl
  db_file_name_convert     = MARKTEST, TESTMARK
  log_file_name_convert    = /opt/oracle/product/10.2.0/oradata/MARKTEST, /opt/oracle/product/10.2.0/oradata/TESTMARK
  db_block_size            = 8192
  __db_cache_size          = 335544320
  compatible               = 10.2.0.3.0
  log_archive_config       = DG_CONFIG=(MARKTEST,TESTMARK)
  log_archive_dest_1       = LOCATION=/opt/oracle/product/10.2.0/oradata/TESTMARK/ 
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=TESTMARK
  log_archive_dest_2       = SERVICE=MARKTEST LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=MARKTEST
  log_archive_dest_state_1 = ENABLE
  log_archive_dest_state_2 = ENABLE
  log_archive_max_processes= 30
  log_archive_format       = %t_%s_%r.arc
  fal_client               = TESTMARK
  fal_server               = MARKTEST
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /opt/oracle/product/10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 4096000000
  standby_file_management  = AUTO
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MARKTESTXDB)
  job_queue_processes      = 10
  background_dump_dest     = /opt/oracle/product/10.2.0/admin/MARKTEST/bdump
  user_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/udump
  core_dump_dest           = /opt/oracle/product/10.2.0/admin/MARKTEST/cdump
  audit_file_dest          = /opt/oracle/product/10.2.0/admin/MARKTEST/adump
  db_name                  = MARKTEST
  db_unique_name           = TESTMARK
  open_cursors             = 300
  pga_aggregate_target     = 1669332992
PMON started with pid=2, OS id=13774
PSP0 started with pid=3, OS id=13776
MMAN started with pid=4, OS id=13778
DBW0 started with pid=5, OS id=13780
LGWR started with pid=6, OS id=13782
CKPT started with pid=7, OS id=13784
SMON started with pid=8, OS id=13786
RECO started with pid=9, OS id=13788
CJQ0 started with pid=10, OS id=13790
MMON started with pid=11, OS id=13792
Wed Aug 19 17:26:57 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=13794
Wed Aug 19 17:26:57 2009
starting up 1 shared server(s) ...
Wed Aug 19 17:26:57 2009
ALTER DATABASE   MOUNT
Wed Aug 19 17:27:01 2009
Setting recovery target incarnation to 2
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=13801
ARC1 started with pid=17, OS id=13803
ARC2 started with pid=18, OS id=13805
ARC3 started with pid=19, OS id=13807
ARC4 started with pid=20, OS id=13809
ARC5 started with pid=21, OS id=13811
ARC6 started with pid=22, OS id=13813
ARC7 started with pid=23, OS id=13815
ARC8 started with pid=24, OS id=13817
ARC9 started with pid=25, OS id=13819
ARCa started with pid=26, OS id=13821
ARCb started with pid=27, OS id=13823
ARCc started with pid=28, OS id=13825
ARCd started with pid=29, OS id=13827
ARCe started with pid=30, OS id=13829
ARCf started with pid=31, OS id=13831
ARCg started with pid=32, OS id=13833
ARCh started with pid=33, OS id=13835
ARCi started with pid=34, OS id=13837
ARCj started with pid=35, OS id=13839
ARCk started with pid=36, OS id=13841
ARCl started with pid=37, OS id=13843
ARCn started with pid=39, OS id=13847
ARCm started with pid=38, OS id=13845
ARCo started with pid=40, OS id=13849
ARCp started with pid=41, OS id=13851
ARCq started with pid=42, OS id=13853
ARCr started with pid=43, OS id=13855
ARCs started with pid=44, OS id=13857
Wed Aug 19 17:27:03 2009
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCj: Archival started
ARCk: Archival started
ARCl: Archival started
ARCm: Archival started
ARCn: Archival started
ARCo: Archival started
ARCp: Archival started
ARCq: Archival started
ARCr: Archival started
ARCs: Archival started
ARCt: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Aug 19 17:27:03 2009
ARCf: Becoming the 'no FAL' ARCH
ARCf: Becoming the 'no SRL' ARCH
ARCf: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCg: Becoming the heartbeat ARCH
ARCg: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCh: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCi: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCj: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCk: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCl: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCn: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC0: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC1: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC2: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC3: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC4: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC5: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC6: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC7: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC8: Thread not mounted
Wed Aug 19 17:27:03 2009
ARC9: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCa: Thread not mounted
Wed Aug 19 17:27:03 2009
ARCb: Thread not mounted
Wed Aug 19 17:27:03 2009
Successful mount of redo thread 1, with mount id 3816359265
Wed Aug 19 17:27:03 2009
Physical Standby Database mounted.
Completed: ALTER DATABASE   MOUNT
Wed Aug 19 17:27:03 2009
ARCc: Thread not mounted
ARCt started with pid=45, OS id=13859
Wed Aug 19 17:27:27 2009
alter database recover managed standby database disconnect from session
Wed Aug 19 17:27:27 2009
Attempt to start background Managed Standby Recovery process (MARKTEST)
MRP0 started with pid=46, OS id=13877
Wed Aug 19 17:27:28 2009
MRP0: Background Managed Standby Recovery process started (MARKTEST)
Managed Standby Recovery not using Real Time Apply
 parallel recovery started with 2 processes
Media Recovery Waiting for thread 1 sequence 4
Wed Aug 19 17:27:34 2009
Completed: alter database recover managed standby database disconnect from session
Re: New Data Guard, logs not shipping across [message #419024 is a reply to message #419017] Wed, 19 August 2009 11:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>log_archive_dest_state_2 = ENABLE
above is from Primary, but no actual destination is specified similar to below

log_archive_dest_2 = SERVICE=MARKTEST LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

[Updated on: Wed, 19 August 2009 11:07]

Report message to a moderator

Re: New Data Guard, logs not shipping across [message #419029 is a reply to message #419024] Wed, 19 August 2009 11:13 Go to previous message
Mark Baxter
Messages: 7
Registered: August 2009
Junior Member
BlackSwan wrote on Wed, 19 August 2009 18:06
>log_archive_dest_state_2 = ENABLE
above is from Primary, but no actual destination is specified similar to below

log_archive_dest_2 = SERVICE=MARKTEST LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)



This in the init file for the primary:

LOG_ARCHIVE_CONFIG='DG_CONFIG=(MARKTEST,TESTMARK)'
LOG_ARCHIVE_DEST_1=
 'LOCATION=/opt/oracle/product/10.2.0/oradata/MARKTEST/ 
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=MARKTEST'
LOG_ARCHIVE_DEST_2=
 'SERVICE=TESTMARK LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=TESTMARK'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE


Which was based on this in the Oracle documentation:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm

DB_NAME=chicago
DB_UNIQUE_NAME=chicago
LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'
CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ctl'
LOG_ARCHIVE_DEST_1=
 'LOCATION=/arch1/chicago/ 
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=chicago'
LOG_ARCHIVE_DEST_2=
 'SERVICE=boston LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30


Is there something wrong with what I wrote? Perhaps I have screwed up the syntax somewhere?
Previous Topic: Dataguard on 10gR2
Next Topic: Can I Configure Dataguard using Network Address translation ?
Goto Forum:
  


Current Time: Thu Mar 28 20:44:01 CDT 2024