Installation and Configuration | Configuration |
i
/nsr/oracle/ora/wednesday: USER1_TS
USER2_TS
/nsr/oracle/ora/thursday:
ROLLBACK_TS USER1_TS
/nsr/oracle/ora/friday: USER1_TS
/nsr/oracle/ora/${ORACLE_SID}_full_save:
SYSTEM
/nsr/oracle/ora/${ORACLE_SID}_offline:
SYSTEM
Note that only one file (in our example: SYSTEM) is needed in the direc- tories ${ORACLE_SID}_full_save and ${ORACLE_SID}_offline for a tablespace that is to be backed up. If at least one of the existing tablespaces is specified here, that tablespace along with all other exist- ing tablespaces and the control file will be backed up automatically.
i
!
!
It is also recommended generally to carry out a full backup
(${ORACLE_SID}_full_save or ${ORACLE_SID}_offline) at least once a week. This ensures that all tablespaces are backed up at least once a week and at the same time all control files (and in an offline backup additionally all redolog files) will be backed up as well.
For the automatic recovery of the database to the state of a previous point in time (see section “Automatic Recovery for an Optional Point in Time”) backups with „full“ level and redolog files are explicitely required. Individually saved tablespaces are not used therefore.
The <ORACLE_SID>_recover save set needed with earlier versions must not be used any more.
If you are using
It is important that the owner of the (empty) tablespace files be $ORACLE_OWNER and for them to belong to the same group as $ORACLE_OWNER (usually dba).
System Administrator’s Guide |