Re: Standby Database

I am not sure how to create a standby database for an OPS system. You could try testing it for OPS using dd to copy the datafiles/raw partitions to your target machine. If successful post the results back. I donot have access to an OPS system now.

Steps to create a standby database:

1. Set the compatibility flag to 7.3 or higher ( Once set the compatibility flag cannot be set to a lower version. )
2. Copy the database files (online or offline) to the standby site. DONOT copy the online redo log files and the control file.
3. Copy the init<sid>.ora to the standby site and add the parameters DB_FILE_STANDBY_NAME_CONVERT and LOG_FILE_STANDBY_NAME_CONVERT if necessary.
4. Create a standby controlfile for the standby database with the command

  alter database create standby controlfile as ‘filename’

  at the primary.

5. Switch the logs and archive and transfer the archived redo logs and the standby controlfile to the standby site.

6. Change the init<sid>.ora at the standby site to point to the standby controlfile.

7. At the standby site, mount the standby database and apply the archive logs

  recover standby database

8. In the event of failure of the primary database, apply all the archived logs and activate the standby database

  alter database activate standby database.

  The database needs to be bounced to make it operational. Also backup this database as this is the primary database. A new standby database has to be created now.

Issues:
Any of the following at the primary site has implications at the standby site and must be taken care of.

1. Altering the structure of the database
2. Unrecoverable transactions
3. Changes in the initialization parameters

HTH. Denny

In article <01bdd4ee$a31a59c0$01011fb4_at_steve>,   "Dicky" <ccdicky_at_hotmail.com> wrote:
> Hi everybody, who can tell me how to configure a standby database? Is it
> possible to make a standby database for a production OPS database??
> Thanks in advance!
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 10:26:17 CST