cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-19527: physical standby redo log must be renamed _ issue in standby DB

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Excuse me.....For my above update at wrong place.

Regards,

Nick Loy

Former Member
0 Kudos
Duplicate Post

Suggest you to close this thread
Former Member
0 Kudos

Where is it duplicated ?

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Rahul,

Were u able to fix this??

Thanks,

Salman

Former Member
0 Kudos

Hi salman,

Apparently there is no luck....I couldn't make out why my RFS service is not getting triggered.

If i bounce my Primary database will there be any luck.

thanks,

rahul..

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

the minimum number of seconds before the archiver processes (ARCn) or the log writer process (LGWR) should try again to access a previously failed destination

Regards

Vinod

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi ,

I rememeber , i was troubleshooting this with pwdsid.ora file.

There should be a file in Oracle/SID/102/dbs/pwdsid.ora

Copy this file from source and paste it in target system..this should synchronize the systems....

take a backup existing file before overwrite.

Thanks,

Rahul

Former Member
0 Kudos

Hi,

I don't think its a password file issue. Everything was working fine since 4 months. This started all of a sudden. I suspect its network issue but don't have much to trouble shoot.

Thanks,