iis服务器助手广告广告

扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >文件系统怎样迁移到ASM
  • 842

0
分享到

文件系统怎样迁移到ASM

2024-04-02 19:04:59 842人浏览 安东尼
摘要

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

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

数据库全备 仅仅是一个databse的全备，没有任何额外的附加功能，仅
0 级 增量备份 既是数据库的全备，又是，0级增量备份，在此基础上，可以后续执行增量备份
结论 因此推荐使用0级增量备份做数据库的全备

最好是以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;


  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>

转储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

查看转储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


  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 >

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

  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启动到某一状态的时候 之后启动的情况
satrtup nomount
alter database mount alter database open
startup mount alter database open --------------------------
startup (open) ---------------------------- --------------------------
oracle启动到某一状态之后，只能一步一步的启动，直至open状态，不能越级实行后续启动

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

  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

转储控制文件失败，看错误信息提示：意思是在数据库是mount或者open执行这条语句没有使用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语句还是不行，后来纠结了一阵子，发现转储控制文件发现必须要oralce处于nomount状态

  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

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

  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 >

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

  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环境中将数据库切到mount状态，switch...修改控制文件用datafile copy做当前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环境，然后直接!sql进入SQL环境，注意数据库状态仍然为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（应用 ）开多个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> }


  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，进入sql环境，打开到open，看临时文件name，临时表空间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

把临时表空间temp里面的临时文件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

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

  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，以上操作将临时文件删至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.


  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，具体细节就不多做解释了，整了这么久，累，去吃饭去了

  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

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

  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>

看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注编程网数据库频道，感谢您对编程网的支持。

您可能感兴趣的文档:
点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: 文件系统怎样迁移到ASM

本文链接: https://www.lsjlt.com/news/68625.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档
去做题
猜你喜欢
  • 文件系统怎样迁移到ASM
    文件系统怎样迁移到ASM，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。数据库全备 仅仅是一个databse的全备，没...
    99+
    2024-04-02
  • 怎么将spfile从ASM里迁移到文件系统
    本篇内容介绍了“怎么将spfile从ASM里迁移到文件系统”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！[...
    99+
    2024-04-02
  • 怎么从数据库把文件系统迁移到ASM
    本篇文章给大家分享的是有关怎么从数据库把文件系统迁移到ASM，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。 今天需要把文件系统上的数据文件迁...
    99+
    2024-04-02
  • SQLITE怎样迁移到MYSQL
    SQLITE怎样迁移到MYSQL，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。接同事需求，要求从SQLITE的数据转到MYSQL，这东西以前也...
    99+
    2024-04-02
  • 如何从ASM复制文件到文件系统
    本篇文章给大家分享的是有关如何从ASM复制文件到文件系统，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。版本10.2.0.51、使用RMAN：$...
    99+
    2024-04-02
  • 12c拷贝 RAC ASM中的密码文件到文件系统
    1、在一次使用RMAN复制standby数据库的时候，需要将RAC的密码文件拷贝到standby数据库，由于ORACLE12C RAC的密码文件 在ASM上，因此首先需要将其拷贝到文件系统。 2、确认密码文...
    99+
    2024-04-02
  • ubuntu系统怎么迁移到另一台电脑
    要将Ubuntu系统迁移到另一台电脑，您可以按照以下步骤操作： 备份数据：在迁移系统之前，首先要确保备份所有重要数据和文件，以防...
    99+
    2024-04-03
    ubuntu
  • 怎么将Django项目迁移到linux系统中
    这篇文章主要介绍“怎么将Django项目迁移到linux系统中”，在日常操作中，相信很多人在怎么将Django项目迁移到linux系统中问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么将Django项目迁移...
    99+
    2023-07-05
  • 怎样迁移Spring Boot到函数计算
    今天就跟大家聊聊有关怎样迁移Spring Boot到函数计算，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。首先介绍下出现的几个比较重要的概念：函数计算（Function Comput...
    99+
    2023-06-03
  • 怎样从Oracle到GaussDB的数据迁移
    今天就跟大家聊聊有关怎样从Oracle到GaussDB的数据迁移，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。 一、背景最近某省运营商O域...
    99+
    2024-04-02
  • SQL Server无感系统迁移到MySQL怎么实现
    本篇内容主要讲解“SQL Server无感系统迁移到MySQL怎么实现”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“SQL Server无感系统迁移到MySQL怎么实现”吧!...
    99+
    2023-06-30
  • 怎么将phpstudy中的mysql迁移到Linux系统中
    本篇文章为大家展示了怎么将phpstudy中的mysql迁移到Linux系统中，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。环境情况新主机系统平台：CentOS r...
    99+
    2024-04-02
  • 服务器怎样迁移到阿里云端
    随着互联网的快速发展，越来越多的企业开始依赖于云计算服务。对于一些大型企业来说，从本地服务器迁移到阿里云云服务器是一项重要的任务。本文将详细说明如何迁移服务器到阿里云云服务器。 阿里云是阿里巴巴集团的云计算业务，提供了一系列云服务，包括云服...
    99+
    2023-11-08
    阿里 云端 服务器
  • windows7系统中我的文档怎样默认移动到D盘？
    首先o;）。在右侧有一个文档，打开它。 在“我的文档”上右击——属性，  在弹出的窗口中，选择“位置&r ...
    99+
    2023-05-30
    win7 我的文档 移动到D盘 文档 D盘 系统 windows7
  • 如何使用shell脚本及asm cp或RMAN copy批量将数据文件从ASM拷贝到文件系统
    这篇文章主要为大家展示了“如何使用shell脚本及asm cp或RMAN copy批量将数据文件从ASM拷贝到文件系统”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一...
    99+
    2024-04-02
  • 苹果mac系统怎么复制文件到移动硬盘?
    苹果因为系统稳定，常被用作办公设备。习惯了windows系统，初次使用苹果发现在苹果电脑中查找、复制文件并没有在windows中方便。那么，苹果系统复制文件在哪里？在苹果电脑我们要复制文件，需要通过【访达】找到文件所在位置。苹果系统怎么复制...
    99+
    2023-09-04
    macos windows microsoft
  • 怎么迁移SQL 2005系统数据库
    这篇文章主要讲解了“怎么迁移SQL 2005系统数据库”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“怎么迁移SQL 2005系统数据库”吧！ 移动mast...
    99+
    2024-04-02
  • 将Django项目迁移到linux系统的详细步骤
    目录Django项目配置修改项目环境以及数据库打包linux系统中的配置1、python3的安装2、第二步就是数据库的配置项目整合与配置总结Django项目配置修改 我们需要把原先的Django项目进行修改才能更好地进行...
    99+
    2023-03-15
    Django项目迁移到linux Django项目迁移 Django项目迁移linux系统
  • 怎么给文件服务器做迁移
    给文件服务器做迁移的方法：1、用XCOPY命令加上合适的参数进行文件服务器迁移，可靠性较高；2、用同步软件将所有文件同步到新文件夹上，但可靠性不高，出错的概率大；3、用VERITAS BE对老的相关文件夹做全备份，然后在新的服务器上装BE ...
    99+
    2024-04-02
  • sql数据库mdf文件怎么迁移
    今天小编给大家分享一下sql数据库mdf文件怎么迁移的相关知识点，内容详细，逻辑清晰，相信大部分人都还太了解这方面的知识，所以分享这篇文章给大家参考一下，希望大家阅读完这篇文章后有所收获，下面我们一起来了解一下吧。sql数据库mdf文件迁移...
    99+
    2023-07-01
软考高级职称资格查询
iis服务器助手广告
软考职称历年真题下载
软考职称资料下载
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作