Moving Critical Oracle Files to Volumes
Oracle on the Sun OS Configuration for Remote Volume Mirroring . . . . . . . . . . . . . . . . . . . . . . . . .
5-2
Remote Mirroring of an Oracle Database Using Data Replicator Software
Moving Critical Oracle Files to Volumes That Will
Be Mirrored
After you install Oracle, various configuration files and directory structures are installed
with the Oracle software. To back up a complete Oracle instance without also copying the
Oracle software area, move these configuration files and directory structures to volumes
that will participate in the complete mirroring solution of an Oracle instance. This is good
practice for any Oracle installation, because applications are often backed up on a different
rotation than critical data, such as databases.
Use the following example to move your critical Oracle directories and files to a volume
that will participate in the RVM solution.
This example assumes that an
$ORACLE_SID = esgdb
and a volume (
/oradata
) will
participate in the RVM Solution.
1
Create soft links for Oracle directories.
a
Type the following command to list the directories under
$ORACLE_BASE/
admin
.
$ ls -l $ORACLE_BASE/admin/esgdb
The directory list looks similar to the following items.
total 18
drwxr-x--- 2 oracle oinstall 3072 Sep 25 10:09 adump
drwxr-x--- 2 oracle oinstall 1024 Sep 25 10:14 bdump
drwxr-x--- 2 oracle oinstall 512 Sep 15 09:01 cdump
drwxr-x--- 2 oracle oinstall 512 Sep 15 09:01 dpdump
drwxr-x--- 2 oracle oinstall 512 Sep 15 09:18 pfile
drwxr-x--- 2 oracle oinstall 1536 Sep 25 11:33 udump
b
Type the following command to make a new admin directory under the mirrored
volume.
mkdir -p /oradata/oracle/admin/
c
Type the following command to move the directories to a new location.
mv $ORACLE_BASE/admin/esgdb /oradata/oracle/admin
d
Type the following command to create a link to the new directories.
$ ln -s /oradata/oracle/admin/esgdb $ORACLE_BASE/admin/esgdb
e
Type the following command to verify the new link.
$ ls -l $ORACLE_BASE/admin/esgdb
The new link appears.
lrwxrwxrwx 1 oracle oinstall 27 Sep 25 11:49 /app/
oracle/admin/esgdb -> /oradata/oracle/admin/esgdb