溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

文件系統(tǒng)怎樣遷移到ASM

發(fā)布時(shí)間：2021-11-30 15:34:14 來源：億速云 閱讀：131 作者：柒染 欄目：關(guān)系型數(shù)據(jù)庫

文件系統(tǒng)怎樣遷移到ASM，很多新手對(duì)此不是很清楚，為了幫助大家解決這個(gè)難題，下面小編將為大家詳細(xì)講解，有這方面需求的人可以來學(xué)習(xí)下，希望你能有所收獲。

數(shù)據(jù)庫全備 僅僅是一個(gè)databse的全備，沒有任何額外的附加功能，僅
0 級(jí) 增量備份 既是數(shù)據(jù)庫的全備，又是，0級(jí)增量備份，在此基礎(chǔ)上，可以后續(xù)執(zhí)行增量備份
結(jié)論 因此推薦使用0級(jí)增量備份做數(shù)據(jù)庫的全備

最好是以grid用戶進(jìn)入asm 環(huán)境

  1. [oracle@sink ~]$ su - grid

  2. Password:

  3. [grid@sink ~]$ asmcmd

做完 0 級(jí) 增量備份后的備份文件

  1. ASMCMD> pwd

  2. +data/sink

  3. ASMCMD> ls

  4. BACKUPSET/

  5. CONTROLFILE/

  6. DATAFILE/

  7. PARAMETERFILE/

查看剛才做的 0級(jí)增量 備份

  1. RMAN> list copy of database;


  3. List of Datafile Copies

  4. =======================


  6. Key File S Completion Time Ckp SCN    Ckp Time

  7. ------- ---- - --------------- ---------- ---------------

  8. 9       1    A 06-JAN-18       1218041    06-JAN-18

  9.         Name: +DATA/sink/datafile/system.258.964712643

  10.         Tag: ORA_ASM_MIGRATION


  12. 8       2    A 06-JAN-18       1218040    06-JAN-18

  13.         Name: +DATA/sink/datafile/sysaux.257.964712643

  14.         Tag: ORA_ASM_MIGRATION


  16. 4       3    A 06-JAN-18       1218045    06-JAN-18

  17.         Name: +DATA/sink/datafile/undotbs1.261.964712645

  18.         Tag: ORA_ASM_MIGRATION


  20. 6       4    A 06-JAN-18       1218050    06-JAN-18

  21.         Name: +DATA/sink/datafile/users.263.964712657

  22.         Tag: ORA_ASM_MIGRATION


  24. 7       5    A 06-JAN-18       1218043    06-JAN-18

  25.         Name: +DATA/sink/datafile/example.260.964712643

  26.         Tag: ORA_ASM_MIGRATION


  28. 3       6    A 06-JAN-18       1218042    06-JAN-18

  29.         Name: +DATA/sink/datafile/tbssss.259.964712643

  30.         Tag: ORA_ASM_MIGRATION



  33. RMAN>

轉(zhuǎn)儲(chǔ)spfile到

  1. RMAN> restore spfile to '+DATA/spfilesink.ora';


  3. Starting restore at 06-JAN-18

  4. using target database control file instead of recovery catalog

  5. allocated channel: ORA_DISK_1

  6. channel ORA_DISK_1: SID=18 device type=DISK


  8. channel ORA_DISK_1: starting datafile backup set restore

  9. channel ORA_DISK_1: restoring SPFILE

  10. output file name=+DATA/spfilesink.ora

  11. channel ORA_DISK_1: reading from backup piece +DATA/sink/backupset/2018_01_06/nnsnn0_ora_asm_migration_0.264.964712657

  12. channel ORA_DISK_1: piece handle=+DATA/sink/backupset/2018_01_06/nnsnn0_ora_asm_migration_0.264.964712657 tag=ORA_ASM_MIGRATION

  13. channel ORA_DISK_1: restored backup piece 1

  14. channel ORA_DISK_1: restore complete, elapsed time: 00:00:04

  15. Finished restore at 06-JAN-18

查看轉(zhuǎn)儲(chǔ)spfile參數(shù)文件后的  在ASM中的 路徑狀態(tài)

  1. ASMCMD> pwd

  2. +data

  3. ASMCMD> ls

  4. ASM/

  5. SINK/

  6. spfilesink.ora

  7. ASMCMD>

