理解ASM（七）ASM迁移

 

环境：

 

sys@ORCL> select * from v$version; 
 
BANNER 
---------------------------------------------------------------- 
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod 
 
sys@ORCL> !uname 
Linux 

 

          ⑴ 修改控制文件的位置

 

sys@ORCL> show parameter control_files 
 
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------  
control_files                        string      /u01/app/oracle/oradata/ORCL/c 
                                                 ontrolfile/o1_mf_8050hgfp_.ctl 
                                                 , /u01/app/oracle/flash_recove 
                                                 ry_area/ORCL/controlfile/o1_mf 
                                                 _8050hgqh_.ctl 
 
 
sys@ORCL> alter database backup controlfile to '/home/oracle/ctlasm.ctl'; 
 
 
sys@ORCL> alter system set control_files='+WATER' scope=spfile; 
 
 
sys@ORCL> shutdown immediate; 

 

 

          ⑵ 数据文件迁移

RMAN> startup nomount 
 
RMAN> restore controlfile from '/home/oracle/ctlasm.ctl'; 
 
RMAN> alter database mount; 
 
RMAN> backup as copy database format '+WATER';  
 
RMAN> recover database; 
 
RMAN> switch database to copy; 

 

 

          ⑶ 日志文件迁移

idle> conn / as sysdba 
 
idle> alter database open resetlogs; 
 
idle> alter database add logfile group 4 '+WATER/redo04.log' size 50m; 
 
 
idle> alter database add logfile group 5 '+WATER/redo05.log' size 50m; 
 
 
idle> alter database add logfile group 6 '+WATER/redo06.log' size 50m; 
 
idle> select group#,status from v$log; 
 
    GROUP# STATUS 
---------- ----------------  
         1 UNUSED 
         2 CURRENT 
         3 UNUSED 
         4 UNUSED 
         5 UNUSED 
         6 UNUSED 
 
idle> alter system switch logfile; 
 
 
idle> alter system switch logfile; 
 
 
idle> alter system switch logfile; 
 
idle> select group#,status from v$log; 
 
    GROUP# STATUS 
---------- ----------------  
         1 ACTIVE 
         2 ACTIVE 
         3 ACTIVE 
         4 ACTIVE 
         5 ACTIVE 
         6 CURRENT 
 
idle> alter system checkpoint; 
 
idle> alter database drop logfile group 1; 
 
 
idle> alter database drop logfile group 2; 
 
 
idle> alter database drop logfile group 3; 
 
 
idle> select member from v$logfile; 
 
MEMBER 
----------------------------------------------------------------------------------------------------  
+WATER/redo04.log 
+WATER/redo05.log 
+WATER/redo06.log 

 

 

          ⑷ 临时文件迁移

sys@ORCL> select file_name,tablespace_name from dba_temp_files; 
 
FILE_NAME                                                         TABLESPACE_NAME 
----------------------------------------------------------------- ------------------------------  
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j34j_.tmp    TEMP 
 
sys@ORCL> alter tablespace temp add tempfile '+WATER'; 
 
sys@ORCL>  select file_name,tablespace_name from dba_temp_files; 
 
FILE_NAME                                                         TABLESPACE_NAME 
----------------------------------------------------------------- ------------------------------  
+WATER/orcl/tempfile/temp.265.798479421                           TEMP 
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j34j_.tmp    TEMP 
 
sys@ORCL> alter tablespace temp drop tempfile '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j34j_.tmp'; 

 

 

          ⑸ 修改db_create_file_dest，db_recovery_file_dest，db_recovery_file_dest_size 的值

sys@ORCL> alter system set db_create_file_dest='+WATER/ORCL/ORADATA' scope=spfile; 
 
 
sys@ORCL> alter system set db_recovery_file_dest='+WATER' scope=spfile; 
 
 
sys@ORCL> alter system set db_recovery_file_dest_size=1 G scope=spfile; 
 
 
sys@ORCL> alter database backup controlfile to '+WATER'; --迁移时，只有一个控制文件  
 
 
sys@ORCL> show parameter control 
 
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------  
control_file_record_keep_time        integer     7 
control_files                        string      +WATER/orcl/controlfile/curren 
                                                 t.256.798477831 

 

 

          ⑹ 修改参数文件并迁移spfile

sys@ORCL> alter system set control_files='+WATER/ORCL/ORADATA/CONTROL01.CTL','+WATER/ORCL/ORADATA/CONTROL02.CTL' scope=spfile; 
 
sys@ORCL> create spfile='+WATER/ORCL/spfileorcl.ora' from pfile; 
 
[oracle@localhost dbs]$ rm -i spfileorcl.ora 
 
[oracle@localhost dbs]$ vim initorcl.ora  
 
[oracle@localhost dbs]$ tail -f initorcl.ora  
*.job_queue_processes=10 
*.open_cursors=300 
*.pga_aggregate_target=139460608 
*.processes=150 
*.remote_login_passwordfile='NONE' 
*.sga_target=418381824 
*.undo_management='AUTO' 
*.undo_tablespace='UNDOTBS1' 
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump' 
SPFILE='+WATER/ORCL/spfileorcl.ora' 

 

 

          ⑺ 检查ASM实例和数据库实例连接情况

ASMCMD> lsct 
DB_Name   Status        Software_Version  Compatible_version  Instance_Name 
orcl      CONNECTED           10.2.0.1.0          10.2.0.1.0  orcl 

 

 

          小结：

              第一次迁移时失败，原因是仅作学习之用，磁盘组空间太小，大家如果空间富裕，不妨慷慨些。

       
       
       
（以上内容摘于网络，如有侵权，请告之，将第一时间删除）