Building a Physical Standby Database (06/14) - Prepare standby controlfile on primary database

Building a Physical Standby Database (05/14) - Create standby redo logs on primary database

You cannot copy a control from the primary database directly, it does not work, you can only generate a controlfile dedicated for a standby database from a primary database.

Three methods can get the file.

1. Generate manually.
[oracle@primary01 ~]$ sqlplus / as sysdba
...
SQL> alter database create standby controlfile as '/tmp/standby.ctl';

Database altered.

2. Generate by RMAN.
[oracle@primary01 ~]$ rman /
...
RMAN> copy current controlfile for standby to '/tmp/standby.ctl';

Starting backup at 08-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: starting datafile copy
copying standby control file
output filename=/tmp/standby.ctl tag=TAG20121108T095401 recid=4 stamp=798803641
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 08-NOV-12
...

3. Online duplicate by 11g RMAN.
In 11g database, the standby controlfile will be generated and copy to the auxiliary (i.e. standby) database while online duplicating database via RMAN. If you are planning to use 11g duplication, then you can skip the step.

Building a Physical Standby Database (07/14) - Prepare data files on primary database