
Backup and Recovery
|
65
3.
Recover the tablespaces in the auxiliary database to the
appropriate point in time.
4.
Make the target tablespaces read-only in the auxiliary
database.
5.
Export the transportable tablespace information from the
auxiliary database.
6.
Drop the tablespaces in the original database.
7.
Copy the tablespaces from the auxiliary database to the
original database.
8.
Import the transportable tablespace information into the
original database.
9.
Use transportable tablespaces to move the recovered
tablespaces to the original database.
10.
Enable read-write access for the new tablespaces.
Backup and Recovery Commands
The following section summarizes the syntax of the SQL
commands used for backup and recovery. These commands
are common to Oracle across all operating system platforms.
Also included are two utilities that Oracle provides to allow
you to test the validity of a backup (DBVERIFY) and to back
up raw Windows partitions (OCOPY); for detailed informa-
tion on these, see the Oracle documentation.
ALTER DATABASE BACKUP CONTROLFILE
Creates a backup of the current control file for the database.
ALTER DATABASE BACKUP CONTROLFILE TO filename | TO TRACE
to_filename
Specifies the location of a copy of the current control file.
TO TRACE
Causes the information in the control file to be written as
SQL statements to a file in the database’s trace directory. You
can use this information to re-create the