修改并查看pfile中的內(nèi)容，使其內(nèi)容指向ASM中spfile的spfilesink.ora的路徑，有意思！

  1. [oracle@sink dbs]$ pwd

  2. /u01/app/oracle/product/11.2.0/dbhome_1/dbs

  3. [oracle@sink dbs]$ ls

  4. afiedt.buf   hc_test.dat  initsink.ora  lkSINK  orapwsink  snapcf_sink.f

  5. hc_sink.dat  init.ora     inittest.ora  lkTEST  orapwtest  spfilesink.ora

  6. [oracle@sink dbs]$ vim initsink.ora

  7. [oracle@sink dbs]$ cat initsink.ora

  8. spfile='+DATA/spfilesink.ora'

  9. [oracle@sink dbs]$

再次進(jìn)入SQL環(huán)境，啟動(dòng)到nomount，設(shè)置spfile路徑指向，并查看相關(guān)參數(shù)是否操作生效！成功了！

  1. [oracle@sink dbs]$ !sql

  2. sqlplus / as sysdba


  4. SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 6 16:30:19 2018


  6. Copyright (c) 1982, 2013, Oracle. All rights reserved.



  9. Connected to:

  10. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

  11. With the Partitioning, Automatic Storage Management, OLAP, Data Mining

  12. and Real Application Testing options


  14. 16:30:19 SYS @ sink >startup force nomount;

  15. ORACLE instance started.


  17. Total System Global Area  835104768 bytes

  18. Fixed Size            2257840 bytes

  19. Variable Size          553651280 bytes

  20. Database Buffers      276824064 bytes

  21. Redo Buffers            2371584 bytes

  22. 16:30:38 SYS @ sink >alter system set db_create_file_dest='+DATA';


  24. System altered.


  26. Elapsed: 00:00:00.01

  27. 16:31:23 SYS @ sink >show parameter create;


  29. NAME                 TYPE     VALUE

  30. ------------------------------------ ----------- ------------------------------

  31. create_bitmap_area_size      integer     8388608

  32. create_stored_outlines             string

  33. db_create_file_dest             string     +DATA

  34. db_create_online_log_dest_1         string

  35. db_create_online_log_dest_2         string

  36. db_create_online_log_dest_3         string

  37. db_create_online_log_dest_4         string

  38. db_create_online_log_dest_5         string

  39. 16:31:33 SYS @ sink >

自上一步之后，查看數(shù)據(jù)庫啟動(dòng)狀態(tài)，然后satrtup force，將他啟動(dòng)到opened狀態(tài)

  1. 16:31:33 SYS @ sink >select status from v$instance;


  3. STATUS

  4. ------------

  5. STARTED


  7. 1 row selected.


  9. Elapsed: 00:00:00.00

  10. 16:35:24 SYS @ sink >alter database open;

  11. alter database open

  12. *

  13. ERROR at line 1:

  14. ORA-01507: database not mounted



  17. Elapsed: 00:00:00.00

  18. 16:35:39 SYS @ sink >startup force;

  19. ORACLE instance started.


  21. Total System Global Area  835104768 bytes

  22. Fixed Size            2257840 bytes

  23. Variable Size          553651280 bytes

  24. Database Buffers      276824064 bytes

  25. Redo Buffers            2371584 bytes

  26. Database mounted.

  27. Database opened.

  28. 16:36:24 SYS @ sink >

oracle啟動(dòng)到某一狀態(tài)的時(shí)候 之后啟動(dòng)的情況
satrtup nomount
alter database mount alter database open
startup mount alter database open --------------------------
startup (open) ---------------------------- --------------------------
oracle啟動(dòng)到某一狀態(tài)之后，只能一步一步的啟動(dòng)，直至open狀態(tài)，不能越級(jí)實(shí)行后續(xù)啟動(dòng)

