SQL*Plus User's Guide and Reference Release 9.0.1 Part Number A88827-02 |
|
Database Administration, 5 of 5
If a damaged database is in ARCHIVELOG mode, it is a candidate for either complete media recovery or incomplete media recovery operations. To begin media recovery operations use the RECOVER command. For more information about using the RECOVER command, see the "Command Reference" in Chapter 8.
In order to begin recovery operations, you must have DBA privileges.
To recover the database up to a specified time using a control backup file, enter
RECOVER DATABASE UNTIL TIME '1998-11-23:12:47:30'- USING BACKUP CONTROLFILE
To recover two offline table-spaces, enter
RECOVER TABLESPACE ts1, ts2
Make sure that the table-spaces you are interested in recovering have been taken offline, before proceeding with recovery for those table-spaces.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|