OraFAQ Forum: Data Guard » Queries arises while configuring DataGuard

Home » Server Options » Data Guard » Queries arises while configuring DataGuard (Oralce 10g Hosted On HP-UX 11.11)

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

Queries arises while configuring DataGuard [message #533800]

Thu, 01 December 2011 06:01

abhi_sri
Messages: 20
Registered: September 2010
Location: India

Junior Member

Hello,

I have created dataguard between two intances hosted in two diffrent servers. I have done switchover from primay to standby & then again standby to primary with the help of DGMGRL utility.
I have few questions in my mind which I want to ask:

1- When I done switchover to primary & trying to open standby database in readonly mode it was giving below error-

ORA-01154: database busy. Open, close, mount, and dismount not allowed now

Why this error was coming ?

2- As I was not able to open standby database in read only mode, I have excuted below command-

alter database recover managed standby database disconnect from session;

which return an error as-

ORA-01153: an incompatible media recovery is active

After this I have executed-

alter database recover managed standby database cancel;

which executed successfully.

& then after standby database open in read only mode.

Why above error was coming ?

3- After this I had tried to check the checkpoint_change# & controlfile_change# from primary database and result shows both number were diffrent.

Why they are not matching ?

Thanks in advance for all your favours.

Report message to a moderator

Re: Queries arises while configuring DataGuard [message #533803 is a reply to message #533800]

Thu, 01 December 2011 06:17

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-01154: database busy. Open, close, mount, and dismount not allowed now
 *Cause: Some operation is in progress that expects the opened/mounted state
           of this instance to remain the same.
 *Action: Wait for the operation to complete then retry. If attempting to
           do a shutdown, SHUTDOWN ABORT will work.  If this is a shutdown
         of a standby database that is operating in NO DATA LOSS mode, you
         must shutdown the primary database first.

ORA-01153: an incompatible media recovery is active
 *Cause: Attempted to start an incompatible media recovery or open resetlogs
         during media recovery or RMAN backup . Media recovery sessions
         are incompatible if they attempt to recover the same data file.
         Incomplete media recovery or open resetlogs is incompatible with
         any media recovery. Backup or restore by RMAN is incompatible
         with open resetlogs
 *Action: Complete or cancel the other media recovery session or RMAN backup

Regards
Michel

Report message to a moderator

Re: Queries arises while configuring DataGuard [message #533814 is a reply to message #533803]

Thu, 01 December 2011 07:07

abhi_sri
Messages: 20
Registered: September 2010
Location: India

Junior Member

Hello Michel,

Thank for the reply. What I got is when I was opening a read only database at that time some activity might be some kind of media recovery was going on. Which was stopping the database to open it in read only mode.
Now if I am thinking in right way then which kind of recovery was going on & what was the puspose of it. Because when I check log sequence with the help of archive log list, the current log sequence were same in both production & in standby.

Thanks in Advance

Report message to a moderator

Re: Queries arises while configuring DataGuard [message #533815 is a reply to message #533814]

Thu, 01 December 2011 07:14

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must stop the current recovery going on an the standby database before being able to open it in read-only mode:
alter database recover managed standby database cancel;

Regards
Michel

Report message to a moderator

Re: Queries arises while configuring DataGuard [message #534068 is a reply to message #533815]

Fri, 02 December 2011 08:30

abhi_sri
Messages: 20
Registered: September 2010
Location: India

Junior Member

Hello Michel,

Sorry for the late reply. Just after switchover when I am opening standby database in read only mode, which kind of recovery is going on & why this recovery started implicitly.

Thanks In Advance
Abhishek

Report message to a moderator

Re: Queries arises while configuring DataGuard [message #534069 is a reply to message #534068]

Fri, 02 December 2011 08:34

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know what you did and got and in which state you are/were.
Show us: copy and paste.

Regards
Michel

Report message to a moderator

Re: Queries arises while configuring DataGuard [message #534076 is a reply to message #534068]

Fri, 02 December 2011 08:50

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

The recovery is being started automatically by the Data Guard Broker.

Report message to a moderator

Previous Topic:	Instance Parameter chance in dataguard
Next Topic:	How does Grid instantiate physical standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:17:48 CST 2025