oracle11g数据文件路径,oracle11g修改控制文件路径

1.查看路径

SQL> show parameter control;

NAME     TYPE

------------------------------------ ----------------------

VALUE

------------------------------

control_file_record_keep_time     integer

7

control_files     string

/home/app/oracle/oradata/orahq

/control01.ctl, /home/app/orac

le/fast_recovery_area/orahq/co

ntrol02.ctl

control_management_pack_access     string

DIAGNOSTIC+TUNING

2.修改参数文件

SQL> alter system set control_files='/alidata1/oradata/orahq/control01.ctl','/alidata1/oradata/orahq/control02.ctl' scope=spfile;

System altered.

3.重启数据库

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 2.1379E+10 bytes

Fixed Size    2262656 bytes

Variable Size

1677724032 bytes

Database Buffers

1.9663E+10 bytes

Redo Buffers   36073472 bytes

Database mounted.

Database opened.

4.mv

[oracle@oraclerac1 ~]$ mv /home/app/oracle/oradata/orahq/control01.ctl /alidata1/oradata/orahq/control01.ctl

[oracle@oraclerac1 ~]$ mv /home/app/oracle/fast_recovery_area/orahq/control02.ctl /alidata1/oradata/orahq/control02.ctl

5.查看是否修改成功

SQL> show parameter control;

NAME     TYPE

------------------------------------ ----------------------

VALUE

------------------------------

control_file_record_keep_time     integer

7

control_files     string

/alidata1/oradata/orahq/contro

l01.ctl, /alidata1/oradata/ora

hq/control02.ctl

control_management_pack_access     string

DIAGNOSTIC+TUNING