Back Up the Database On Demand
This method is useful for cases where an immediate backup/export is required; for example, when Customer Support requests a copy of your database for troubleshooting.
To back up the database tables, Hitachi Storage Viewer provides an Oracle utility,
exp. This utility exports the user
portal, which contains the database tables. See
Exporting the Oracle Database to create a full export file of all database objects.
For optimum performance, use this utility rather than your favorite backup solution’s backup utility (for example,
rman) because most backup solutions require archive logging. HDS does not enable or expose this setting because archive logging can have a significant, negative impact on performance.
You will import this export in the event that you need to:
• Retrieve a data table that’s been corrupted or accidently deleted. Simply drop the portal user then import the export. See
Importing the Oracle Database.
Exporting the Oracle Database
To create a full export file of all objects in the Portal database:
1. Log on to the database server.
• In a Linux environment, log on to the database server as user aptare.
• In a Windows environment, log on to the database server as a user who is a member of the ORA_DBA group.
2. Edit the export_scdb.par file to specify a value for path_to_backup_directory. The export_scdb.par file contains the following parameters:
Table 1 export_scdb.par File
USERID=system/aptaresoftware BUFFER=128000 GRANTS=Y ROWS=Y INDEXES=Y CONSISTENT=Y COMPRESS=Y STATISTICS=NONE OBJECT_CONSISTENT=Y FULL=Y FILE=/path_to_backup_directory/scdb.exp |
3. Run the following commands:
• On Linux (as user, aptare):
/opt/aptare/oracle/bin/exp parfile=/opt/aptare/database/tools/export_scdb.par
• On Windows:
C:\opt\oracle\bin\exp parfile= C:\opt\oracle\database\tools\export_scdb.par