Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member
Not what you were looking for? View more on this topic or Ask a question