這里查詢一下數(shù)據(jù)文件的file#和name，方便之后的數(shù)據(jù)文件遷移

  1. SYS @ sink >r

  2.   1* select file#,name from v$datafile


  4.      FILE# NAME

  5. ---------- -------------------------------------------------------

  6.      1 /u01/app/oracle/oradata/sink/system01.dbf

  7.      2 /u01/app/oracle/oradata/sink/sysaux01.dbf

  8.      3 /u01/app/oracle/oradata/sink/undotbs01.dbf

  9.      4 /u01/app/oracle/oradata/sink/users01.dbf

  10.      5 /u01/app/oracle/oradata/sink/example01.dbf

  11.      6 +DATA/sink/datafile/tbssss.256.963504823


  13. 6 rows selected.


  15. Elapsed: 00:00:00.01

轉(zhuǎn)儲(chǔ)控制文件失敗，看錯(cuò)誤信息提示：意思是在數(shù)據(jù)庫是mount或者open執(zhí)行這條語句沒有使用TO語句，

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


  3. Starting restore at 06-JAN-18

  4. using target database control file instead of recovery catalog

  5. allocated channel: ORA_DISK_1

  6. channel ORA_DISK_1: SID=42 device type=DISK


  8. RMAN-00571: ===========================================================

  9. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

  10. RMAN-00571: ===========================================================

  11. RMAN-03002: failure of restore command at 01/06/2018 16:45:57

  12. RMAN-06496: must use the TO clause when the database is mounted or open

這次加了to語句還是不行，后來糾結(jié)了一陣子，發(fā)現(xiàn)轉(zhuǎn)儲(chǔ)控制文件發(fā)現(xiàn)必須要oralce處于nomount狀態(tài)

  1. RMAN> restore controlfile from '/u01/app/oracle/oradata/sink/control01.ctl' to '+data/';


  3. RMAN-00571: ===========================================================

  4. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

  5. RMAN-00571: ===========================================================

  6. RMAN-00558: error encountered while parsing input commands

  7. RMAN-01009: syntax error: found "to": expecting one of: "archivelog, channel, check, controlfile, database, datafile, device, force, from, high, preview, primary, skip readonly, spfile, standby, tablespace, to restore point, until restore point, until, validate, (, ;"

  8. RMAN-01007: at line 1 column 71 file: standard input

 找到頭緒之后，將數(shù)據(jù)庫啟動(dòng)到nomount狀態(tài)

  1. [oracle@sink dbs]$ !sql

  2. sqlplus / as sysdba


  4. SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 6 16:48:57 2018


  6. Copyright (c) 1982, 2013, Oracle. All rights reserved.



  9. Connected to:

  10. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

  11. With the Partitioning, Automatic Storage Management, OLAP, Data Mining

  12. and Real Application Testing options


  14. 16:48:57 SYS @ sink >select status from v$instance;


  16. STATUS

  17. ------------

  18. OPEN


  20. 1 row selected.


  22. Elapsed: 00:00:00.01

  23. 16:49:10 SYS @ sink >startup nomount;

  24. ORA-01081: cannot start already-running ORACLE - shut it down first

  25. 16:49:17 SYS @ sink >startup force nomount;

  26. ORACLE instance started.


  28. Total System Global Area  835104768 bytes

  29. Fixed Size            2257840 bytes

  30. Variable Size          553651280 bytes

  31. Database Buffers      276824064 bytes

  32. Redo Buffers            2371584 bytes

  33. 16:49:33 SYS @ sink >select status from v$instance;


  35. STATUS

  36. ------------

  37. STARTED


  39. 1 row selected.


  41. Elapsed: 00:00:00.01

  42. 16:49:57 SYS @ sink >

好了，經(jīng)過一翻糾結(jié)，終于成功了，控制文件轉(zhuǎn)儲(chǔ)成功！

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


  3. Starting restore at 06-JAN-18

  4. using target database control file instead of recovery catalog

  5. allocated channel: ORA_DISK_1

  6. channel ORA_DISK_1: SID=23 device type=DISK


  8. channel ORA_DISK_1: copied control file copy

  9. output file name=+DATA/sink/controlfile/current.266.964717197

  10. output file name=+DATA/sink/controlfile/current.267.964717197

  11. Finished restore at 06-JAN-18


  13. RMAN>

查看控制文件遷移后的效果

  1. ASMCMD> pwd

  2. +data/sink/controlfile

  3. ASMCMD> ls

  4. Backup.262.964712653

  5. current.266.964717197

  6. current.267.964717197

