How to open a crashed oracle database during HOT BACKUP

advertisements

_____________________________________________________________________________________________________________________

Different methods to END BACKUP

If the instance crash happens during the oracle hot backup due to the power failure or shutdown abort the database will not open in normal way. It will ask for the media recovery. It throws error like ORA-01113:  file xx needs media recovery, ORA-01110 during the database startup.
Below mentioned are the methods to bring up/open the database in normal mode.

Method 1: Alter database end backup; this method is applicable to the oracle versions 9i or above.

1.      Mount the database (Syntax: startup mount;)

2.      Check how many datafiles are in “ACTIVE” status from v$backup view

(Syntax: select * from v$backup where status =’ACTIVE’;)

3.      Execute “alter database end backup;” statement to take all datafiles currently in backup mode.

Method 2: SQL *PLUS Recover database;

1.      Mount the database (Syntax: startup mount;)

2.      Check how many datafiles are in “ACTIVE” status from v$backup view

(Syntax: select * from v$backup where status =’ACTIVE’;)

3.      Execute “recover database;”

Method 3: alter database datafile ‘absolute filename’ end backup;

            If your database is running on prior to oracle 9i release you have to use this method.

1.      Mount the database  (Syntax: startup mount;)

2.      Find out the file#, file_name from v$backup and v$datafile tables.

(Syntax: select b.file#, d.NAME from v$backup b, v$datafile d

where  b.file#=d.file# and    b.status ='ACTIVE')

3.      Manually end backup the datafiles

(syntax: ALTER DATABASE DATAFILE 'absolute filename' END BACKUP;)

_____________________________________________________________________________________________________________________

Website Stats