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 |
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 #418001 is a reply to message #417797] |
Wed, 12 August 2009 08:07 |
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 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 #418009 is a reply to message #417842] |
Wed, 12 August 2009 08:30 |
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 |
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 #418577 is a reply to message #417765] |
Mon, 17 August 2009 07:52 |
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 #419017 is a reply to message #418736] |
Wed, 19 August 2009 10:46 |
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 #419029 is a reply to message #419024] |
Wed, 19 August 2009 11:13 |
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?
|
|
|
Goto Forum:
Current Time: Sun Dec 22 23:03:22 CST 2024
|