在RMAN環(huán)境中將數(shù)據(jù)庫切到mount狀態(tài)，switch...修改控制文件用datafile copy做當(dāng)前DB的datafile使用

  1. RMAN> alter database mount;


  3. database mounted

  4. released channel: ORA_DISK_1


  6. RMAN> switch database to copy;


  8. using target database control file instead of recovery catalog

  9. datafile 1 switched to datafile copy "+DATA/sink/datafile/system.258.964712643"

  10. datafile 2 switched to datafile copy "+DATA/sink/datafile/sysaux.257.964712643"

  11. datafile 3 switched to datafile copy "+DATA/sink/datafile/undotbs1.261.964712645"

  12. datafile 4 switched to datafile copy "+DATA/sink/datafile/users.263.964712657"

  13. datafile 5 switched to datafile copy "+DATA/sink/datafile/example.260.964712643"

  14. datafile 6 switched to datafile copy "+DATA/sink/datafile/tbssss.259.964712643"

直接exit退出rman環(huán)境，然后直接!sql進(jìn)入SQL環(huán)境，注意數(shù)據(jù)庫狀態(tài)仍然為mount，查看dataifle的路徑

  1. RMAN> exit



  4. Recovery Manager complete.

  5. [oracle@sink dbs]$ !sql

  6. sqlplus / as sysdba


  8. SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 6 17:42:31 2018


  10. Copyright (c) 1982, 2013, Oracle. All rights reserved.



  13. Connected to:

  14. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

  15. With the Partitioning, Automatic Storage Management, OLAP, Data Mining

  16. and Real Application Testing options


  18. 17:42:41 SYS @ sink >col name for a55

  19. 17:42:57 SYS @ sink >r

  20.   1* select name from v$datafile


  22. NAME

  23. -------------------------------------------------------

  24. +DATA/sink/datafile/system.258.964712643

  25. +DATA/sink/datafile/sysaux.257.964712643

  26. +DATA/sink/datafile/undotbs1.261.964712645

  27. +DATA/sink/datafile/users.263.964712657

  28. +DATA/sink/datafile/example.260.964712643

  29. +DATA/sink/datafile/tbssss.259.964712643


  31. 6 rows selected.


  33. Elapsed: 00:00:00.01

  34. 17:42:58 SYS @ sink >

recover databse（應(yīng)用 ）開多個(gè)channel加快recover速度，生產(chǎn)DB很大，恢復(fù)時(shí)間很長(zhǎng)，這是不錯(cuò)的辦法

  1. RMAN> run{

  2. 2> allocate channel dev1 device type disk;

  3. 3> allocate channel dev2 device type disk;

  4. 4> allocate channel dev3 device type disk;

  5. 5> allocate channel dev4 device type disk;

  6. 6> recover database;

  7. 7> }


  9. released channel: ORA_DISK_1

  10. allocated channel: dev1

  11. channel dev1: SID=25 device type=DISK


  13. allocated channel: dev2

  14. channel dev2: SID=26 device type=DISK


  16. allocated channel: dev3

  17. channel dev3: SID=27 device type=DISK


  19. allocated channel: dev4

  20. channel dev4: SID=28 device type=DISK


  22. Starting recover at 06-JAN-18


  24. starting media recovery

  25. media recovery complete, elapsed time: 00:00:00


  27. Finished recover at 06-JAN-18

  28. released channel: dev1

  29. released channel: dev2

  30. released channel: dev3

  31. released channel: dev4


  33. RMAN>

exit，進(jìn)入sql環(huán)境，打開到open，看臨時(shí)文件name，臨時(shí)表空間name，

  1. RMAN> exit

  2. Recovery Manager complete.

  3. [oracle@sink dbs]$ !sql

  4. sqlplus / as sysdba


  6. SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 6 17:57:16 2018


  8. Copyright (c) 1982, 2013, Oracle. All rights reserved.



  11. Connected to:

  12. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

  13. With the Partitioning, Automatic Storage Management, OLAP, Data Mining

  14. and Real Application Testing options


  16. 17:59:16 SYS @ sink >alter database open;


  18. Database altered.


  20. Elapsed: 00:00:02.44

  21. 17:59:50 SYS @ sink >select name from v$tempfile;


  23. NAME

  24. -------------------------------------------------------

  25. /u01/app/oracle/oradata/sink/temp01.dbf


  27. 1 row selected.


  29. Elapsed: 00:00:00.02

  30. 18:00:05 SYS @ sink >select tablespace_name,contents from dba_tablespaces;


  32. TABLESPACE_NAME            CONTENTS

  33. ------------------------------ ---------

  34. SYSTEM                   PERMANENT

  35. SYSAUX                   PERMANENT

  36. UNDOTBS1               UNDO

  37. TEMP                   TEMPORARY

  38. USERS                   PERMANENT

  39. EXAMPLE                PERMANENT

  40. TBSSSS                   PERMANENT


  42. 7 rows selected.


  44. Elapsed: 00:00:00.01

