When performing an Oracle RMAN incremental snap to tape copy, note the following:
-
The Oracle database installed on the proxy machine should be of the same version as the source. For example if Oracle 10.2.0.4 is installed on source then the proxy also should be of the same version i.e. 10.2.0.4
-
Oracle user ID/group ID on source and proxy should be the same otherwise the RMAN backup copy will fail with permission issues.
-
Copy the Oracle parameter file pfile from the source to the proxy (say the instance only as spfile)
sqlplus <username/password@servicename> as sysdba << EOF Create pfile from spfile; Exit; EOFCopy the pfile init<instance name>.ora to the proxy computer and the destination location should be $ORACLE_HOME/dbs/ with oracle user permissions. Also, copy the oracle password file from the source to the proxy computer's $ORACLE_HOME/dbs/ directory.
-
Create the bdump, udump, adump, cdump and diagnostic_dest directories. Please note that the directories should be in the same location as the source.
-
Create the directories DB_CREATE_FILE_DEST, LOG_ARCHIVE_DEST and any other directory required for starting the database in NOMOUNT mode. If there are multiple archive destinations, then create the directories for each of the archivelog destinations.
-
Copy $ORACLE_HOME/network/admin/tnsnames.ora configuration from source to proxy. If the entire content cannot be copied then copy at least the configuration related to catalog connection.
-
Startup the proxy instance in NOMOUNT mode.
-
Now configure the proxy Oracle Instance on the CommServe Console and status should be started. Now you are all set to do Oracle RMAN snap to tape incremental
For an incremental backup, the software nounts the snap clone in the same location as the source mount-point of the source database. For example, if the data mount-point is /netapp/data then the proxy mount point is /netapp/data. The same rule applies for the archive log location chosen for the IntelliSnap backup. Verify the following on the proxy server:
-
The mount point is free.
-
The directory does not currently exist or if it exists that the directory is empty.