on 01-22-2011 2:36 PM
Dear all,
When i am tryng to synchronize STANDBY DB i am hit with an following error..........
All my dataguard configuration seems to be valid as tnsping is happening between 2 systems successfully.
However i just also wanted to update that this system was already in runnning & due to some restarts of STANDBY DB
synchronization is lost & old logs are not available in the system & as a standarad process i restored online DB backup from primary to STANDBY
mounted standby databse
applied logs
cancelled media recovery
RECOVER DATABASE MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
on primary database;
alter system archive log current
finally when i run the above command for shipping the my standby is sucessfuly waiting for log from primary
but appreanly the log is not gettting shipped.. the following are the below lines from alert log..
-
Dump file g:\oracle\omp\saptrace\background\omp_mrp0_49568.trc
Sat Jan 22 19:32:33 2011
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 8 - type 8664, 8 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:10193M/16383M, Ph+PgF:48492M/56136M
Instance name: omp
Redo thread mounted by this instance: 1
Oracle process number: 21
Windows thread id: 49568, image: ORACLE.EXE (MRP0)
SERVICE NAME:() 2011-01-22 19:32:33.812
SESSION ID:(499.5) 2011-01-22 19:32:33.812
2011-01-22 19:32:33.812 64302 kcrr.c
MRP0: Background Managed Standby Recovery process started
2011-01-22 19:32:38.843 1201 krsm.c
Managed Recovery: Initialization posted.
2011-01-22 19:32:38.843 64302 kcrr.c
Managed Standby Recovery not using Real Time Apply
Recovery target incarnation = 2, activation ID = 1449641945
Influx buffer limit = 10000 min(50% x 759936, 10000)
Successfully allocated 7 recovery slaves
Using 20 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1304520069 logseq 17910 block 2
2011-01-22 19:32:44.109
Media Recovery add redo thread 1
2011-01-22 19:32:44.109 1201 krsm.c
Managed Recovery: Active posted.
2011-01-22 19:32:44.281 64302 kcrr.c
Clearing online redo logfile 1 G:\ORACLE\OMP\ORIGLOGA\LOG_G11M1.DBF
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: 'G:\ORACLE\OMP\ORIGLOGA\LOG_G11M1.DBF'
Error 19527 creating/clearing online redo logfile 1
2011-01-22 19:32:44.328 64302 kcrr.c
Clearing online redo logfile 1 complete
2011-01-22 19:32:44.343 64302 kcrr.c
Media Recovery Waiting for thread 1 sequence 17910
thanks,
rahul
Excuse me.....For my above update at wrong place.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Duplicate Post
Suggest you to close this thread
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul,
I just checked in my system..even I do get the same ORA 19527 messages, however logs are being shipped & applied without any issue.....try creating standby redo logs & real time apply.
Thank You,
Salman Qayyum
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello salman,
Thank you for the information provided..yes i have checked complete alert log of my file from july 2010 when i have STANDBY DB Configured for the fist time... the error seems to be generic one...
I am trying to understand what could be the problem..when my tnsping is happening successfully between 2 systems..
please share any trouble shoot...
How do i create stanndby redologs...is it a archive log ? ...if yes after successful apply of last log STANDBY i did "alter system archive log current"
thanks,
rahul
Edited by: Rahul on Jan 24, 2011 9:46 AM
Hi Rahul,
If the archive logs are not being shipped to the standby database,
1. Make sure that the log_archive_dest_state_2 = enable
2. Make sure that the destination log_archive_dest_2 = 'SERVICE = sid_dr" or whatever is the service name u have configured in the tnsnames.ora
3. See the tnsnames.ora is configured accurately in both the locations i.e., $ORACLE_HOME/network/admin & /sapmnt/SID/profile/oracle
4. tnsping works with both the users (orasid & sid adm) in case if the db is started with sidadm
5. Start the recovery process on DR using the alter database recover managed.....
If all the above are configured correctly...provide the alert_sid.log of primary & also the arch0 trace files
For Stanby logs....
Its required if u want to configure realtime apply...
1. Capture the number of Redo Log groups and their size at the primary database
select group#, bytes/1024/1024 "MB" from v$log;
2. Configure Standby Redo Logs for the primary database
alter database add standby logfile GROUP 5 ('/oracle/<DB_SID>/origlogA/stbylog_g15m1.dbf','/oracle/<DB_SID>/mirrlogA/stbylog_g15m2.dbf') size XXXM;
alter database add standby logfile GROUP 6 ('/oracle/<DB_SID>/origlogB/stbylog_g16m1.dbf','/oracle/<DB_SID>/mirrlogB/stbylog_g16m2.dbf') size XXXM;
alter database add standby logfile GROUP 7 ('/oracle/<DB_SID>/origlogA/stbylog_g17m1.dbf','/oracle/<DB_SID>/mirrlogA/stbylog_g17m2.dbf') size XXXM;
alter database add standby logfile GROUP 8 ('/oracle/<DB_SID>/origlogB/stbylog_g18m1.dbf','/oracle/<DB_SID>/mirrlogB/stbylog_g18m2.dbf') size XXXM;
There should be at least one more standby redo log group as redo log groups are in place. The size of the standby redo logs must be equal to the size of the redo log files.
3. Configure Standby Redo Logs for the standby database
4. Verify the standby redo logs were created
select group#,type,member from v$logfile;
5. Specify which databases are part of the Oracle Data Guard Configuration
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(<DB_SID>_HQ,<DB_SID>_DR)' scope=both;
For both primary & DR
6. Add the "VALID_FOR" section to LOG_ARCHIVE_DEST_1
in primary DB & DR
alter system set LOG_ARCHIVE_DEST_1='LOCATION=/oracle/<DB_SID>/oraarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=<DB_SID>_HQ';
alter system set LOG_ARCHIVE_DEST_2='SERVICE=<DB_SID>_DR LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=<DB_SID>_DR';
7. Start Real Time Apply
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
8. Verfify that Real Time Apply is used
SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS;
Thanks,
Salman
Hello salman,
thank you for the update provided..
All my data guard configuration settings seems to be correct,
I have checked step by step.. this is pretty old system running successfully..
However the following the stattus
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
-
-
ARCH CONNECTED
ARCH CONNECTED
MRP0 WAIT_FOR_LOG
SQL> SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;
PROCESS CLIENT_P SEQUENCE# STATUS
-
-
-
-
ARCH ARCH 0 CONNECTED
ARCH ARCH 0 CONNECTED
MRP0 N/A 18007 WAIT_FOR_LOG
When i run the below statment in primary
select status, Error from V$ARCHIVE_DEST where dest_id=2;
VALID
With the bvaove statment understood my dataguard is successfully configured...
tnsping between PRIMARY & STANDBY is also successful
If there are any known issues please why the logs are being shipped please hsare
thanks,
rahul
Hi Rahul,
Please check why RFS process is not started in DR server??...thats the reason logs are not being transfered to DR system
However the following the stattus
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
-
-
ARCH CONNECTED
ARCH CONNECTED
MRP0 WAIT_FOR_LOG
Please check the arc0 trace file in your primary system.......
RFS process is running in my system.....
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
-
-
ARCH CONNECTED
ARCH CLOSING
RFS IDLE
MRP0 APPLYING_LOG
RFS IDLE
Thanks
Salman
Hello salman,
I have traced the arc1 file..& found few issues .. please find the log below.. when i did a tnsping to OMP_STBY.WORLD
it was successful
but one thing i wanted to address when LOG_ARCHIVE_DEST_2 paremeter was set for target system path ORAARCH
conection reopen is not set 1800 seconds , will it cause an issue for RFS to fail..
if i bounce primary now system will come up with new value LOG_ARCHIVE_DEST_2 =path reopen 1800
with that resolve the issue please let me know..
Dump file g:\oracle\omp\saptrace\background\omp_arc1_6348.trc
Sun Dec 05 14:33:12 2010
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:14075M/24565M, Ph+PgF:53839M/63654M
Instance name: omp
Redo thread mounted by this instance: 1
Oracle process number: 30
Windows thread id: 6348, image: ORACLE.EXE (ARC1)
SERVICE NAME:() 2010-12-05 14:33:12.282
SESSION ID:(498.3) 2010-12-05 14:33:12.282
Redo shipping client performing standby login
2010-12-05 14:33:12.407 68145 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
2010-12-06 10:10:17.352
RFS network connection lost at host 'OMP_STBY.WORLD'
Fail to ping standby 'OMP_STBY.WORLD', error = 3135
2010-12-06 10:10:17.352 64302 kcrr.c*ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
2010-12-06 10:10:17.352 64302 kcrr.c
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2010-12-06 10:10:17.352 64302 kcrr.c
PING[ARC1]: Error 3135 when pinging standby OMP_STBY.WORLD.
2010-12-06 10:10:17.352 62570 kcrr.c
kcrrfail: dest:2 err:3135 force:0 blast:1
2010-12-06 10:15:17.393
Redo shipping client performing standby login
2010-12-06 10:15:17.518 68145 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
2010-12-08 13:00:50.971
RFS network connection lost at host 'OMP_STBY.WORLD'
Fail to ping standby 'OMP_STBY.WORLD', error = 3135
2010-12-08 13:00:50.971 64302 kcrr.c
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
2010-12-08 13:00:50.971 64302 kcrr.c
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2010-12-08 13:00:50.971 64302 kcrr.c
PING[ARC1]: Error 3135 when pinging standby OMP_STBY.WORLD.
2010-12-08 13:00:50.971 62570 kcrr.c
kcrrfail: dest:2 err:3135 force:0 blast:1
2010-12-08 13:05:50.982
Redo shipping client performing standby login
2010-12-08 13:05:51.107 68145 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
2010-12-08 14:19:15.364
RFS network connection lost at host 'OMP_STBY.WORLD'
Fail to ping standby 'OMP_STBY.WORLD', error = 3135
2010-12-08 14:19:15.364 64302 kcrr.c
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
2010-12-08 14:19:15.364 64302 kcrr.c
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2010-12-08 14:19:15.364 64302 kcrr.c
PING[ARC1]: Error 3135 when pinging standby OMP_STBY.WORLD.
2010-12-08 14:19:15.364 62570 kcrr.c
kcrrfail: dest:2 err:3135 force:0 blast:1
2010-12-08 14:24:15.360
Redo shipping client performing standby login
2010-12-08 14:24:15.922 68145 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
2010-12-08 19:39:27.351
RFS network connection lost at host 'OMP_STBY.WORLD'
Fail to ping standby 'OMP_STBY.WORLD', error = 3113
2010-12-08 19:39:27.351 64302 kcrr.c
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
2010-12-08 19:39:27.351 64302 kcrr.c
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2010-12-08 19:39:27.351 64302 kcrr.c
PING[ARC1]: Error 3113 when pinging standby OMP_STBY.WORLD.
2010-12-08 19:39:27.351 62570 kcrr.c
kcrrfail: dest:2 err:3113 force:0 blast:1
2010-12-08 19:44:27.378
Redo shipping client performing standby login
2010-12-08 19:44:27.472 68145 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
thanks
rahul
Hi Rahul,
but one thing i wanted to address when LOG_ARCHIVE_DEST_2 paremeter was set for target system path ORAARCH
conection reopen is not set 1800 seconds , will it cause an issue for RFS to fail..
Log_archive_dest_2 in primary database should refer to service name in tnsnames.ora of the DR system.....Did u check this??
log_archive_dest_2='SERVICE=<SERVICE_NAME> ....."
Thanks,
Salman
Yes,,, thats the main reason why log shipping is not happening & after evaluating arc1 trace files i could manage to trace the issue.
log_archive_dest_2='SERVICE=<SERVICE_NAME> ....." is set correct but connection reopen is not set to 1800 seconds.
after adding reopen = 1800 for the same parameter in primary issue got resolved. & RFS service is started.
Now what i wanted to clear is log_archive_dest_2='SERVICE=<SERVICE_NAME> reopen = 1800, here 1800 i seconds or minutes which is set to log_archive_dest_2
any ideas, Please conform
thanks,
rahul
Hi,
We are having the same issue with archive shipping. The sync between and logical standby on windows 2003 32-bit went stale. When I check the status from V$ARCHIVE_DEST, log_archive_dest_2, it is showing an error----"ORA-03113: end-of-file on communication channel". I started to enable the log shipping from primary but it doesn't help. All we find in the primary db alert.log are as below. We are on oracle 11.1.0.7 on windows 2003 32-bit. The only recent change we did was to apply latest windows patches.
-
Mon Jul 18 12:45:44 2011
Archived Log entry 388707 added for thread 1 sequence 203132 ID 0x30b0d0b2 dest 1:
Mon Jul 18 12:47:37 2011
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;
Mon Jul 18 13:46:22 2011
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Mon Jul 18 13:46:22 2011
LNS1 started with pid=38, OS id=2456
Mon Jul 18 13:46:25 2011
Thread 1 advanced to log sequence 203134 (LGWR switch)
Current log# 1 seq# 203134 mem# 0: E:\ORACLE11G\ORADATA\NAMP\REDO01.LOG
Mon Jul 18 13:46:26 2011
Archived Log entry 388708 added for thread 1 sequence 203133 ID 0x30b0d0b2 dest 1:
Mon Jul 18 13:46:27 2011
ARC4: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
ARC4: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Errors in file D:\ORACLE11G\diag\rdbms\namp\namp\trace\namp_arc4_5288.trc:
ORA-03113: end-of-file on communication channel
FAL[server, ARC4]: FAL archive failed, see trace file.
Errors in file D:\ORACLE11G\diag\rdbms\namp\namp\trace\namp_arc4_5288.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Mon Jul 18 13:47:59 2011
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;
-
Everything went fine since 6 months but this issue came up all of a suddenly. I am able to ping and connect to primary<->standby using sqlplus/tnsping.
I tried to put the "REOPEN=120" option for log_archive_dest_2 but it didn't worked. Let me know if you have any solutions.
Thanks,
Venkat
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.