Record the database incomplete recovery caused by a power outage

Record the database incomplete recovery caused by a power outage

Received a call from a friend that a windows+ora11g database failed to start due to a power outage

Record repairs and detours

Regret: the database is not archived, there is no backup, and there may be data loss when the database is opened.

1. Cold backup database files after power outage and restarting the system

2. Try to start the database and prompt:

ORA-01079 Oracle database was not properly created, operation aborted

3. Rebuild the control file

Start the database to mount

Execute the statement for the first time:

CREATE CONTROLFILE REUSE DATABASE "ora11g" RESETLOGS NOARCHIVELOG

.

Tip:

ORA-01192: must have at least one enabled thread

The control file was created for the second time, and the statement was executed successfully.

CREATE CONTROLFILE REUSE DATABASE "ora11g" RESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 ('E:\ app\ Administrator\ oradata\ ora11g\ REDO01.log') SIZE 51200K

GROUP 2 ('E:\ app\ Administrator\ oradata\ ora11g\ REDO02.log') SIZE 51200K

GROUP 3 ('E:\ app\ Administrator\ oradata\ ora11g\ REDO03.log') SIZE 51200K

-- STANDBY LOGFILE

DATAFILE

'e:\ app\ Administrator\ oradata\ ora11g\ SYSTEM01.DBF'

'e:\ app\ Administrator\ oradata\ ora11g\ UNDOTBS01.DBF'

CHARACTER SET US7ASCII

4. Try to repair the database:

Recover database using backup controlfile

Put the path of the redo file under the prompt command line and prompt that the restore failed

Try: alter database open resetlogs

Tip: system file needs to be restored, recover datafile system file failed

Try a variety of methods to open the database when system needs to be restored, but all fail

5. Restart the database to the mount state and recreate the control file

No recover database; Direct alter database open resetlogs

6. Add temporary files

Alter TABLESPACE "CCEN_TMP" add TEMPFILE'E:\ app\ Administrator\ oradata\ ora11g\ CCEN_TMP.ora' SIZE 2g reuse AUTOEXTEND ON NEXT 1g maxsize 30g

7. Perform full database backup

A question that has time to ponder:

1. How to open the database when system needs to be restored?

2. How to get data directly from a data file?

Appendix: about checkpoint information

Simple Analysis of ORA-01113 problem

Http://blog.itpub.net/23718752/viewspace-1742631/

Http://blog.csdn.net/xingzhemoluo/article/details/39430487

Http://blog.csdn.net/msdnchina/article/details/38169095

Http://blog.csdn.net/msdnchina/article/details/38010025