Oracle Application DBA Portal

Hello Everyone!!!

Backup Recovery

Closed Database Recovery Steps

Restore the damaged files from backup.

SQL> startup mount
SQL> recover database
SQL> alter database open

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 '2009-01-01:12:00:00' using backup controlfile
SQL> alter database open resetlogs
Perform a full backup of the database

TIPS
System Tablespace Versus a Non-System Tablespace Recovery
-----------------------------------------------------------------------------

When a system data file is lost or damaged, the only way to recover
the database is by doing a closed database recovery using RECOVER
DATABASE command.

Checking for Files Needing Recovery
----------------------------------------------------------
select b.name, a.error from v$recover_file a, v$datafile b
where a.file# = b.file# ;

Happy Learning
--Sreene

Labels: Backup Recovery

posted by Srinivasan .R @ 4:46 AM

2 Comments:

At April 10, 2019 at 11:08 PM, Anjali Siva said…

I gathered lots of information from your blog and it helped me a lot. Keep posting more.
R Training in Chennai
R Programming Training in Chennai
Machine Learning Training in Chennai
Machine Learning course in Chennai
Data Science Training in Chennai
Data Analytics Training in Chennai
Data Science Certification in Chennai
Data Science Training in Velachery
Machine Learning course in Chennai
At June 11, 2020 at 11:32 PM, nisha said…

The Blog is really very impressive. every content should be very uniquely represented. as well as concepts are neatly explained.

Data Science Training Course In Chennai | Data Science Training Course In Anna Nagar | Data Science Training Course In OMR | Data Science Training Course In Porur | Data Science Training Course In Tambaram | Data Science Training Course In Velachery