把臨時(shí)表空間temp里面的臨時(shí)文件temp01.dbf加入到ASM中的+date目錄下

  1. 18:00:24 SYS @ sink >alter tablespace temp add tempfile '+data';


  3. Tablespace altered.


  5. Elapsed: 00:00:00.11

  6. 18:01:27 SYS @ sink >select name from v$tempfile;


  8. NAME

  9. -------------------------------------------------------

  10. /u01/app/oracle/oradata/sink/temp01.dbf

  11. +DATA/sink/tempfile/temp.268.964720887


  13. 2 rows selected.


  15. Elapsed: 00:00:00.01

因?yàn)橹挥幸粋€(gè)臨時(shí)表空間的一個(gè)臨時(shí)文件所以無法刪除，多個(gè)就能成功，一直到最后一個(gè)就不能這樣刪除了

  1. 18:12:22 SYS @ sink >alter tablespace temp drop tempfile '/u01/app/oracle/oradata/sink/temp01.dbf';


  3. Tablespace altered.


  5. Elapsed: 00:00:00.12

  6. 18:13:35 SYS @ sink >select name from v$tempfile;


  8. NAME

  9. -------------------------------------------------------

  10. /u01/app/oracle/oradata/sink/temp01.dbf

  11. +DATA/sink/tempfile/temp.268.964720887


  13. 2 rows selected.


  15. Elapsed: 00:00:00.01

上一步中DB處于open，以上操作將臨時(shí)文件刪至1個(gè)的時(shí)候，就不能繼續(xù)刪除，得將DB置于mount狀態(tài)才行

  1. 18:14:03 SYS @ sink >shutdown immediate;

  2. Database closed.

  3. Database dismounted.

  4. ORACLE instance shut down.

  5. 18:19:51 SYS @ sink >startup mount;

  6. ORACLE instance started.


  8. Total System Global Area  835104768 bytes

  9. Fixed Size            2257840 bytes

  10. Variable Size          553651280 bytes

  11. Database Buffers      276824064 bytes

  12. Redo Buffers            2371584 bytes

  13. Database mounted.

  14. 18:20:08 SYS @ sink >alter database drop tempfile '/u01/app/oracle/oradata/sink/temp01.dbf';

  15. alter database drop tempfile '/u01/app/oracle/oradata/sink/temp01.dbf'

  16.                     *

  17. ERROR at line 1:

  18. ORA-01900: LOGFILE keyword expected


  20. Elapsed: 00:00:00.00

  21. 18:21:45 SYS @ sink >edit

  22. Wrote file afiedt.buf


  24.   1* alter database tempfile '/u01/app/oracle/oradata/sink/temp01.dbf' drop

  25. 18:22:16 SYS @ sink >r

  26.   1* alter database tempfile '/u01/app/oracle/oradata/sink/temp01.dbf' drop


  28. Database altered.


  30. Elapsed: 00:00:00.03

  31. 18:22:17 SYS @ sink >alter database open;


  33. Database altered.


  35. Elapsed: 00:00:02.34

  36. 18:23:19 SYS @ sink >col tablespace_name for a10

  37. 18:23:38 SYS @ sink >col file_name for a55

  38. 18:23:54 SYS @ sink >r

  39.   1* select tablespace_name,file_name from dba_temp_files


  41. TABLESPACE FILE_NAME

  42. ---------- -------------------------------------------------------

  43. TEMP     +DATA/sink/tempfile/temp.268.964720887


  45. 1 row selected.


  47. Elapsed: 00:00:00.00

