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

From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Wed, 9 Feb 2011 12:17:11 -0500
Message-ID: <AANLkTinFZ9qTf+hXipEA=JC0cWjaSt2cN1T==9aCzyH4_at_mail.gmail.com>

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_at_gmail.com> 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.
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 09 2011 - 11:17:11 CST