OraFAQ Forum: Data Guard » ORA-01156: recovery in progress may need access to files

Home » Server Options » Data Guard » ORA-01156: recovery in progress may need access to files

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01156: recovery in progress may need access to files [message #180850]

Wed, 05 July 2006 08:47

tx_oradba
Messages: 2
Registered: July 2006
Location: Texas

Junior Member

Hello,
I'm in the process of creating a phy. standby and everything works fine till I try to create the standby redo logs, when I'm getting this ORA-01156 error. I've already created the SRL on the primary. Not sure what I'm doing wrong...any help is appreciated.

Thanks in advance,
TX.

Report message to a moderator

Re: ORA-01156 - Fixed [message #180859 is a reply to message #180850]

Wed, 05 July 2006 09:31

tx_oradba
Messages: 2
Registered: July 2006
Location: Texas

Junior Member

Hello,
Just found out that in 10g duplicating a target database for standby, recovers it, mounts it and places the standby in mananged recovery mode. So, I cancelled the managed recovery and then it let me create the SRLs.

Thanks,
TX.

Report message to a moderator

Re: ORA-01156 - Fixed [message #185907 is a reply to message #180859]

Fri, 04 August 2006 03:47

angelsliu
Messages: 23
Registered: July 2006

Junior Member

pls send your alert

Report message to a moderator

Re: ORA-01156 - Fixed [message #197503 is a reply to message #180859]

Wed, 11 October 2006 08:54

akshaykb1
Messages: 1
Registered: September 2006
Location: Nashville, TN

Junior Member

Hi TX,

You just solved my problem bro. thanks for the tip. I was trying to drop the standby logs and it was keep giving me the same error you were getting. I cancel the recover managed and now able to drop the standby logfiles. Thank for the tip

Akshaykb1

Report message to a moderator

Previous Topic:	oracle broker notes
Next Topic:	Heartbeat failed to connect to standby 'DG2'. Error is 1031

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 10:53:54 CST 2025