Store Oracle data files and files other than data files on separate disks or in separate slices.
Note the following when performing this function:
Initialization parameter file
Every time a change occurs, back up this file using the cp command of the OS is executed for backup.
Control files
You are recommended to use mirroring 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 destroyed, execute the SQL statement in the trace file to recover the control file.
alter database backup control file to trace; |
Data files
The recommended location of data files is on a raw device.
To store a data file on the file system, disable the automatic extended function of the data file (AUTOEXTEND OFF). Customization of the sample shell script is required to prevent unmounting during context processing.
Create backup copies in AdvancedCopy Manager.
The range of table spaces targeted for backup must be within the unit of synchronous backup processing (begin backup/end backup) in Oracle and the unit of backup in AdvancedCopy Manager. For example, if backup copies must be created in units of LUNs in AdvancedCopy Manager, place one table space in one LUN.
Archive all of the latest logs by executing the following command after backing up all table spaces in the system:
alter system archive log current; |
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.
After an Oracle database has stopped, restore the database, and restart it. To recover the database to its latest state, use Oracle's recovery function.
