Category: Backup/Recovery

When you are trying to start database: SQL> startup ORACLE instance started. Total System Global Area  167772160 bytes Fixed Size                  1279120 bytes Variable Size              71306096…

RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number. This type of recovery is sometimes called…

Disaster Recovery How to perform a disaster recovery of an Oracle server using Manual Backup Method 1.Pre-requisites: The following are the pre-requisites to fully recover…

Step 1 Restore database and mount the database Step 2 Recover the database SQL> recover database using backup controlfile; Step 3 Check file status SQL>…

Step 1 Startup the database with mount option SQL> startup mount Step 2 Recreate datafile SQL> alter database create database datafile ‘’ as ‘’ size…

Step 1 offline the datafile SQL> alter database datafile ‘’ offline; Step 2 Create datafile SQL> alter database Create datafile ‘’ as ‘’ size ;…

Error At run time: SQL> conn / as sysdba Connected. SQL> select * from scott.emp; select * from scott.emp                     * ERROR at line 1:…

This scenario deals with a situation where a datafile has gone missing, or is corrupted beyond repair. For concreteness, we look at a case where…

If All Control file loss or corrupted and you have control file backup by using alter database backup control file to trace command. Then startup…

If All Control files loss or corrupted and you have no backup (Also you have not taken control backup by using alter database backup controlfile…