OraFAQ Forum: Data Guard » Logical Standby Database

Home » Server Options » Data Guard » Logical Standby Database (oracle 10g R2 Windows 2003)

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

Logical Standby Database [message #335167]

Mon, 21 July 2008 05:17

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi

I m creating the logical standby database using rman. I have successfully restore the database using
========================================
DUPLICATE TARGET DATABASE FOR STANDBY;
========================================

but while opening the database i facing some problem

===========================================
SQL> ALTER DATABASE mount standby database;
Database altered.

SQL> ALTER DATABASE GUARD ALL;

Database altered.

SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01666: control file is for a standby database

==========================================================

Kindly suggest

Report message to a moderator

Re: Logical Standby Database [message #335183 is a reply to message #335167]

Mon, 21 July 2008 06:09

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Kindly Help

Report message to a moderator

Re: Logical Standby Database [message #335185 is a reply to message #335183]

Mon, 21 July 2008 06:36

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

Senior Member
Account Moderator

Kindly be patient, you have posted your question less than an hour ago.
You can also pick up your phone, call Oracle ad pay for immediate answer.

Regards
Michel

Report message to a moderator

Re: Logical Standby Database [message #335187 is a reply to message #335185]

Mon, 21 July 2008 06:41

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

sorry

Report message to a moderator

Re: Logical Standby Database [message #335189 is a reply to message #335187]

Mon, 21 July 2008 06:46

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

Senior Member
Account Moderator

I don't know much for logical standby but it seems to me that duplicate command is for physical standby only.

Regards
Michel

Report message to a moderator

Re: Logical Standby Database [message #335191 is a reply to message #335189]

Mon, 21 July 2008 06:54

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

hi

can u please provide the link for creating the logical standby database using RMAN because doc which i am using nothing is mentioned weather it is logical or physical
==========================================================================================
http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm#1656
==========================================================================================

Thanks & Regards

Tarun Mittal

Report message to a moderator

Re: Logical Standby Database [message #335195 is a reply to message #335191]

Mon, 21 July 2008 07:04

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

Senior Member
Account Moderator

As you are using a 10.2 database you should refer to 10.2 documentation and not 9.2 one.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ls.htm#g105412

Regards
Michel

Report message to a moderator

Re: Logical Standby Database [message #335403 is a reply to message #335195]

Tue, 22 July 2008 01:41

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Thanks for providing the links but this doc not contain how to create logical standby thru Rman

kindly suggest

Report message to a moderator

Re: Logical Standby Database [message #335429 is a reply to message #335403]

Tue, 22 July 2008 03:09

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

Senior Member
Account Moderator

No, this is what I said, I don't think this is possible, RMAN is for physical standby.

Regards
Michel

Report message to a moderator

Previous Topic:	Ora-00326
Next Topic:	archived log files not applied to standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 18:28:52 CST 2025