Standby databases and different sids

From: <williamhargrove_usenet_at_hotmail.com>
Date: Fri, 13 Oct 2000 13:11:56 GMT
Message-ID: <8s71mn$h1g$1@nnrp1.deja.com>

Hello All,

I am trying to set up a standby database, using Oracle 8.1.6 on Solaris 8 and 7
(the production machine is running 8 - it is actually a development machine,
and the standby machine - even more of a development machine is running 7.)

The instance on the production machine is called 'td4', and the instance on the standby is
called 'td6'. And I think this is probably the cause of the problems that I am having. I've
copied the datafiles, redo logs, and archived redo logs from the production server, and
the standby control file that I have created on the production server, and placed then on
the standby machine, update the init.ora files on both machines, to copy log files via net8
and for the standby machine to read the standby control files and standby log archive dest.
I also copied the production init.ora file to the standby machine, and changed the references
to the sid and db_name from td4 to td6.

So I go to startup the standby dd, and get the error below. Thinking about what has hapenned
here, I have taken a standby control file from the production machine, which thinks the sid
and db are called 'td4' and placed them on a machine with an identical db that I have created
using the scripts from the production machine, but with a sid set to td6, and no wonder
it doesn't work. The control files say td4, but the ORACLE_SID says td6, and so does the
init.ora file

So, does the sid on the standby machine have to be the same as the production machine, so the
standby control files think it is the 'same' database? And furthermore, is there any need
to even bother using dbassist / running scripts to create a new database on the standby
machine, since I am going to be copying the files over from the production machine and
replacing the ones what I will have just created.

Connected to an idle instance.

SQL> startup nomount
pfile=/opt/oracle/OraHome1/admin/td6/pfile/inittd6.ora ORACLE instance started.

Total System Global Area 166301680 bytes

Fixed Size                    69616 bytes
Variable Size              63651840 bytes
Database Buffers          102400000 bytes
Redo Buffers                 180224 bytes

SQL> alter database mount standby database; alter database mount standby database
*
ERROR at line 1:
ORA-01103: database name 'TD4' in controlfile is not 'TD6'

SQL> quit

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 13 2000 - 08:11:56 CDT