{"id":273,"date":"2013-01-12T16:00:53","date_gmt":"2013-01-12T08:00:53","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=273"},"modified":"2013-01-22T23:24:33","modified_gmt":"2013-01-22T15:24:33","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e4%bb%8e%e9%9d%9easm%e5%88%b0asm%e7%9a%84%e8%bf%81%e7%a7%bb","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=273","title":{"rendered":"\u6570\u636e\u5e93\u4ece\u975eASM\u5230ASM\u7684\u8fc1\u79fb"},"content":{"rendered":"

\u6570\u636e\u5e93\u4ece\u975eASM\u5230ASM\u7684\u8fc1\u79fb
\n\u53c2\u8003\u6587\u6863
\nSteps To Migrate\/Move a Database From Non-ASM to ASM And Vice-Versa [ID 252219.1]
\nHow to duplicate a controlfile when ASM is involved [ID 345180.1]<\/p>\n

\u67e5\u770b\u6e90\u6587\u4ef6\u7cfb\u7edf<\/p>\n

SQL> select * from v$version where rownum<5;<\/p>\n

BANNER
\n----------------------------------------------------------------
\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
\nPL\/SQL Release 10.2.0.1.0 - Production
\nCORE 10.2.0.1.0 Production
\nTNS for Linux: Version 10.2.0.1.0 - Production<\/p>\n

SQL> conn test\/test
\nConnected.<\/p>\n

\u6d4b\u8bd5\u6570\u636e
\nSQL> create table test (id number,name varchar2(10));<\/p>\n

Table created.<\/p>\n

SQL> insert into test values (1,'yallonking');<\/p>\n

1 row created.<\/p>\n

SQL> commit;<\/p>\n

SQL> select file_name from dba_data_files;<\/p>\n

FILE_NAME
\n--------------------------------------------------------------------------------
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf<\/p>\n

\u67e5\u770bASM\u78c1\u76d8\u7ec4
\nSQL> select * from v$version where rownum<5;<\/p>\n

BANNER
\n----------------------------------------------------------------
\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
\nPL\/SQL Release 10.2.0.1.0 - Production
\nCORE 10.2.0.1.0 Production
\nTNS for Linux: Version 10.2.0.1.0 - Production<\/p>\n

SQL> !
\n[oracle@rhl5 ~]$ asmcmd
\nASMCMD> lsdg
\nState Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
\nMOUNTED EXTERN N N 512 4096 1048576 20480 20430 0 20430 0 DATA\/<\/p>\n

------------------------<\/p>\n

\u67e5\u770b\u5f53\u524d\u6587\u4ef6\u7cfb\u7edf\u7684\u63a7\u5236\u6587\u4ef6\u8def\u5f84
\nSQL> select name from v$controlfile;<\/p>\n

NAME
\n--------------------------------------------------------------------------------
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/control01.ctl
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/control02.ctl
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/control03.ctl<\/p>\n

SQL> shutdown immediate
\nDatabase closed.
\nDatabase dismounted.
\nORACLE instance shut down.
\nSQL> startup nomount
\nORACLE instance started.<\/p>\n

Total System Global Area 608174080 bytes
\nFixed Size 1220844 bytes
\nVariable Size 155193108 bytes
\nDatabase Buffers 448790528 bytes
\nRedo Buffers 2969600 bytes
\nSQL> !<\/p>\n

\u8f6c\u79fb\u63a7\u5236\u6587\u4ef6
\n[oracle@rhl5 ~]$ rman target \/<\/p>\n

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 21 00:56:47 2012<\/p>\n

Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n

connected to target database: ora10gr2 (not mounted)<\/p>\n

RMAN> restore controlfile to '+DATA' from '\/u01\/app\/oracle\/oradata\/ora10gr2\/control01.ctl';<\/p>\n

Starting restore at 21-AUG-12
\nusing channel ORA_DISK_1<\/p>\n

channel ORA_DISK_1: copied control file copy
\nFinished restore at 21-AUG-12<\/p>\n

\u67e5\u770b\u65b0\u7684\u63a7\u5236\u6587\u4ef6
\nASMCMD> pwd
\n+data
\nASMCMD> find -t controlfile . *
\n+data\/ORA10GR2\/CONTROLFILE\/backup.256.791859655<\/p>\n

\u4fee\u6539\u5f53\u524d\u7cfb\u7edf\u7684\u63a7\u5236\u6587\u4ef6\u53c2\u6570\u76f8\u5173
\nSQL> alter system set control_files='+data\/ORA10GR2\/CONTROLFILE\/backup.256.791859655' scope=spfile;<\/p>\n

System altered.<\/p>\n

SQL> shutdown immediate
\nORA-01507: database not mounted<\/p>\n

ORACLE instance shut down.<\/p>\n

SQL> startup mount;
\nORACLE instance started.<\/p>\n

Total System Global Area 608174080 bytes
\nFixed Size 1220844 bytes
\nVariable Size 155193108 bytes
\nDatabase Buffers 448790528 bytes
\nRedo Buffers 2969600 bytes
\nDatabase mounted.
\nSQL> !<\/p>\n

\u5c06\u6570\u636e\u5e93\u6587\u4ef6\u7cfb\u7edf\u5907\u4efd\u5230ASM\u78c1\u76d8\u7ec4
\n[oracle@rhl5 ~]$ rman target \/<\/p>\n

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 21 01:19:21 2012<\/p>\n

Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n

connected to target database: ORA10GR2 (DBID=4093928674, not open)<\/p>\n

RMAN> BACKUP AS COPY DATABASE FORMAT '+DATA';<\/p>\n

Starting backup at 21-AUG-12
\nusing target database control file instead of recovery catalog
\nallocated channel: ORA_DISK_1
\nchannel ORA_DISK_1: sid=151 devtype=DISK
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00001 name=\/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf
\noutput filename=+DATA\/ora10gr2\/datafile\/system.257.791860783 tag=TAG20120821T011941 recid=1 stamp=791860831
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:56
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00003 name=\/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf
\noutput filename=+DATA\/ora10gr2\/datafile\/sysaux.258.791860837 tag=TAG20120821T011941 recid=2 stamp=791860867
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:36
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00002 name=\/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf
\noutput filename=+DATA\/ora10gr2\/datafile\/undotbs1.259.791860873 tag=TAG20120821T011941 recid=3 stamp=791860876
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00005 name=\/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf
\noutput filename=+DATA\/ora10gr2\/datafile\/test.260.791860881 tag=TAG20120821T011941 recid=4 stamp=791860882
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00004 name=\/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf
\noutput filename=+DATA\/ora10gr2\/datafile\/users.261.791860885 tag=TAG20120821T011941 recid=5 stamp=791860885
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
\nchannel ORA_DISK_1: starting datafile copy
\ncopying current control file
\noutput filename=+DATA\/ora10gr2\/controlfile\/backup.262.791860885 tag=TAG20120821T011941 recid=6 stamp=791860886
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
\nchannel ORA_DISK_1: starting full datafile backupset
\nchannel ORA_DISK_1: specifying datafile(s) in backupset
\nincluding current SPFILE in backupset
\nchannel ORA_DISK_1: starting piece 1 at 21-AUG-12
\nchannel ORA_DISK_1: finished piece 1 at 21-AUG-12
\npiece handle=+DATA\/ora10gr2\/backupset\/2012_08_21\/nnsnf0_tag20120821t011941_0.263.791860889 tag=TAG20120821T011941 comment=NONE
\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
\nFinished backup at 21-AUG-12<\/p>\n

\u5c06\u6570\u636e\u5e93\u6587\u4ef6\u7cfb\u7edf\u5207\u6362\u5230ASM\u78c1\u76d8\u7ec4
\nRMAN> SWITCH DATABASE TO COPY;<\/p>\n

datafile 1 switched to datafile copy \"+DATA\/ora10gr2\/datafile\/system.257.791860783\"
\ndatafile 2 switched to datafile copy \"+DATA\/ora10gr2\/datafile\/undotbs1.259.791860873\"
\ndatafile 3 switched to datafile copy \"+DATA\/ora10gr2\/datafile\/sysaux.258.791860837\"
\ndatafile 4 switched to datafile copy \"+DATA\/ora10gr2\/datafile\/users.261.791860885\"
\ndatafile 5 switched to datafile copy \"+DATA\/ora10gr2\/datafile\/test.260.791860881\"<\/p>\n

\u4fee\u6539\u4e34\u65f6\u6587\u4ef6
\n\/*
\nrun {
\nset newname for tempfile 1 to '+DATA';
\nset newname for tempfile 2 to '+DATA';
\n...
\nswitch tempfile all;
\n}
\n*\/<\/p>\n

RMAN> ALTER DATABASE OPEN;<\/p>\n

database opened<\/p>\n

\u9010\u6b65\u66ff\u6362\u65e5\u5fd7\u6587\u4ef6
\n[oracle@rhl5 ~]$ sqlplus \/nolog<\/p>\n

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 21 01:27:35 2012<\/p>\n

Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n

SQL> conn \/as sysdba
\nConnected.
\nSQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE a.group#=b.group#;<\/p>\n

GROUP#
\n----------
\nMEMBER
\n--------------------------------------------------------------------------------
\nSTATUS
\n----------------
\n3
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/redo03.log
\nINACTIVE<\/p>\n

2
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/redo02.log
\nUNUSED<\/p>\n

GROUP#
\n----------
\nMEMBER
\n--------------------------------------------------------------------------------
\nSTATUS
\n----------------<\/p>\n

1
\n\/u01\/app\/oracle\/oradata\/ora10gr2\/redo01.log
\nCURRENT<\/p>\n

SQL> ALTER DATABASE ADD LOGFILE MEMBER '+DATA' TO GROUP 1;<\/p>\n

Database altered.<\/p>\n

SQL> ALTER DATABASE ADD LOGFILE MEMBER '+DATA' TO GROUP 2;<\/p>\n

Database altered.<\/p>\n

SQL> ALTER DATABASE ADD LOGFILE MEMBER '+DATA' TO GROUP 3;<\/p>\n

Database altered.<\/p>\n

SQL> alter system checkpoint;<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE a.group#=b.group#;<\/p>\n

GROUP# MEMBER STATUS
\n---------- --------------------------------------------- ----------------
\n3 \/u01\/app\/oracle\/oradata\/ora10gr2\/redo03.log INACTIVE
\n2 \/u01\/app\/oracle\/oradata\/ora10gr2\/redo02.log CURRENT
\n1 \/u01\/app\/oracle\/oradata\/ora10gr2\/redo01.log INACTIVE
\n1 +DATA\/ora10gr2\/onlinelog\/group_1.264.79186145 INACTIVE
\n9<\/p>\n

2 +DATA\/ora10gr2\/onlinelog\/group_2.265.79186146 CURRENT
\n7<\/p>\n

3 +DATA\/ora10gr2\/onlinelog\/group_3.266.79186148 INACTIVE
\n3<\/p>\n

GROUP# MEMBER STATUS
\n---------- --------------------------------------------- ----------------<\/p>\n

6 rows selected.<\/p>\n

SQL> ALTER DATABASE DROP LOGFILE MEMBER '\/u01\/app\/oracle\/oradata\/ora10gr2\/redo03.log';<\/p>\n

Database altered.<\/p>\n

SQL> ALTER DATABASE DROP LOGFILE MEMBER '\/u01\/app\/oracle\/oradata\/ora10gr2\/redo01.log';<\/p>\n

Database altered.<\/p>\n

SQL> alter system switch logfile;<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> alter system checkpoint;<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> \/<\/p>\n

System altered.<\/p>\n

SQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE a.group#=b.group#;<\/p>\n

GROUP# MEMBER STATUS
\n---------- --------------------------------------------- ----------------
\n2 \/u01\/app\/oracle\/oradata\/ora10gr2\/redo02.log INACTIVE
\n1 +DATA\/ora10gr2\/onlinelog\/group_1.264.79186145 INACTIVE
\n9<\/p>\n

2 +DATA\/ora10gr2\/onlinelog\/group_2.265.79186146 INACTIVE
\n7<\/p>\n

3 +DATA\/ora10gr2\/onlinelog\/group_3.266.79186148 CURRENT
\n3<\/p>\n

SQL> ALTER DATABASE DROP LOGFILE MEMBER '\/u01\/app\/oracle\/oradata\/ora10gr2\/redo02.log';<\/p>\n

Database altered.<\/p>\n

\u9a8c\u8bc1\u7ed3\u679c
\nSQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE a.group#=b.group#;<\/p>\n

GROUP# MEMBER STATUS
\n---------- --------------------------------------------- ----------------
\n1 +DATA\/ora10gr2\/onlinelog\/group_1.264.79186145 INACTIVE
\n9<\/p>\n

2 +DATA\/ora10gr2\/onlinelog\/group_2.265.79186146 INACTIVE
\n7<\/p>\n

3 +DATA\/ora10gr2\/onlinelog\/group_3.266.79186148 CURRENT
\n3
\nSQL> select file_name from dba_data_files;<\/p>\n

FILE_NAME
\n--------------------------------------------------------------------------------
\n+DATA\/ora10gr2\/datafile\/users.261.791860885
\n+DATA\/ora10gr2\/datafile\/sysaux.258.791860837
\n+DATA\/ora10gr2\/datafile\/undotbs1.259.791860873
\n+DATA\/ora10gr2\/datafile\/system.257.791860783
\n+DATA\/ora10gr2\/datafile\/test.260.791860881<\/p>\n

SQL> conn test\/test
\nConnected.
\nSQL> select * from test;<\/p>\n

ID NAME
\n---------- ----------
\n1 yallonking<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6570\u636e\u5e93\u4ece\u975eASM\u5230ASM\u7684\u8fc1\u79fb \u53c2\u8003\u6587\u6863 Steps To Migrate\/Move a Database F […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,32],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/273"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=273"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/273\/revisions"}],"predecessor-version":[{"id":634,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/273\/revisions\/634"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=273"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}