遷移日志文件到ASM，具體細(xì)節(jié)就不多做解釋了，整了這么久，累，去吃飯去了

  1. 18:23:55 SYS @ sink >select group#,status,sequence#,bytes from v$log;


  3.     GROUP# STATUS     SEQUENCE#        BYTES

  4. ---------- ---------------- ---------- ----------

  5.      1 INACTIVE            16     52428800

  6.      2 CURRENT            17     52428800

  7.      3 INACTIVE            15     52428800


  9. 3 rows selected.


  11. Elapsed: 00:00:00.01

  12. 18:29:19 SYS @ sink >col member for a55

  13. 18:29:37 SYS @ sink >select group#,member from v$logfile;


  15.     GROUP# MEMBER

  16. ---------- -------------------------------------------------------

  17.      3 /u01/app/oracle/oradata/sink/redo03.log

  18.      2 /u01/app/oracle/oradata/sink/redo02.log

  19.      1 /u01/app/oracle/oradata/sink/redo01.log


  21. 3 rows selected.


  23. Elapsed: 00:00:00.01

  24. 18:29:57 SYS @ sink >alter database add logfile '+data' size 50m;


  26. Database altered.


  28. Elapsed: 00:00:01.41

  29. 18:30:32 SYS @ sink >alter database add logfile '+data' size 50m;


  31. Database altered.


  33. Elapsed: 00:00:00.62

  34. 18:30:54 SYS @ sink >select group#,member from v$logfile;


  36.     GROUP# MEMBER

  37. ---------- -------------------------------------------------------

  38.      3 /u01/app/oracle/oradata/sink/redo03.log

  39.      2 /u01/app/oracle/oradata/sink/redo02.log

  40.      1 /u01/app/oracle/oradata/sink/redo01.log

  41.      4 +DATA/sink/onlinelog/group_4.269.964722631

  42.      5 +DATA/sink/onlinelog/group_5.270.964722653


  44. 5 rows selected.


  46. Elapsed: 00:00:00.00

  47. 18:31:13 SYS @ sink >select group#,status,sequence#,bytes from v$log;


  49.     GROUP# STATUS     SEQUENCE#        BYTES

  50. ---------- ---------------- ---------- ----------

  51.      1 INACTIVE            16     52428800

  52.      2 CURRENT            17     52428800

  53.      3 INACTIVE            15     52428800

  54.      4 UNUSED             0     52428800

  55.      5 UNUSED             0     52428800


  57. 5 rows selected.


  59. Elapsed: 00:00:00.02

  60. 18:33:37 SYS @ sink >alter database drop logfile group 1;


  62. Database altered.


  64. Elapsed: 00:00:00.01

  65. 18:35:03 SYS @ sink >alter database drop logfile group 3;


  67. Database altered.


  69. Elapsed: 00:00:00.01

  70. 18:35:20 SYS @ sink >select group#,status,sequence#,bytes from v$log;


  72.     GROUP# STATUS     SEQUENCE#        BYTES

  73. ---------- ---------------- ---------- ----------

  74.      2 CURRENT            17     52428800

  75.      4 UNUSED             0     52428800

  76.      5 UNUSED             0     52428800


  78. 3 rows selected.


  80. Elapsed: 00:00:00.00

  81. 18:35:56 SYS @ sink >alter system switch logfile;


  83. System altered.


  85. Elapsed: 00:00:00.01

  86. 18:36:31 SYS @ sink >r

  87.   1* alter system switch logfile


  89. System altered.


  91. Elapsed: 00:00:00.01

  92. 18:36:37 SYS @ sink >select group#,status,sequence#,bytes from v$log;


  94.     GROUP# STATUS     SEQUENCE#        BYTES

  95. ---------- ---------------- ---------- ----------

  96.      2 ACTIVE            17     52428800

  97.      4 ACTIVE            18     52428800

  98.      5 CURRENT            19     52428800


  100. 3 rows selected.


  102. Elapsed: 00:00:00.01

  103. 18:37:00 SYS @ sink >alter system checkpoint;


  105. System altered.


  107. Elapsed: 00:00:00.01

  108. 18:37:35 SYS @ sink >select group#,status,sequence#,bytes from v$log;


  110.     GROUP# STATUS     SEQUENCE#        BYTES

  111. ---------- ---------------- ---------- ----------

  112.      2 INACTIVE            17     52428800

  113.      4 INACTIVE            18     52428800

  114.      5 CURRENT            19     52428800


  116. 3 rows selected.


  118. Elapsed: 00:00:00.01

  119. 18:38:02 SYS @ sink >alter database drop logfile group 2;


  121. Database altered.


  123. Elapsed: 00:00:00.02

  124. 18:38:54 SYS @ sink >select group#,status,sequence#,bytes from v$log;


  126.     GROUP# STATUS     SEQUENCE#        BYTES

  127. ---------- ---------------- ---------- ----------

  128.      4 INACTIVE            18     52428800

  129.      5 CURRENT            19     52428800


  131. 2 rows selected.


  133. Elapsed: 00:00:00.00

  134. 18:39:30 SYS @ sink >select group#,member from v$logfile;


  136.     GROUP# MEMBER

  137. ---------- -------------------------------------------------------

  138.      4 +DATA/sink/onlinelog/group_4.269.964722631

  139.      5 +DATA/sink/onlinelog/group_5.270.964722653


  141. 2 rows selected.


  143. Elapsed: 00:00:00.00

  144. 18:40:00 SYS @ sink >alter database add logfile '+data' size 50m;


  146. Database altered.


  148. Elapsed: 00:00:00.32

  149. 18:40:36 SYS @ sink >select group#,member from v$logfile;


  151.     GROUP# MEMBER

  152. ---------- -------------------------------------------------------

  153.      1 +DATA/sink/onlinelog/group_1.271.964723237

  154.      4 +DATA/sink/onlinelog/group_4.269.964722631

  155.      5 +DATA/sink/onlinelog/group_5.270.964722653


  157. 3 rows selected.


  159. Elapsed: 00:00:00.00

