Shulou(Shulou.com)06/02 Report--

Keep the data files, control files and redo log files of the original database on Windows

Reinstall Windows system and redo database.

1. Install Oracle database software

2. Create a database with the same name as the original database using Oracle dbca

3. Back up the spfile file (usually located in the $ORACLE_HOME\ dbs directory) and generate a pfile file (usually located in the $ORACLE_HOME\ database directory):

SQL > create pfile from spfile

4. Modify the path of the pfile file type control file. The path points to the control file that originally retained the database

5. Start the database

SQL > startup

If the database starts to mount state, but cannot boot to open state, the following error is usually reported:

ORA-01122: verification of database file 1 failed

ORA-01110: data file 1:'e:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ SYSTEM01.DBF'

ORA-01207: files are newer than control files-old control files

Resolve:

Rebuild the control file:

1. SQL > alter database backup controlfile to trace as'e:\ trace'

2. Close the database: shutdown immediate

3. Start: startup nomount

4. Open the'E:\ trace' file, execute the following statement on the database command line, and rebuild the control file

CREATE CONTROLFILE REUSE DATABASE "XBOMS" NORESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1'E:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ REDO01.LOG' SIZE50M

GROUP 2'E:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ REDO02.LOG' SIZE50M

GROUP 3'E:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ REDO03.LOG' SIZE50M

DATAFILE

'e:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ SYSTEM01.DBF'

'e:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ UNDOTBS01.DBF'

'e:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ SYSAUX01.DBF'

'e:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ XBOMS\ USERS01.DBF'

CHARACTER SET ZHS16GBK

5 、 RECOVER DATABASE

6 、 ALTER DATABASE OPEN

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.