close

今天測試 將filesystem to asm 測試

安裝單機版Oracle asm 設定參數
建議值下
grid 變數環境
 
export PATH
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=+ASM
export ORACLE_BASE=/u02/app/grid
export ORACLE_HOME=/u02/app/11.2.0/grid
export ORACLE_TERM=xterm
export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
export LANG=en_US
export NLS_LANG=american_america.AL32UTF8
umask 022
 
Oracle 變數環境
 
oracle 要加入asmadmin group
 
export PATH
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=asm.localdomain
export ORACLE_SID=asm
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_UNQNAME=asm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
export LANG=en_US
export NLS_LANG=american_america.AL32UTF8
export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
umask 022
 
--------------------------------------------------------------------------------------------
 
SQL> select status from v$instance;
 
STATUS
------------
OPEN
 
SQL> alter system set control_files='+DATA/controlfile/control01.ctl' scope=spfile;
 
System altered.
 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>startup nomount;
 
將控制檔案轉入ASM裡面,利用好的controlfile恢復到ASM路徑內
 
RMAN> restore controlfile from '/u01/app/oracle/oradata/asm/control01.ctl'
2> ;
 
Starting restore at 2016/03/03 14:01:01
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
 
channel ORA_DISK_1: copied control file copy
output file name=+DATA/controlfile/control01.ctl
Finished restore at 2016/03/03 14:01:05
 
啟動到mount模式
 
RMAN> alter database mount
2> ;
 
database mounted
released channel: ORA_DISK_1
 
backup 使用copy模式 把database 拉進去ASM
 
RMAN> backup as copy database format '+DATA'
2> ;
 
Starting backup at 2016/03/03 14:02:34
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/asm/system01.dbf
output file name=+DATA/asm/datafile/system.258.905522555 tag=TAG20160303T140235 RECID=2 STAMP=905522581
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/asm/sysaux01.dbf
output file name=+DATA/asm/datafile/sysaux.259.905522591 tag=TAG20160303T140235 RECID=3 STAMP=905522612
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/asm/example01.dbf
output file name=+DATA/asm/datafile/example.260.905522615 tag=TAG20160303T140235 RECID=4 STAMP=905522624
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u01/app/oracle/oradata/asm/test1.dbf
output file name=+DATA/asm/datafile/test1.261.905522631 tag=TAG20160303T140235 RECID=5 STAMP=905522641
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/asm/undotbs01.dbf
output file name=+DATA/asm/datafile/undotbs1.262.905522645 tag=TAG20160303T140235 RECID=6 STAMP=905522649
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=+DATA/asm/datafile/test.256.905522009
output file name=+DATA/asm/datafile/test.263.905522653 tag=TAG20160303T140235 RECID=7 STAMP=905522655
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=+DATA/asm/controlfile/backup.264.905522657 tag=TAG20160303T140235 RECID=8 STAMP=905522657
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/asm/users01.dbf
output file name=+DATA/asm/datafile/users.265.905522659 tag=TAG20160303T140235 RECID=9 STAMP=905522659
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2016/03/03 14:04:20
channel ORA_DISK_1: finished piece 1 at 2016/03/03 14:04:21
piece handle=+DATA/asm/backupset/2016_03_03/nnsnf0_tag20160303t140235_0.266.905522661 tag=TAG20160303T140235 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2016/03/03 14:04:21
 
切換成copy的資料庫
 
RMAN> switch database to copy;
 
datafile 1 switched to datafile copy "+DATA/asm/datafile/system.258.905522555"
datafile 2 switched to datafile copy "+DATA/asm/datafile/sysaux.259.905522591"
datafile 3 switched to datafile copy "+DATA/asm/datafile/undotbs1.262.905522645"
datafile 4 switched to datafile copy "+DATA/asm/datafile/users.265.905522659"
datafile 5 switched to datafile copy "+DATA/asm/datafile/example.260.905522615"
datafile 6 switched to datafile copy "+DATA/asm/datafile/test1.261.905522631"
datafile 7 switched to datafile copy "+DATA/asm/datafile/test.263.905522653"
 
開啟資料庫
RMAN> alter database open
2> ;
 
database opened
 
 
 
將redolog轉移至ASM
 
SQL> alter database add logfile group 4 '+DATA/redolog/redo04.log' size 100m;
 
Database altered.
 
SQL> alter database add logfile group 5 '+DATA/redolog/redo05.log' size 100m;
 
Database altered.
 
SQL> alter database add logfile group 6 '+DATA/redolog/redo06.log' size 100m;
 
Database altered.
 
切到第4個 日誌
 
切換redo log
SQL> alter system switch logfile;
 
System altered.
 
SQL> select group#,status from v$log;
 
    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 INACTIVE
         3 INACTIVE
         4 CURRENT
         5 INACTIVE
         6 INACTIVE
 
6 rows selected.
 
PS 如果前三個有事active模式記得切換
alter database checkpoint;
 
刪除舊的日誌
SQL> alter database drop logfile group 1;
 
Database altered.
 
SQL> alter database drop logfile group 2;
 
Database altered.
 
SQL> alter database drop logfile group 3;
 
Database altered.
 
重建temp表空?
SQL> alter tablespace temp add tempfile '+DATA/datafile/TEMP01.DBF' size 100m;
 
Tablespace altered.
刪除舊的temp
SQL> alter tablespace temp drop tempfile '/u01/app/oracle/oradata/asm/temp01.dbf';
 
Tablespace altered.
 
察看視表
SQL> select file_name,tablespace_name from dba_temp_files;
 
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
+DATA/datafile/temp01.dbf
TEMP
 
可以多建置controlfile路徑(mount模式)在修改pfile檔案
 
SQL> alter database backup controlfile to '+DATA/controlfile/control02.ctl'
  2  ;
 
Database altered.
 
SQL>
SQL> alter database backup controlfile to '/u01/app/oracle/oradata/asm/control01.ctl';
 
Database altered.
 
SQL> select member from v$logfile;
 
MEMBER
--------------------------------------------------------------------------------
+DATA/redolog/redo04.log
+DATA/redolog/redo05.log
+DATA/redolog/redo06.log
 
SQL> select name from v$controlfile;
 
NAME
--------------------------------------------------------------------------------
+DATA/controlfile/control01.ctl
 
SQL> select name from v$datafile;
 
NAME
--------------------------------------------------------------------------------
+DATA/asm/datafile/system.258.905522555
+DATA/asm/datafile/sysaux.259.905522591
+DATA/asm/datafile/undotbs1.262.905522645
+DATA/asm/datafile/users.265.905522659
+DATA/asm/datafile/example.260.905522615
+DATA/asm/datafile/test1.261.905522631
+DATA/asm/datafile/test.263.905522653
 
7 rows selected.
 
 
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 jiade_Chen 的頭像
    jiade_Chen

    assistant engineer

    jiade_Chen 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