Closed Database Recovery Steps
Restore the damaged files from backup.
SQL> startup mount
SQL> recover database
SQL> alter database open
SURENDER
SARA
|
| |
Offline Tablespace Recovery Steps
Restore the damaged files from the backup.
SQL> startup mount
SQL> alter datafile '/u01/oradata/users01.dbf' offline;
SQL> alter tablespace users offline;
SQL> recover tablespace users;
SQL> alter tablespace users online;
|
| |
Offline Datafile Recovery Steps
Restore the damaged files from the backup.
SQL> Startup mount
SQL> alter datafile '/u01/oradata/users01.dbf' offline;
SQL> alter database open;
SQL> alter tablespace users offline;
SQL> recover datafile '/u01/oradata/users01.dbf';
SQL> alter tablespace users online; |
| |
Cancel-Based Recovery Steps
Restore the damaged files from the backup.
SQL> startup mount
SQL> recover database until cancel using backup controlfile ;
SQL> alter database open resetlogs
Perform a full backup of database. |
|
|
|
 |
|
| |
Change-Based Recovery Steps
Restore the damaged files from the backup.
sql> startup mount
sql> recover database until change 2315 using backup controlfile
sql> alter database open resetlogs |
| |
Time-Based Recovery Steps
Restore the damaged files from the backup.
SQL> startup mount
SQL> recover database until time using backup controlfile ;
SQL> recover database until time '1999-01-01:12:00:00' using backup controlfile
SQL> alter database open resetlogs
Perform a full backup of the database |
|
