利用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/