Back Up Files on an Oracle Server - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Hexagon

You can back up your files when creating a new database on the same Oracle server or when moving a database from one Oracle server to another.

Back up files when creating a new database on the same Oracle server

1. On your Windows server, create a sub-folder <drive>:\INtoolStorage\<name of new Oracle database>.

   The name of the new Oracle database appears as the value of the db_name parameter in the Oracle Instance Configuration file, for example, orc2.

2. In the target Oracle database, open the Oracle Instance Configuration file init.ora.

3. In the Oracle Instance Configuration file, add the following parameter line:

   utl_file_dir=<drive>:\INtoolStorage\orc2

4. Copy the content of the folder orc1 in the path <drive>:\INtoolStorage\ to the folder orc2.

5. Restart your computer.

Back up files when moving a database from one Oracle server to another

1. On your target Windows server, select a disk drive with 300 MB free disk space for the storage of about 1 million records.

2. Create a folder INtoolStorage.

3. Create a subfolder <drive>:\INtoolStorage\<name of new Oracle database server>.

   The name of the new Oracle database appears as the value of the db_name parameter in the Oracle Instance Configuration file. For example, orc2.

4. Open the Oracle Instance Configuration file init.ora.

5. In the Oracle Instance Configuration file, add the following parameter line:

   utl_file_dir=<drive>:\INtoolStorage \orc2

6. Copy the content of the folder orc1 in the source path <drive>:\INtoolStorage to the folder orc2 in the target path <drive>:\INtoolStorage.

7. Restart your computer.

See Also

Managing Audit Trail Data