Home » Server Options » Data Guard » Problem creating a logical standby DB (10.1.0.4 Solaris )
Problem creating a logical standby DB [message #393631] Mon, 23 March 2009 15:06 Go to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

I followed the Oracle® Data Guard Concepts and Administration 10g Release 1 (10.1) document on how to create a logical standby DB. ( chapter 4 )

1. I created a physical standby DB - OK
2. I prepared the init.ora file changes for the logical standby as documented
3. shutdown the soon to be logica lstandby DB
4. created a logical control file copy from the primary and transferred to the standby site ( into the control files destinations )

ALTER DATABASE CREATE LOGICAL STANDBY CONTROLFILE AS '/tmp/boston.ctl';

5. I mounted the standby with the nre control file - ok

6. I issued : ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

Its hanging indefinitely

I tried canceling it and issued :

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

That seem to work , but then when I run the next command :

SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
ALTER DATABASE ACTIVATE STANDBY DATABASE
*
ERROR at line 1:
ORA-16228: Insufficient recovery for logical standby

Can someone help me troubleshoot/understand the problem ?

Thanks
Orna
Re: Problem creating a logical standby DB [message #393633 is a reply to message #393631] Mon, 23 March 2009 17:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can someone help me troubleshoot/understand the problem ?
I could only guess because of lack of details provided.

>1. I created a physical standby DB - OK
We have no proof this was completed correctly.
>2. I prepared the init.ora file changes for the logical standby
We have no proof this was completed correctly.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

The Posting Guidelines state

"Show us what you did (if you tried it yourself) and how Oracle responded (COPY & PASTE your SQL*Plus session), including errors and/or why the result is not what you want.
Do not describe, explain or report - show us!"
Re: Problem creating a logical standby DB [message #393744 is a reply to message #393633] Tue, 24 March 2009 04:31 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Alos; As per your error message.

ORA-16228: Insufficient recovery for logical standby 
Cause: Insufficient amount of recovery was run for logical standby instantiation. 
Action: Continue to recover the database using ALTER DATABASE RECOVER MANAGED STANDBY DATABASE.  


Babu
Re: Problem creating a logical standby DB [message #393759 is a reply to message #393633] Tue, 24 March 2009 05:12 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

I just wanted to post the solution for my problem
( my thread in the OTM forum )

http://forums.oracle.com/forums/thread.jspa?forumID=61&threadID=875706

Thanks for your reply
Orna
Re: Problem creating a logical standby DB [message #393760 is a reply to message #393759] Tue, 24 March 2009 05:18 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for your feedback.

Quote:
>1. I created a physical standby DB - OK
We have no proof this was completed correctly.
>2. I prepared the init.ora file changes for the logical standby
We have no proof this was completed correctly.


We already asked about your init parameter.

babu
Re: Problem creating a logical standby DB [message #393763 is a reply to message #393759] Tue, 24 March 2009 05:24 Go to previous message
Orna
Messages: 62
Registered: November 2008
Member
I know

the strange thing is that my pfile was perfectly ok, it was just when I converted it to an spfile - it got distorted somehow

So when I verified my init.ora it was ok. it was just by chance that I took a look at my spfile.
Once I started with pfile and stayed with pfile all worked ok

Once I figure out why my spfile looks different then my pfile I will post a followup

Thanks
Orna
Previous Topic: dat guard
Next Topic: Setting up a disaster server
Goto Forum:
  


Current Time: Thu Mar 28 06:04:01 CDT 2024