Store data files and other Oracle files on different disks or in different partitions.
Note the following when performing this function.
Initialization parameter file
Whenever a change is made, back up this file using the copy command, etc. of the OS.
Control files
You are recommended to mirror using Oracle.
If a change is made in the DB environment, use the following command to create a trace file. If a control file is corrupted, execute the SQL statement in the trace file to recover the control file.
Alter database backup control file to trace; |
Data files
Be sure to perform Oracle synchronous backup processing (begin backup/end backup) on all the table spaces to be backed up. No backup file created without synchronous processing can be used for recovery. Performing recovery using such a backup file is risky. If you do, an inconsistency may be generated in a database, which will then mean that it can no longer be opened.
When placing a data file in a file system, disable automatic data file extension (AUTOEXTEND OFF).
REDO files
You are recommended to mirror the online REDO log files and archive log files using Oracle or the OS.
No online REDO log file needs to be backed up.
Note
For online backup operations, the target Oracle database must use an archive log.
To recover an Oracle database to the latest status, first restore the Oracle database and replace the files in which the error occurred with restored files, using the recovery function of Oracle.
Example:
recover tablespace |
For information on the recovery function of Oracle databases, see "Oracle8i Backup and Recovery Guide" (if the database is Oracle8i).