好了，所有成果的效果，數(shù)據(jù)遷移完成（參數(shù)文件，控制文件，數(shù)據(jù)文件，日志文件）

  1. 18:41:47 SYS @ sink >select name from v$datafile

  2. 18:41:59   2 union all

  3. 18:42:03   3 select name from v$controlfile

  4. 18:42:18   4 union all

  5. 18:42:21   5 select member name from v$logfile;


  7. NAME

  8. -------------------------------------------------------

  9. +DATA/sink/datafile/system.258.964712643

  10. +DATA/sink/datafile/sysaux.257.964712643

  11. +DATA/sink/datafile/undotbs1.261.964712645

  12. +DATA/sink/datafile/users.263.964712657

  13. +DATA/sink/datafile/example.260.964712643

  14. +DATA/sink/datafile/tbssss.259.964712643

  15. +DATA/sink/controlfile/current.266.964717197

  16. +DATA/sink/controlfile/current.267.964717197

  17. +DATA/sink/onlinelog/group_1.271.964723237

  18. +DATA/sink/onlinelog/group_4.269.964722631

  19. +DATA/sink/onlinelog/group_5.270.964722653


  21. 11 rows selected.


  23. Elapsed: 00:00:00.01

  24. 18:42:35 SYS @ sink >

這里就是遷移到ASM的效果了

  1. ASMCMD> pwd

  2. +data/sink/datafile

  3. ASMCMD> ls

  4. EXAMPLE.260.964712643

  5. SYSAUX.257.964712643

  6. SYSTEM.258.964712643

  7. TBSSSS.256.963504823

  8. TBSSSS.259.964712643

  9. UNDOTBS1.261.964712645

  10. USERS.263.964712657

  11. ASMCMD> cd ../controlfile

  12. ASMCMD> pwd

  13. +data/sink/controlfile

  14. ASMCMD> ls

  15. Backup.262.964712653

  16. current.266.964717197

  17. current.267.964717197

  18. ASMCMD> cd ../onlinelog

  19. ASMCMD> pwd

  20. +data/sink/onlinelog

  21. ASMCMD> ls

  22. group_1.271.964723237

  23. group_4.269.964722631

  24. group_5.270.964722653

  25. ASMCMD>

看完上述內(nèi)容是否對(duì)您有幫助呢？如果還想對(duì)相關(guān)知識(shí)有進(jìn)一步的了解或閱讀更多相關(guān)文章，請(qǐng)關(guān)注億速云行業(yè)資訊頻道，感謝您對(duì)億速云的支持。

向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

asm
AI
助
手