Create a physical oracle9i standby database on a stand-alone computer

Description: The data Guard characteristics of the Oracle9i database ensure the complete protection of the information, which is one of the key features of Oracle 9i. The data Guard can create a physical standby database, or create a logical standby database, and can be mixed, and with greater flexibility. This document is the Fenng practice time to write down things, not to mention what the experience. * It's just a note from the installation process * If you have higher expectations for this, or want more information about the Oracle database data guard and Standby, please refer to the official documentation.

System Environment: Windows 2000 Professional Edition SP3 512M memory

Existing database instance (Primary) name: Demo

Pre-created Standby database instance name: Pstandby

Database version information:

Sql> select * from V$version;

BANNER

----------------------------------------------------------------

Oracle9i Enterprise Edition Release 9.2.0.1.0-production

Pl/sql Release 9.2.0.1.0-production

CORE 9.2.0.1.0 Production

TNS for 32-bit windows:version 9.2.0.1.0-production

Nlsrtl Version 9.2.0.1.0-production

Preparatory work

First verify that the primary database is in archive mode

Sql> Show User

USER is "SYS"

Sql>

Sql> Archive Log List

Database Log Mode Archive mode

Automatic Archival Enabled

Archive Destination D:\oracle\oradata\demo\archive

Oldest online log sequence 42

Next Log sequence to archive 44

Current Log Sequence 44

If you are not in archive mode, adjust the database.

First commit the command to modify the SPFile:

Sql>alter system set Log_archive_start=true scope=spfile;

Then close the database instance

Sql>shutdown

Backing up a database

Sql>startup MOUNT

Sql>alter DATABASE Archivelog;

Sql>alter DATABASE OPEN;

Sql>shutdown IMMEDIATE