Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843