文件系统怎样迁移到ASM

文件系统怎样迁移到ASM，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。

最好是以grid用户进入asm 环境

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

2. Password:
   

3. [grid@sink ~]$ asmcmd

做完 0 级 增量备份后的备份文件

1. ASMCMD> pwd
   

2. +data/sink
   

3. ASMCMD> ls
   

4. BACKUPSET/
   

5. CONTROLFILE/
   

6. DATAFILE/
   

7. PARAMETERFILE/

查看刚才做的 0级增量 备份

1. RMAN> list copy of database;
   

2. 
   

3. List of Datafile Copies
   

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

5. 
   

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
    

11. 
    

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

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

14.         Tag: ORA_ASM_MIGRATION
    

15. 
    

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

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

18.         Tag: ORA_ASM_MIGRATION
    

19. 
    

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

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

22.         Tag: ORA_ASM_MIGRATION
    

23. 
    

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

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

26.         Tag: ORA_ASM_MIGRATION
    

27. 
    

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

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

30.         Tag: ORA_ASM_MIGRATION
    

31. 
    

32. 
    

33. RMAN>

转储spfile到

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

2. 
   

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
   

7. 
   

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

查看转储spfile参数文件后的  在ASM中的 路径状态

1. ASMCMD> pwd
   

2. +data
   

3. ASMCMD> ls
   

4. ASM/
   

5. SINK/
   

6. spfilesink.ora
   

7. ASMCMD>

修改并查看pfile中的内容，使其内容指向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]$

再次进入SQL环境，启动到nomount，设置spfile路径指向，并查看相关参数是否操作生效！成功了！

1. [oracle@sink dbs]$ !sql
   

2. sqlplus / as sysdba
   

3. 
   

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

5. 
   

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

7. 
   

8. 
   

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
    

13. 
    

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

15. ORACLE instance started.
    

16. 
    

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';
    

23. 
    

24. System altered.
    

25. 
    

26. Elapsed: 00:00:00.01
    

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

28. 
    

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 >

自上一步之后，查看数据库启动状态，然后satrtup force，将他启动到opened状态

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

2. 
   

3. STATUS
   

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

5. STARTED
   

6. 
   

7. 1 row selected.
   

8. 
   

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
    

15. 
    

16. 
    

17. Elapsed: 00:00:00.00
    

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

19. ORACLE instance started.
    

20. 
    

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 >

这里查询一下数据文件的file#和name，方便之后的数据文件迁移

1. SYS @ sink >r
   

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

3. 
   

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
    

12. 
    

13. 6 rows selected.
    

14. 
    

15. Elapsed: 00:00:00.01

转储控制文件失败，看错误信息提示：意思是在数据库是mount或者open执行这条语句没有使用TO语句，

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

2. 
   

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
   

7. 
   

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语句还是不行，后来纠结了一阵子，发现转储控制文件发现必须要oralce处于nomount状态

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

2. 
   

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

 找到头绪之后，将数据库启动到nomount状态

1. [oracle@sink dbs]$ !sql
   

2. sqlplus / as sysdba
   

3. 
   

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

5. 
   

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

7. 
   

8. 
   

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
    

13. 
    

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

15. 
    

16. STATUS
    

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

18. OPEN
    

19. 
    

20. 1 row selected.
    

21. 
    

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.
    

27. 
    

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;
    

34. 
    

35. STATUS
    

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

37. STARTED
    

38. 
    

39. 1 row selected.
    

40. 
    

41. Elapsed: 00:00:00.01
    

42. 16:49:57 SYS @ sink >

好了，经过一翻纠结，终于成功了，控制文件转储成功！

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

2. 
   

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
   

7. 
   

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
    

12. 
    

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环境中将数据库切到mount状态，switch...修改控制文件用datafile copy做当前DB的datafile使用

1. RMAN> alter database mount;
   

2. 
   

3. database mounted
   

4. released channel: ORA_DISK_1
   

5. 
   

6. RMAN> switch database to copy;
   

7. 
   

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环境，然后直接!sql进入SQL环境，注意数据库状态仍然为mount，查看dataifle的路径

1. RMAN> exit
   

2. 
   

3. 
   

4. Recovery Manager complete.
   

5. [oracle@sink dbs]$ !sql
   

6. sqlplus / as sysdba
   

7. 
   

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

9. 
   

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

11. 
    

12. 
    

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
    

17. 
    

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

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

20.   1* select name from v$datafile
    

21. 
    

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
    

30. 
    

31. 6 rows selected.
    

32. 
    

33. Elapsed: 00:00:00.01
    

34. 17:42:58 SYS @ sink >

recover databse（应用 ）开多个channel加快recover速度，生产DB很大，恢复时间很长，这是不错的办法

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> }
   

8. 
   

9. released channel: ORA_DISK_1
   

10. allocated channel: dev1
    

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

12. 
    

13. allocated channel: dev2
    

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

15. 
    

16. allocated channel: dev3
    

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

18. 
    

19. allocated channel: dev4
    

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

21. 
    

22. Starting recover at 06-JAN-18
    

23. 
    

24. starting media recovery
    

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

26. 
    

27. Finished recover at 06-JAN-18
    

28. released channel: dev1
    

29. released channel: dev2
    

30. released channel: dev3
    

31. released channel: dev4
    

32. 
    

33. RMAN>

exit，进入sql环境，打开到open，看临时文件name，临时表空间name，

1. RMAN> exit

2. Recovery Manager complete.
   

3. [oracle@sink dbs]$ !sql
   

4. sqlplus / as sysdba
   

5. 
   

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

7. 
   

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

9. 
   

10. 
    

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
    

