OraFAQ Forum: Data Guard » Problem creating a logical standby DB

Home » Server Options » Data Guard » Problem creating a logical standby DB (10.1.0.4 Solaris )

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

Problem creating a logical standby DB [message #393631]

Mon, 23 March 2009 15:06

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

Report message to a moderator

Re: Problem creating a logical standby DB [message #393633 is a reply to message #393631]

Mon, 23 March 2009 17:10

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!"

Report message to a moderator

Re: Problem creating a logical standby DB [message #393744 is a reply to message #393633]

Tue, 24 March 2009 04:31

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

Report message to a moderator

Re: Problem creating a logical standby DB [message #393759 is a reply to message #393633]

Tue, 24 March 2009 05:12

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

Report message to a moderator

Re: Problem creating a logical standby DB [message #393760 is a reply to message #393759]

Tue, 24 March 2009 05:18

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

Report message to a moderator

Re: Problem creating a logical standby DB [message #393763 is a reply to message #393759]

Tue, 24 March 2009 05:24

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

Report message to a moderator

Previous Topic:	dat guard
Next Topic:	Setting up a disaster server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 13:10:22 CST 2024