To be completed.
1, first install a new ORACLE, including the service name, SID, the installation directory should be the best line with the original ORACLE directory. Please note that I installed on D drive, follow the actual installation directory of your operation. At the same time all my operations are carried out in sqlplus.
2, alter database backup controlfile to trace; backup the current database control files, control files are generally backed up to D: \ oracle \ product \ 10.2.0 \ admin \ bstest \ udump, please note that the latest one it wants.
3, delete the installation directory of all the datafile, logfile. (Oradata directory file)
4, Copy the original data file to the oradata directory, including the system data files.
5, delete the original control file, re-create a control file, note the location changes each path, as follows:
CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS NOARCHIVELOG
GROUP 1 'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ REDO01.LOG' SIZE 50M,
GROUP 2 'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ REDO02.LOG' SIZE 50M,
GROUP 3 'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ REDO03.LOG' SIZE 50M
- STANDBY LOGFILE
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ SYSTEM01.DBF',
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ UNDOTBS01.DBF',
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ SYSAUX01.DBF',
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ USERS01.DBF',
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ BSTEST \ TEST.DAT'
CHARACTER SET ZHS16GBK
Note that the path to modify the data file, if the original data file, plus your original data file path of all, such as red is my original data file.
6, startup nomount; start to nomount state, and then perform the above control file rebuild statement.
7, implementation of the recover database using backup controlfile until cancel;
Enter cancel carriage return, after the error.
8, alter database open resetlogs; executed the following error.
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D: \ ORACLE \ ORADATA \ ZQKH \ SYSTEM01.DBF'
9, # system file error, see the "consistency" natural thought _allow_resetlogs_corruption implied command
alter system set "_allow_resetlogs_corruption" = true scope = spfile;
10, alter database open RESETLOGS;
Still not open. The following error:
alter database open RESETLOGS
ERROR at line 1:
ORA-01092: ORACLE routine termination. Forced disconnect
11, the UNDO log into manual mode:
alter system set undo_management = 'manual' scope = spfile;
12, restart, boot to the startup mount; then
Implementation of the recover database; success
Further implementation of the alter database open; open succeeded.
13, is now generally successful, but after this treatment, for safety reasons,
All the best to export the data using EXP first, and then re-install ORACLE, and then re-import the IMP.
When I export Shique error: Tips temporary table space is empty.
With select name from v $ tempfile; view, really is empty, then:
If temp01.dbf already exists, as follows:
alter tablespace temp add tempfile 'D: \ oracle \ product \ 10.2.0 \ oradata \ bstest \ temp01.dbf'
alter tablespace temp add tempfile 'D: \ oracle \ product \ 10.2.0 \ oradata \ bstest \ temp01.dbf' size 10M;
EXP then export success!
This article comes from CSDN blog, reproduced, please indicate the source: http://blog.csdn.net/caok/archive/2009/10/23/4718220.aspx