15. 
    

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

17. 
    

18. Database altered.
    

19. 
    

20. Elapsed: 00:00:02.44
    

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

22. 
    

23. NAME
    

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

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

26. 
    

27. 1 row selected.
    

28. 
    

29. Elapsed: 00:00:00.02
    

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

31. 
    

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
    

41. 
    

42. 7 rows selected.
    

43. 
    

44. Elapsed: 00:00:00.01

把临时表空间temp里面的临时文件temp01.dbf加入到ASM中的+date目录下

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

2. 
   

3. Tablespace altered.
   

4. 
   

5. Elapsed: 00:00:00.11
   

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

7. 
   

8. NAME
   

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

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

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

12. 
    

13. 2 rows selected.
    

14. 
    

15. Elapsed: 00:00:00.01

因为只有一个临时表空间的一个临时文件所以无法删除，多个就能成功，一直到最后一个就不能这样删除了

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

2. 
   

3. Tablespace altered.
   

4. 
   

5. Elapsed: 00:00:00.12
   

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

7. 
   

8. NAME
   

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

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

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

12. 
    

13. 2 rows selected.
    

14. 
    

15. Elapsed: 00:00:00.01

上一步中DB处于open，以上操作将临时文件删至1个的时候，就不能继续删除，得将DB置于mount状态才行

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.
   

7. 
   

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
    

19. 
    

20. Elapsed: 00:00:00.00
    

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

22. Wrote file afiedt.buf
    

23. 
    

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
    

27. 
    

28. Database altered.
    

29. 
    

30. Elapsed: 00:00:00.03
    

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

32. 
    

33. Database altered.
    

34. 
    

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
    

40. 
    

41. TABLESPACE FILE_NAME
    

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

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

44. 
    

45. 1 row selected.
    

46. 
    

47. Elapsed: 00:00:00.00

迁移日志文件到ASM，具体细节就不多做解释了，整了这么久，累，去吃饭去了

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

2. 
   

3.     GROUP# STATUS     SEQUENCE#        BYTES
   

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

5.      1 INACTIVE            16     52428800
   

6.      2 CURRENT            17     52428800
   

7.      3 INACTIVE            15     52428800
   

8. 
   

9. 3 rows selected.
   

10. 
    

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;
    

14. 
    

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
    

20. 
    

21. 3 rows selected.
    

22. 
    

23. Elapsed: 00:00:00.01
    

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

25. 
    

26. Database altered.
    

27. 
    

28. Elapsed: 00:00:01.41
    

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

30. 
    

31. Database altered.
    

32. 
    

33. Elapsed: 00:00:00.62
    

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

35. 
    

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
    

43. 
    

44. 5 rows selected.
    

45. 
    

46. Elapsed: 00:00:00.00
    

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

48. 
    

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
    

56. 
    

57. 5 rows selected.
    

58. 
    

59. Elapsed: 00:00:00.02
    

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

61. 
    

62. Database altered.
    

63. 
    

64. Elapsed: 00:00:00.01
    

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

66. 
    

67. Database altered.
    

68. 
    

69. Elapsed: 00:00:00.01
    

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

71. 
    

72.     GROUP# STATUS     SEQUENCE#        BYTES
    

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

74.      2 CURRENT            17     52428800
    

75.      4 UNUSED             0     52428800
    

76.      5 UNUSED             0     52428800
    

77. 
    

78. 3 rows selected.
    

79. 
    

80. Elapsed: 00:00:00.00
    

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

82. 
    

83. System altered.
    

84. 
    

85. Elapsed: 00:00:00.01
    

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

87.   1* alter system switch logfile
    

88. 
    

89. System altered.
    

90. 
    

91. Elapsed: 00:00:00.01
    

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

93. 
    

94.     GROUP# STATUS     SEQUENCE#        BYTES
    

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

96.      2 ACTIVE            17     52428800
    

97.      4 ACTIVE            18     52428800
    

98.      5 CURRENT            19     52428800
    

99. 
    

100. 3 rows selected.
     

101. 
     

102. Elapsed: 00:00:00.01
     

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

104. 
     

105. System altered.
     

106. 
     

107. Elapsed: 00:00:00.01
     

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

109. 
     

110.     GROUP# STATUS     SEQUENCE#        BYTES
     

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

112.      2 INACTIVE            17     52428800
     

113.      4 INACTIVE            18     52428800
     

114.      5 CURRENT            19     52428800
     

115. 
     

116. 3 rows selected.
     

117. 
     

118. Elapsed: 00:00:00.01
     

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

120. 
     

121. Database altered.
     

122. 
     

123. Elapsed: 00:00:00.02
     

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

125. 
     

126.     GROUP# STATUS     SEQUENCE#        BYTES
     

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

128.      4 INACTIVE            18     52428800
     

129.      5 CURRENT            19     52428800
     

130. 
     

131. 2 rows selected.
     

132. 
     

133. Elapsed: 00:00:00.00
     

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

135. 
     

136.     GROUP# MEMBER
     

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

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

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

140. 
     

141. 2 rows selected.
     

142. 
     

143. Elapsed: 00:00:00.00
     

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

145. 
     

146. Database altered.
     

147. 
     

148. Elapsed: 00:00:00.32
     

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

150. 
     

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
     

156. 
     

157. 3 rows selected.
     

158. 
     

159. Elapsed: 00:00:00.00

好了，所有成果的效果，数据迁移完成（参数文件，控制文件，数据文件，日志文件）

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;
   

6. 
   

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
    

20. 
    

21. 11 rows selected.
    

22. 
    

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>

看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注亿速云行业资讯频道，感谢您对亿速云的支持。