更改控制文件位置
create pfile from spfile;
shutdown immediate
修改pfile中控制文件路径,物理层面mv到新路径
create spfile from pfile;
startup;
#############################################################################
更改数据文件位置
shutdown immediate;
物理层面mv到新路径
startup mount;
alter database rename file '/原路径/原名称' to '/新路径/名称';
alter database open;
#############################################################################
更改redo位置
col status format a10;
select thread#, GROUP#,SEQUENCE#,BYTES/1024/1024,STATUS,FIRST_TIME from v$log;
Set linesize 200
col member format a50
select * from v$logfile;
alter database add logfile member '/新路径/原名称' to group 原组号;
alter system switch logfile;
alter database drop logfile member '/原路径/原名称';
物理层面rm掉
----------------------------------------------------------------------------
或者用修改redo大小的方法修改
create pfile from spfile;
shutdown immediate
修改pfile中控制文件路径,物理层面mv到新路径
create spfile from pfile;
startup;
#############################################################################
更改数据文件位置
shutdown immediate;
物理层面mv到新路径
startup mount;
alter database rename file '/原路径/原名称' to '/新路径/名称';
alter database open;
#############################################################################
更改redo位置
col status format a10;
select thread#, GROUP#,SEQUENCE#,BYTES/1024/1024,STATUS,FIRST_TIME from v$log;
Set linesize 200
col member format a50
select * from v$logfile;
alter database add logfile member '/新路径/原名称' to group 原组号;
alter system switch logfile;
alter database drop logfile member '/原路径/原名称';
物理层面rm掉
----------------------------------------------------------------------------
或者用修改redo大小的方法修改