image

ORA-01033 : file 1 needs media recovery

Possbile Solutions: Basically your system.dbf is corrupted / incomplete.. needs recovery1. kill all connects from OS level2. ps -ef |grep pmonans kill the database service that is running…3. Do you have any RMAN backup or archivelogs?If YES – Recover database with the archivelogsif NO – try to recover using all the redo logs..Commnad: recover database … continue reading

image

Recovery – Loss of all control files (no catalog)

SCENARIO – LOSS OF ALL CONTROLFILES (NO CATALOG) SQL> insert into myobjects select * from myobjects; 919664 rows created. SQL> commit; Commit complete. SQL> select count(*) from myobjects; COUNT(*) ———- 1839328 >>>> need to check this record count after recovery SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST … continue reading

image

Incomplete Recovery (until point in time)

POINT IN TIME RECOVERY via RMAN Scenario: DBA dropped the tablespace TEST which is important for application. Requirement: We need to restore the database before the TEST tablespace was dropped. Solution: SQL> drop tablespace test including contents and datafiles; Tablespace dropped. DBA realized the mistake; He will refer alert log for the exact timing when … continue reading

image

RMAN Restore on another machine with different file system- same database name

RMAN Restore on another machine with different file system – same database name Primary/Target Machine ITLINUXDEVBLADE08 Secondary/Auxiliary Machine ITLINUXDEVBLADE07 Database Name OPSDBA Note For this example, we will be using TSM in order to backup and duplicate the database to the new machine. Hence TSM needs to be configured on both the machines. If you … continue reading

image

NOARCHIVELOG Database Recovery

NOARCHIVELOG DATABASE RECOVERY VIA RMAN Your database is running in No Archive log mode and you have daily/weekly RMAN backup configured. One fine day, your server crashed and you lose one of the disks or all the disks. You have no other option but to restore the whole database backup to point of last valid … continue reading

image

Recovery of a dropped tablespace

Recovery of a dropped tablespace To recover from a case of a dropped tablespace, the Tablespace Point In Time Recovery (TSPITR) method cannot be used. When you drop a tablespace, the controlfile will then no longer have any records of the tablespace which has been dropped. Attempts to use the RMAN RECOVER TABLESPACE command will … continue reading

image

Multiplexing Control File

This article will focus on multiplexing the  control file. There are possibilities where control file can go corrupt , loss or damage by accident or some accidental deletion. Having multiple copies of control files will reduce risk of  result of loss of control files.If we have the copy of the control files we can simply … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube