Re: ORA-01666: control file is for a standby database

From: sundar mahadevan <sundarmahadevan82@xxxxxxxxx>

To: David Barbour <david.barbour1@xxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx

Date: Thu, 10 Feb 2011 15:54:52 -0500

Hi David,
Thanks for your reply. As per hemanth's comment, I did not open the
database. After recovery is complete, I give ALTER DATABASE RECOVER MANAGED
STANDBY DATABASE DISCONNECT FROM SESSION; and immediately I see standby redo
logs complain about missing redo logs. I do not yet have a working physical
standby. Can you please send me the link of Herman's document.
On Wed, Feb 9, 2011 at 5:44 PM, David Barbour <david.barbour1@xxxxxxxxx>wrote:
> Check Herman's doc on the transition from a physical standby to a logical
> standby.
>
> Of particular note is the instruction:
>
> SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY db_name;
>
> For db_name, specify a database name that is different from the primary
> database to identify the new logical standby database.
>
> I'm also wondering if you've properly configured your primary (and standby)
> initialization files. Did you successfully run this as a physical standby
> first?
>
>
> On Wed, Feb 9, 2011 at 4:20 PM, sundar mahadevan <
> sundarmahadevan82@xxxxxxxxx> wrote:
>
>> Hi Hemant/David,
>> Thanks for your replies. I am using Oracle® Data Guard Concepts and
>> Administration 11.2 as a reference. After the complete recovery in mount
>> mode, when i enter ALTER DATABASE RECOVER TO LOGICAL STANDBY <primary
>> DBname>; I get ORA-16136: Managed Standby Recovery not active with
>> ORA-00313/ORA-00312/ORA-27037 errors in alert log file complaining about
>> missing redo logs. Can you please tell me when does the tempfiles and
>> redologs get created. Am i missing anything on my parameters?
>>
>>
>> On Wed, Feb 9, 2011 at 1:14 PM, David Barbour
>> <david.barbour1@xxxxxxxxx>wrote:
>>
>>> If you're objective is to first create a physical standby, you did okay
>>> through the backup process for the database, but NOT for the controlfile.
>>> Additionally you don't need to set dbid and recover, let RMAN do it for you.
>>>
>>> Check out the 9i RMAN users guide chapter 13 - Creating a Standby
>>> Database with RMAN. I KNOW it's 9i, but it's still the best basic primer on
>>> how to do this I've seen.
>>>
>>> http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/title.htm
>>>
>>>
>>>
>>>
>>> On Wed, Feb 9, 2011 at 11:17 AM, sundar mahadevan <
>>> sundarmahadevan82@xxxxxxxxx> wrote:
>>>
>>>> Hi All,
>>>> I would like to make my previous email short. I am trying to implement
>>>> logical standby. First I start off with creating a physical standby with
>>>> rman. After a complete recovery, do I open the database with noresetlogs or
>>>> with resetlogs? If I try to open the database with resetlogs, I get
>>>> ORA-01666: control file is for a standby database. On one mos note, it said
>>>> alter database open resetlogs would create the redo log files (After the
>>>> complete recovery, I do not have tempfile and redo logs created). According
>>>> to note 601835.1, the redo log errors can be safely ignored on physical
>>>> standby. So when do the redo logs get created ? What should I do now to
>>>> eliminate this error. Oracle support is taking too long to respond and i
>>>> need to get this working soon. Thanks a ton for all your help.
>>>>
>>>>
>>>> On Tue, Feb 8, 2011 at 5:28 PM, sundar mahadevan <
>>>> sundarmahadevan82@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Group,
>>>>> Greetings. I am trying to setup a logical dataguard on 11.2.0.2 (SLES
>>>>> 11 x86_64). Initially I am creating the physical standby with rman hot
>>>>> backup from primary. I followed the procedure from note *469493.1 *to
>>>>> create the physical standby. The following are the steps:
>>>>>
>>>>>
>>>>> Connect to primary and crosscheck backup/archivelogs:
>>>>> delete expired backup and archivelogs
>>>>> Connect to primary and take rman backup:
>>>>> command used for backup on primary:
>>>>> run {
>>>>> set command id to 'rman';
>>>>> backup database plus archivelog;
>>>>> sql 'alter system switch logfile';
>>>>> backup archivelog from time 'sysdate -3/24';
>>>>> backup current controlfile for standby;
>>>>> }
>>>>>
>>>>> Rman Restore Physical Standby Database:
>>>>> startup nomount;
>>>>> set dbid=2225084209
>>>>> sql 'alter database mount standby database';
>>>>> restore database;
>>>>> exit
>>>>>
>>>>> Find current redo log sequence on Primary Database:
>>>>> sqlplus / as sysdba
>>>>> recover standby database ;
>>>>> enter all archivelogs and the current redo log sequence from primary
>>>>> and finally i get Media recovery complete.
>>>>> At this point I do not have tempfile/redo logs created but the redo
>>>>> logs missing error was reported as soon as i mounted the physical standby
>>>>> database with "sql 'alter database mount standby database'; before
>>>>> restore"
>>>>>
>>>>> now do I open the database with reset logs or no resetlogs.
>>>>> If I try to open the database with noresetlogs, the tempfile gets
>>>>> created but not the redo logs. If I try to open the database with
>>>>> resetlogs,
>>>>> I get ORA-01666: control file is for a standby database. On one mos note,
>>>>> it
>>>>> said alter database open resetlogs would create the redo log files.
>>>>> According to note 601835.1, the redo log errors can be safely ignored on
>>>>> physical standby. So when do the redo logs get created when I go for a
>>>>> logical standby creation. What should I do now to eliminate this error.
>>>>> Oracle support is taking too long to respond and i need to get this
>>>>> working
>>>>> soon. Thanks a ton for all your help.
>>>>>
>>>>>
>>>>
>>>
>>
>