Stopping Mirrored Remote Database
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Starting the Database Mirroring
Remote Mirroring of an Oracle Database Using Data Replicator Software
6-3
2
Create soft links for the PFILE file and the SPFILE file.
a
Type the following commands to move PFILE and SPFILE to the pfile
directory.
$ mv $ORACLE_HOME/dbs/spfileesgdb.ora $ORACLE_BASE/admin/
esgdb/pfile
$ mv $ORACLE_HOME/dbs/initesgdb.ora $ORACLE_BASE/admin/
esgdb/pfile
b
Type the following commands to create links for PFILE and SPFILE.
$ ln -s $ORACLE_BASE/admin/esgdb/pfile/spfileesgdb.ora
$ORACLE_HOME/dbs/spfileesgdb.ora
$ ln -s $ORACLE_BASE/admin/esgdb/pfile/initesgdb.ora
$ORACLE_HOME/dbs/initesgdb.ora
c
Type the following command to verify the new links.
$ ls -l $ORACLE_HOME/dbs/*.ora
The new links are shown.
lrwxrwxrwx 1 oracle oinstall 43 Sep 25 12:05 /app/oracle/
oracle/product/10.2.0/db_1/dbs/initesgdb.ora -> /app/oracle/
admin/esgdb/pfile/initesgdb.ora
lrwxrwxrwx 1 oracle oinstall 45 Sep 25 12:04 /app/oracle/
oracle/product/10.2.0/db_1/dbs/spfileesgdb.ora -> /app/
oracle/admin/esgdb/pfile/spfileesgdb.ora
Starting the Database Mirroring
A four-step process updates the remote host's logical drives. These steps are shown in the
process flow diagram on page
.
Stopping a Previously Mirrored Remote Database
If a database has been previously mirrored on the remote site, it must be stopped before
any subsequent mirroring attempts. To stop a database on the secondary site, type the
following command to invoke the
db_stop
.
db_stop
$PRI_DB_ID $ORA_SID $ORA_HOME $ORA_DUMP
$LOG $TRACE $RMT_SCRIPT_DIR $ORA_BASE