oracle更改文件,ORACLE更改路径，重点在于修改控制文件

ORACLE更改路径，重点在于修改控制文件

1. 备份数据库中的数据，以防不测。

2. sqlplus /nolog

3. sql>connect internal

4. sql>alter database backup controlfile to trace; 备份控制文件

在D:oracleproduct10.2.0adminorcludump下可找到最新生成的TRACE文件

1.拷贝数据库全部文件

2.connect sys/system as sysdba

3.shutdown immediate

4.startup pfile=E:oracleorclinit.ora nomount 状态

5.数据文件

CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 'E:ORACLEORCLDATAREDO01.LOG' SIZE 50M,

GROUP 2 'E:ORACLEORCLDATAREDO02.LOG' SIZE 50M,

GROUP 3 'E:ORACLEORCLDATAREDO03.LOG' SIZE 50M

-- STANDBY LOGFILE

DATAFILE

'E:ORACLEORCLDATASYSTEM01.DBF',

'E:ORACLEORCLDATAFSM_CMS20081201.ORA',

'E:ORACLEORCLDATASYSAUX01.DBF',

'E:ORACLEORCLDATAUSERS01.DBF',

'E:ORACLEORCLDATAEXAMPLE01.DBF',

'E:ORACLEORCLDATAZMCS.ORA',

'E:ORACLEORCLDATAGJ.ORA',

'E:ORACLEORCLDATAFAXIN.ORA',

'E:ORACLEORCLDATAWWW.ORA',

'E:ORACLEORCLDATACRE.ORA',

'E:ORACLEORCLDATACRE1.ORA',

'E:ORACLEORCLDATAZHENGJIA.ORA',

'E:ORACLEORCLDATAUNDOTBS02.DBF',

'E:ORACLEORCLDATAFSM.ORA',

'E:ORACLEORCLDATAUNDOTBS03.DBF',

'E:ORACLEORCLDATATEMP.ORA',

'E:ORACLEORCLDATAXUECHONGJIE.ORA',

'E:ORACLEORCLDATACCYQ.ORA',

'E:ORACLEORCLDATAXXHCG.ORA'

CHARACTER SET ZHS16GBK

;

alter database open;