Re: Controlfile problem with standby database ?!

From: Andreas Jung <ajung_at_sz-sb.de>
Date: 18 Feb 1999 06:18:37 GMT
Message-ID: <7agbbt$h7d$1@hades.rz.uni-sb.de>

Horace Chow <horacecw_at_netvigator.com> wrote:
> Andreas,

> There is no need to shutdown the database and mountup it again. Try
> the following steps :

> 1. Copy the standby controlfile to the DR machine.
> 2. STARTUP NOMOUNT
> 3. ALTER DATABASE MOUNT STANDBY DATABASE EXCLUSIVE
> 4. Applying the archived redo log ..
> 5. ALTER DATABASE ACTIVATE STANDBY DATABASE
> 5. SHUTDOWN IMMEDIATE
> 6. STARTUP

> By the way, I have a suggestion that it is better to generate the
> standby controlfile at the end of 'end backup' command. Please try it
> and leave some comments.

It does not work :-<

SVRMGR> onnect internal
Connected to an idle instance.
SVRMGR> startup nomount
ORACLE instance started.

Total System Global Area      17928808 bytes
Fixed Size                       39808 bytes
Variable Size                 11171560 bytes
Database Buffers               6553600 bytes
Redo Buffers                    163840 bytes

SVRMGR> alter database mount standby database; Statement processed.
SVRMGR> alter database activate standby database; alter database activate standby database *
ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: '/ora/lccd01/oradata/lccd/system01.dbf' SVRMGR> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup
ORACLE instance started.

Total System Global Area      17928808 bytes
Fixed Size                       39808 bytes
Variable Size                 11171560 bytes
Database Buffers               6553600 bytes
Redo Buffers                    163840 bytes

ORA-01666: controlfile is for a standby database

I also followed your advice to generate the standby controlfile at the end of the backup procedure but without success.

Any more ideas ?

Andreas

                                _\\|//_
                               (' O-O ')
------------------------------ooO-(_)-Ooo--------------------------------------

Andreas Jung, Saarbrücker Zeitung Verlag und Druckerei GmbH Saarbrücker Daten-Innovations-Center Gutenbergstr. 11-23, D-66103 Saarbrücken, Germany Phone: +49-(0)681-502-1528, Fax: +49-(0)681-502-1509 Email: ajung_at_sz-sb.de (PGP key available)

Received on Thu Feb 18 1999 - 00:18:37 CST