ASM数据库迁移（数据库从文件系统迁移到ASM)

最新推荐文章于 2021-04-03 11:00:31 发布

congwei2855

最新推荐文章于 2021-04-03 11:00:31 发布

阅读量186

点赞数

文章标签：数据库

迁移前检查

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 830930944 bytes

Fixed Size 2257800 bytes

Variable Size 536874104 bytes

Database Buffers 285212672 bytes

Redo Buffers 6586368 bytes

Database mounted.

Database opened.

SQL> select name,open_mode,log_mode from v$database;

NAME OPEN_MODE LOG_MODE

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

ENMOEDU READ WRITE NOARCHIVELOG

SQL> show parameter pfile;

NAME TYPE VALUE

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

spfile string /u01/app/oracle/product/11.2.0

.db_1/dbs/spfileenmoedu.ora

SQL> select name from v$controlfile

2 union all

3 select name from v$datafile

4 union all

5 select member from v$logfile;

NAME

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

/u01/app/oracle/oradata/enmoedu/control01.ctl

/u01/app/oracle/fast_recovery_area/enmoedu/control02.ctl

/u01/app/oracle/oradata/enmoedu/system01.dbf

/u01/app/oracle/oradata/enmoedu/sysaux01.dbf

/u01/app/oracle/oradata/enmoedu/undotbs01.dbf

/u01/app/oracle/oradata/enmoedu/users01.dbf

/u01/app/oracle/oradata/enmoedu/example01.dbf

/u01/app/oracle/oradata/enmoedu/redo03.log

/u01/app/oracle/oradata/enmoedu/redo02.log

/u01/app/oracle/oradata/enmoedu/redo01.log

10 rows selected.

SQL> show parameter db_recovery_file_dest;

NAME TYPE VALUE

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

db_recovery_file_dest string /u01/app/oracle/fast_recovery_

area

db_recovery_file_dest_size big integer 4182M

003 迁移前检查

检查以下ASM相关设置

[grid@enmoedu grid]$ oracleasm querydisk -p data

Disk "DATA" does not exist or is not instantiated不存在，似乎是因为disk是由两个磁盘分区组成的，所以没显示出来，下同

[grid@enmoedu grid]$ oracleasm querydisk -p fls

Disk "FLS" does not exist or is not instantiated

[grid@enmoedu grid]$ asmcmd -p lsct

[grid@enmoedu grid]$ asmcmd -p lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED NORMAL N 512 4096 1048576 6134 6014 0 3007 0 N DATA/

MOUNTED NORMAL N 512 4096 1048576 6134 6028 0 3014 0 N FLS/

当前ASM磁盘组已经分配完毕，使用率0%，没有分配空间给任何实例。

数据库参数更改

SQL> alter system set control_files='+data','+fls' scope=spfile;控制文件位置

System altered.

SQL> alter system set db_create_file_dest='+data';数据文件位置

System altered.

DB_CREATE_FILE_DEST specifies the default

location for Oracle-managed datafiles. This location is also used as the default location for Oracle-managed control files and online redo logs if none

of the DB_CREATE_ONLINE_LOG_DEST_n initialization parameters are specified.

SQL> alter system set db_create_online_log_dest_1='+data';联机重做日志文件位置1

System altered.

SQL> alter system set db_create_online_log_dest_2='+fls'; 联机重做日志文件位置2

System altered.

SQL> alter system set db_recovery_file_dest='+fls'; 快速恢复区的位置

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

004 实施迁移

[oracle@enmoedu ~]$ rman

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 26 16:31:33 2016

RMAN> connect target

connected to target database (not started)

RMAN> startup nomount

Oracle instance started

Total System Global Area 830930944 bytes

Fixed Size 2257800 bytes

Variable Size 536874104 bytes

Database Buffers 285212672 bytes

Redo Buffers 6586368 bytes

RMAN> restore controlfile from '/u01/app/oracle/oradata/enmoedu/control01.ctl';

Starting restore at 26-FEB-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=137 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=+DATA/enmoedu/controlfile/current.256.904840405

output file name=+FLS/enmoedu/controlfile/current.256.904840405

Finished restore at 26-FEB-16

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> backup as copy database format '+data';

Starting backup at 26-FEB-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=137 device type=DISK