You can restore the tablespace or data files. Before you restore, you must locate the file. When you locate the files, ensure that the database is in the Open state. If the database is open, use the ALTER TABLESPACE. OFFLINE statement to take the tablespaces or datafiles offline before you begin the restore process.
Follow these steps:
SQL> SELECT FILE_NAME, TABLESPACE_NAME FROM DBA_DATA_FILES;
SQL> STARTUP MOUNT;
SQL> STARTUP NOMOUNT;
SQL> SHUTDOWN IMMEDIATE;
SQL> RECOVER TABLESPACE "tablespace_name";
SQL> RECOVER DATAFILE 'path';
Oracle checks for the archive redo log files that it needs to apply and displays the names of the files in a sequence.
Oracle applies the log files to restore the data files. After Oracle finishes applying the redo log file, it displays the following messages:
Applying suggested logfile
Log applied
After each log is applied, Oracle continues to apply the next redo log file until the recovery is complete.
SQL> ALTER TABLESPACE "tablespace_name" ONLINE;
The tablespace is now recovered to the last available log file.
Copyright © 2015 Arcserve.
All rights reserved.
|
|