asm 檔案系統遷移

此文是在oracle10g的基礎上，將從到管理的檔案系統上。

一、環境：

OS :

[oracle@yitai ~]$ lsb_release --all
LSB Version:    :core-3.0-ia32:core-3.0-noarch:graphics-3.0-ia32:graphics-3.0-noarch
Distributor ID: RedHatEnterpriseAS
Description:    Red Hat Enterprise Linux AS release 4 (Nahant Update 7)
Release:        4
Codename:       NahantUpdate7

RDBMS:

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

ASM:(這裡使用磁碟組DATA2)

SQL> select name, state, type from v$asm_diskgroup;

NAME                           STATE       TYPE
------------------------------ ----------- ------
DATA1                          MOUNTED     EXTERN
DATA2                          MOUNTED     EXTERN

[oracle@yitai ~]$ export ORACLE_SID=+ASM
[oracle@yitai ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  EXTERN  N      N         512   4096  1048576      2038      763                0             763              0  DATA1/
MOUNTED  EXTERN  N      N         512   4096  1048576      2038      929                0             929              0  DATA2/

二、遷移前檢視rdbms的資訊

檢視當前檔案系統的控制檔案路徑

SQL> select name from v$controlfile;

NAME
-------------------------------------------------------------------------------
/u01/app/oracle/oradata/prod/control01.ctl
/u01/app/oracle/oradata/prod/control02.ctl
/u01/app/oracle/oradata/prod/control03.ctl

檢視臨時檔案資訊

SQL>SQL> select  file#,  name  from v$tempfile;
FILE#, NAME
 --   --------------------------------------------------------------------------------
  1   /u01/app/oracle/oradata/prod/temp01.dbf

檢視日誌檔案資訊：

SQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE a.group#=b.group#;

    GROUP# MEMBER                                                       STATUS
---------- ------------------------------------------------------------ ----------------
         1 /u01/app/oracle/oradata/prod/redo01.log                  CURRENT
         2 /u01/app/oracle/oradata/prod/redo02.log                  INACTIVE
         3 /u01/app/oracle/oradata/prod/redo03.log               INACTIVE

檢視資料檔案位置：

SQL> select name from v$datafile;

NAME

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

 /u01/app/oracle/oradata/prod//system01.dbf
 /u01/app/oracle/oradata/prod/undotbs01.dbf
 /u01/app/oracle/oradata/prod/sysaux01.dbf
 /u01/app/oracle/oradata/prod//users01.dbf
 /u01/app/oracle/oradata/prod//example01.dbf

 

三、利用RMAN工具遷移

export ORACLE_SID=prod

SQL > shutdown immediate

SQL > startup nomount    #rdbms操作控制檔案的時候，需要進入nomount狀態

[oracle@yitai ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 28 08:01:45 2012

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

connected to target database: CUUG (DBID=1247937484)

轉移控制檔案

RMAN> restore controlfile to '+DATA2' from '/u01/app/oracle/oradata/prod/control01.ctl';

檢視新的控制檔案

ASMCMD> cd +DATA2
ASMCMD> ls
PROD/
DB_UNKNOWN/
ASMCMD> cd  prod
ASMCMD> ls
CONTROLFILE/
ASMCMD> find -t controlfile . *
+DATA2/prod/CONTROLFILE/Backup.262.792483465
+DATA2/prod/CONTROLFILE/backup.256.792483231

 

修改當前系統的控制檔案引數相關

SQL> ALTER DATABASE DROP LOGFILE MEMBER '/u01/app/oracle/oradata/prod/redo03.log';

SQL> ALTER DATABASE DROP LOGFILE MEMBER '/u01/app/oracle/oradata/prod/redo02.log';