crStandbyCtl.txt
09-08-2001 Bikle
-----------------------

This file serves as a simple demonstration of creating and then copying
a standby control file from a primary database to a secondary database.

One added simplicity to this file is the fact that the standby database
resides on the same host as the primary database.  This allows us to just
directly put the file into the proper directory rather than create it
in /tmp and then maneuver it into place with ftp.

$ 
$ ABIKLE.csh
sf49er.bikle.com 1 % sqi

SQL*Plus: Release 8.1.7.0.0 - Production on Sat Sep 8 13:55:00 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

13:55:00 SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

System altered.

13:55:06 SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/u2/oracle/data/BBIKLE/control01.standby.ctl';

Database altered.

13:55:24 SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
sf49er.bikle.com 2 %