Oracle10g only way to restore data files

2010-03-22  来源:本站原创  分类:Database  人气:182 

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

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

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

DATAFILE

'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'

Otherwise:

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

相关文章
  • Oracle10g only way to restore data files 2010-03-22

    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

  • Oracle RMAN-based recovery of data files 2011-08-07

    Rman Data backup script RUN { CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:/app/Administrator/backup/%F'; ALLOCATE CHANNEL CH1 DEVICE

  • Oracle10G migration of data files (windows) 2010-12-04

    Director: Stephen Peng From: http://stephen.pen.blog.163.com/blog/static/12875926720091116101233154/ This is the cause of the incident, the family used to make the space more and more SAP server computer is not enough, the original is 160G +250 G, wi

  • Oracle10G logical backup and restore (exp and import) 2011-02-23

    Keywords: oracle10g logical backup and restore (DOC orders) Export (local): imp xtnygis / ecenter @ orcl full = y file = C: \ 1.dmp ignore = y log = c: \ img.log Export with date and time exp hznbqlyg / hznbqlyg @ 192.168.0.88:1521 / orcl file = c: \

  • How to recover data files from a good oracle database 2010-10-27

    One. There are data files, control files and log file backup 1. Reinstall the operating system, server, oracle also reinstall the. If you reinstall the oracle and the previous damage to the structure of the database is exactly the same, then the reco

  • Recover lost data files 2010-12-14

    A technician when the table space is created, create a table space in the toad waiting process, the toad to shut down. Resulting document does not, however, the records database table space, will have this data file records. But the user table space

  • Table spaces and data files management 2011-01-16

    1 Create a data dictionary managed tablespaces 1) Create a table called jinlian space. In order to balance the I / O, determining the table space will be based on two data files, they are J: \ DISK2 \ MOON \ JINLIAN01.DBF and J: \ DISK2 \ MOON \ JINL

  • Database, create tablespaces and data files more user commands 2011-02-21

    ORACLE create table space ORACLE, the table space is the basic method of data management, all the objects to be stored in the user table space, that is, users have the right to use space to create a user object. Otherwise it is not permitted to creat

  • Disk space, move the Oracle data files online 2011-08-07

    Import data, import it into half , Found insufficient disk space . This requires moving the data to the database file to another disk . 1. The data file offline : SQL> alter database datafile 2 'H:\oracle\product\10.2.0\oradata\lhoms\pub\test_space.d

  • ORACLE data files using dbv tool to examine whether there are bad blocks 2011-09-13

    Dbv tool to use test data files for bad blocks dbv tool can be used to verify the validity of the data files in the database before you can use this command to restore the backup file on the validity check, Prevent back problems led to the database f

  • 12. Database Management - management table spaces and data files 2010-03-22

     describes the logical table space is part of the database. From the physical perspective, the database data stored in the data file; Logically, the database is stored in table space, table space by one or more data files. Logical structure of the d

  • oracle data files and renamed one way of moving data files 2010-04-21

    I want to do is to present the original Oracle database / oracle/A1 directory A.dbf move the file to / oracle/B1 directory B.dbf data files, in order to forget the future, record the steps as follows: 1.mv / oracle/A1/A.dbf / oracle/B1/B.dbf 2.sqlplu

  • mysql backup (direct copy of data files) 2010-05-04

    Objective: A machine in the library to transfer to the B machine. 1, stop mysql service in the A machine mysql installation directory, locate the my.ini file to open, in this paper to find datadir, to the path of data files: ibdata1 and copy all fold

  • There is no backup data files, only the full restoration of archive 2010-06-17

    Prerequisite 1. Archive mode. 2. Data files created after the current control file. Otherwise it will report ORA-01178 error. ORA-01178: file 5 created before last CREATE CONTROLFILE, cannot recreate ORA-01110: data file 5: 'D: \ ORACLE \ PRODUCT \ 1

  • mysql backup (direct copy of data files) to switch 2010-06-22

    mysql backup (direct copy of data files) Articles Category: Database Objective: A machine in the library to transfer to the B machine. 1, stop mysql service in the A machine mysql installation directory, locate the my.ini file to open, in this paper

  • (8) Managing Tablespaces and Data files 2010-07-07

    SQL> select * from v $ tablespace; SQL> select * from v $ datafile; SQL> select * from v $ tempfile; SQL> select t1.name, t2.name from v $ tablespace t1, v $ datafile t2 where t1.ts # = t2.ts #; SQL> alter tablespace add datafile 'xxx' size

  • birt Cannot access NLS data files or invalid environment 2010-07-27

    ORA-12705: Cannot access NLS data files or invalid environment specified Articles Category: Database solutions are as follows: 1, First open the "Control Panel "-->" item "-->" Regional Regional and Language Options" ca

  • [Reserved] Oracle table space and data files 2010-10-13

    The structure of the oracle and some other basic problems, or some confused, search, see this man's article, rewarding: oracle table spaces and data files

  • oracle in blocks, panels, segment, tablespace, data files between 2010-10-17

    ORACLE in the physical storage, mainly divided into the control files, data files, log files. Database instance starts, the first load control file, then load the data file. We normally stored data objects in the physical data files stored in the mai

  • I used Linux command of the join - merging data files by keyword 2010-10-28

    I used Linux command of the join - merging data files by keyword This link: http://codingstandards.javaeye.com/blog/796299 (reprint, please indicate the source) Use Description Linux, the most common data file format is text format, a number of field