Home » Server Options » Data Guard » Queries arises while configuring DataGuard (Oralce 10g Hosted On HP-UX 11.11)
Queries arises while configuring DataGuard [message #533800] Thu, 01 December 2011 06:01 Go to next message
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.

Re: Queries arises while configuring DataGuard [message #533803 is a reply to message #533800] Thu, 01 December 2011 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Queries arises while configuring DataGuard [message #533814 is a reply to message #533803] Thu, 01 December 2011 07:07 Go to previous messageGo to next message
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
Re: Queries arises while configuring DataGuard [message #533815 is a reply to message #533814] Thu, 01 December 2011 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Queries arises while configuring DataGuard [message #534068 is a reply to message #533815] Fri, 02 December 2011 08:30 Go to previous messageGo to next message
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
Re: Queries arises while configuring DataGuard [message #534069 is a reply to message #534068] Fri, 02 December 2011 08:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Queries arises while configuring DataGuard [message #534076 is a reply to message #534068] Fri, 02 December 2011 08:50 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
The recovery is being started automatically by the Data Guard Broker.
Previous Topic: Instance Parameter chance in dataguard
Next Topic: How does Grid instantiate physical standby
Goto Forum:
  


Current Time: Thu Mar 28 05:23:57 CDT 2024