oracle目录移动,oracle控制文件复制、移动方式

一、迁移步骤

1确定控制文件位置

SQL> select name from v$controlfile;

NAME

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

/oradata/V11/control01.ctl

SQL> shutdown immediate;

SQL> startup nomount;

2拷贝

$ rman target /

RMAN> restore controlfile to '/recovery_area/V11/control02.ctl' from

'/oradata/V11/control01.ctl';

--OR--

Copy the controlfile using OS-commands

%

cp /oradata/V11/control01.ctl /recovery_area/V11/control02.ctl

---Or----

dd if=/path/to/source_RLV

of=/path/to/target_RLV bs=4096 skip=? seek=?

3修改控制文件

SQL >alter system set

control_files=’/recovery_area/V11/control02.ctl’, ‘/oradata/V11/control01.ctl'

scope=spfile;

Note: If you have an init.ora simply update this to reflect the changes.

4启动数据库

SQL> startup mount force;

-- Note: selecting from v$controlfile will reflect the changes.

SQL> select name from v$controlfile;

NAME

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

/recovery_area/V11/control02.ctl

/oradata/V11/control01.ctl

SQL> alter database open;

二、迁移方式选择

迁移方式

支持类型

Rman

restore controlfile to '< NEW_PATH>'

from '';

File system

asm

Raw Logical Volumes

之前都支持

cp

File system

Asmcmd cp

+dg1/db11g/controlfile/Current.256.651275203

+dg1/db11g/controlfile/cf_copy

Asm

Dd

dd if=/path/to/source_RLV of=/path/to/target_RLV bs=4096

skip=? seek=?

Raw Logical

Volumes

File system

备注:

目的路径为ASM RMAN方式分两种:

1 Rman不指定名称

RMAN>restore controlfile to

'' from '';

Using ASMCMD:

$ asmcmd

ASMCMD> cd

ASMCMD> find -t controlfile . *

+DG1/P10R2/CONTROLFILE/backup.308.577785757

ASMCMD>

2 Rman指定名称

Asm实例下创建目录

SQL> alter diskgroup DG1 add directory

'+DG1/P10R2/CONTROLFILE';

或

ASMCMD>cd dg1

ASMCMD>mkdir controlfile

复制

restore controlfile to

'+DG1/PROD/controlfile/control02.ctl' from '/oradata2/102b/oradata/P10R2/control01.ctl';