如何通过RMAN进行裸设备和文件系统之间的数据文件迁移
[oracle@danaly ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 14:41:53 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
SQL> create tablespace eygle datafile '/dev/cciss/c0d0p11' size 10M;
Tablespace created.
SQL> create table eygle tablespace eygle as select * from dba_objects;
Table created.
SQL> select count(*) from eygle;
COUNT(*)
----------
50420
SQL> alter tablespace eygle offline;
Tablespace altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
2.使用RMAN的COPY功能备份裸设备文件为文件系统文件
[oracle@danaly ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Nov 30 16:00:42 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DANALY (DBID=3965153484)
RMAN> copy datafile '/dev/cciss/c0d0p11' to '/opt/oracle/eygle01.dbf';
Starting backup at 30-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/dev/cciss/c0d0p11
output filename=/opt/oracle/eygle01.dbf tag=TAG20051130T160137 recid=2 stamp=575740898
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:02
Finished backup at 30-NOV-05
RMAN> exit
Recovery Manager complete.
3.通过rename修改文件位置
[oracle@danaly ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 16:01:54 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
SQL> alter database rename file '/dev/cciss/c0d0p11' to '/opt/oracle/eygle01.dbf';
Database altered.
SQL> alter tablespace eygle online;
Tablespace altered.
SQL> select file_name from dba_data_files where tablespace_name='EYGLE';
FILE_NAME
--------------------------------------------------------------------------------
/opt/oracle/eygle01.dbf
4.进行数据修改
SQL> insert into eygle as select * from eygle;
insert into eygle as select * from eygle *
ERROR at line 1:
ORA-00926: missing VALUES keyword
SQL> insert into eygle select * from eygle;
insert into eygle select * from eygle
*
ERROR at line 1:
ORA-01653: unable to extend table SYS.EYGLE by 128 in tablespace EYGLE
SQL> alter database datafile '/opt/oracle/eygle01.dbf' resize 20m;
Database altered.
SQL> insert into eygle select * from eygle;
50420 rows created.
SQL> commit;
Commit complete.
SQL> alter tablespace eygle offline;
Tablespace altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
5.从文件系统迁移文件至裸设备
[oracle@danaly ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Nov 30 16:08:51 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DANALY (DBID=3965153484)
RMAN> copy datafile '/opt/oracle/eygle01.dbf' to '/dev/cciss/c0d0p11';
Starting backup at 30-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=135 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/opt/oracle/eygle01.dbf
output filename=/dev/cciss/c0d0p11 tag=TAG20051130T160935 recid=3 stamp=575741376
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 30-NOV-05
RMAN> exit
Recovery Manager complete.
[oracle@danaly ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 16:09:48 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
SQL> alter database rename file '/opt/oracle/eygle01.dbf' to '/dev/cciss/c0d0p11';
Database altered.
SQL> alter tablespace eygle online;
Tablespace altered.
SQL> select count(*) from eygle;
COUNT(*)
----------
100840
SQL>
