利用rman copy改变数据文件的路径

最新推荐文章于 2021-10-11 09:16:56 发布

转载最新推荐文章于 2021-10-11 09:16:56 发布 · 200 阅读

文章标签：

#数据库

本文介绍如何通过Oracle的RMAN工具来更改数据库中数据文件的存储位置。具体步骤包括关闭数据库并重启至mount状态，使用RMAN命令复制数据文件至新位置，并切换至新的数据文件。

部署运行你感兴趣的模型镜像

利用rman copy改变数据文件的路径

SQL> col file_name for a70
SQL> select file_name,tablespace_name,autoextensible,bytes/1024/1024 mb from dba_data_files;

FILE_NAME TABLESPACE_NAME AUT MB
---------------------------------------------------------------------- ------------------------------ --- ----------
/u01/oradata/orcl/users01.dbf USERS YES 5
/u01/oradata/orcl/sysaux01.dbf SYSAUX YES 240
/u01/oradata/orcl/undotbs01.dbf UNDOTBS1 YES 230
/u01/oradata/orcl/system01.dbf SYSTEM YES 490
/u01/oradata/orcl/example01.dbf EXAMPLE YES 100
/u01/example01.dbf EXAMPLE01 YES 100

6 rows selected.

本实验目的是将/u01/example01.dbf文件的修改为/u01/oradata/orcl/exam01.dbf

===================================================================================================================

窗口1：
关闭数据库，再启动到mount状态

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount;
ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size 1274668 bytes
Variable Size 163581140 bytes
Database Buffers 356515840 bytes
Redo Buffers 2916352 bytes
Database mounted.

窗口2：
[oracle@rhel ~]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Mon Jul 26 13:36:32 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1248123623, not open)

RMAN>

RMAN> copy datafile '/u01/example01.dbf' to '/u01/oradata/orcl/exam01.dbf';

Starting backup at 26-JUL-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00006 name=/u01/example01.dbf
output filename=/u01/oradata/orcl/exam01.dbf tag=TAG20100726T133716 recid=13 stamp=725377039
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:04
Finished backup at 26-JUL-10

RMAN>

RMAN> switch datafile '/u01/example01.dbf' to copy;

datafile 6 switched to datafile copy "/u01/oradata/orcl/exam01.dbf"

RMAN>

回到窗口1：
再打开数据库，查看路径，已经该变

SQL> alter database open;

Database altered.

SQL> col file_name for a70
SQL> select file_name,tablespace_name,autoextensible,bytes/1024/1024 mb from dba_data_files;

FILE_NAME TABLESPACE_NAME AUT MB
---------------------------------------------------------------------- ------------------------------ --- ----------
/u01/oradata/orcl/users01.dbf USERS YES 5
/u01/oradata/orcl/sysaux01.dbf SYSAUX YES 240
/u01/oradata/orcl/undotbs01.dbf UNDOTBS1 YES 230
/u01/oradata/orcl/system01.dbf SYSTEM YES 490
/u01/oradata/orcl/example01.dbf EXAMPLE YES 100
/u01/oradata/orcl/exam01.dbf EXAMPLE01 YES 100

6 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24626891/viewspace-2083029/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24626891/viewspace-2083029/

您可能感兴趣的与本文相关的镜像