HPUNIX下表空间文件系统到裸设备测试

最新推荐文章于 2025-07-05 13:15:07 发布

转载最新推荐文章于 2025-07-05 13:15:07 发布 · 81 阅读

本文详细介绍了如何在裸设备与文件系统之间进行数据迁移操作，包括从裸设备移动到文件系统，从文件系统移动到裸设备的过程，并通过Oracle数据库实例展示了具体步骤与操作效果。

创建裸设备
# lvcreate -L 1024 -n lvtest vg00
Logical volume "/dev/vg00/lvtest" has been successfully created with
character device "/dev/vg00/rlvtest".
Logical volume "/dev/vg00/lvtest" has been successfully extended.
Volume Group configuration for /dev/vg00 has been saved in /etc/lvmconf/vg00.conf[@more@]

# ls -l | grep test
brw-r----- 1 root sys 64 0x000014 Aug 17 19:20 lvtest
crw-r----- 1 root sys 64 0x000014 Aug 17 19:20 rlvtest
#chown oracle:dba rlvtest
# ls -l | grep test
brw-r----- 1 root sys 64 0x000014 Aug 17 19:20 lvtest
crw-r----- 1 oracle dba 64 0x000014 Aug 17 19:20 rlvtest

1.先从裸设备移动到文件系统上
SQL> alter tablespace guyuanli offline;

Tablespace altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@cp-cs02 /oracle/app/product/11.1.0/db_1/network/admin $ rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Wed Aug 18 11:51:34 2010

connected to target database: TSDB (DBID=3914389360)

RMAN> copy datafile '/dev/vg00/rlvtest' to '/oracle/app/gutest.dbf';

Starting backup at 18-AUG-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1556 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00077 name=/dev/vg00/rlvtest
output file name=/oracle/app/gutest.dbf tag=TAG20100818T115303 RECID=2 STAMP=727357987
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 18-AUG-10

RMAN> exit

Recovery Manager complete.
oracle@cp-cs02 /oracle/app/product/11.1.0/db_1/network/admin $ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Aug 18 11:53:22 2010

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database rename file '/dev/vg00/rlvtest' to '/oracle/app/gutest.dbf';

Database altered.

SQL> alter tablespace guyuanli online;

Tablespace altered.

SQL> select count(*) from guyuanli;

COUNT(*)
----------
71399

2.从文件系统移动到裸设备上
oracle@cp-cs02 /dev/vg00 $ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Aug 18 12:13:08 2010

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter tablespace guyuanli offline;

Tablespace altered.
oracle@cp-cs02 /dev/vg00 $ rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Wed Aug 18 12:15:17 2010

connected to target database: TSDB (DBID=3914389360)

RMAN> copy datafile '/oracle/app/gutest.dbf' to '/dev/vg00/rlvtest';

Starting backup at 18-AUG-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1553 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00077 name=/oracle/app/gutest.dbf
output file name=/dev/vg00/rlvtest tag=TAG20100818T121532 RECID=3 STAMP=727359332
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 18-AUG-10

RMAN> exit

Recovery Manager complete.
oracle@cp-cs02 /dev/vg00 $ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Aug 18 12:15:58 2010

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database rename file '/oracle/app/gutest.dbf' to '/dev/vg00/rlvtest';

Database altered.

SQL> alter tablespace guyuanli online;

Tablespace altered.

SQL> select count(*) from guyuanli;

COUNT(*)
----------
71399

最后把文件系统的文件手工删除
oracle@cp-cs02 /dev/vg00 $ cd /oracle/app/
oracle@cp-cs02 /oracle/app $ ls
admin cfgtoollogs diag eygle01.dbf gutest.dbf product
oracle@cp-cs02 /oracle/app $ rm gutest.dbf

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

转载于:http://blog.itpub.net/7490392/viewspace-1037428/