社区
学习
工具库
AI工具
休闲
搜索
简体中文
首页 数据库 mysql教程 数据文件从系统文件迁移到asm的操作专栏

数据文件从系统文件迁移到asm的操作专栏

PHPz
PHPz
Jun 07, 2016 pm 03:56 PM
oracle

select file_name ,tablespace_name from dba_data_files ;

FILE_NAME                      TABLESPACE_NAME
--------------------------------------------- ------------------------------
+DATA/rac/datafile/system.259.926647219       SYSTEM
+DATA/rac/datafile/sysaux.260.926647323       SYSAUX
+DATA/rac/datafile/undotbs1.261.926647405     UNDOTBS1
+DATA/rac/datafile/undotbs2.263.926647467     UNDOTBS2
+DATA/rac/datafile/users.264.926647499          USERS
+DATA/rac/datafile/admin_tbs.274.927927081    ADMIN_TBS
+DATA/rac/datafile/admin_tb2.275.927927171    ADMIN_TB2
+DATA/rac/datafile/tbs_low_freq.276.927939255 TBS_LOW_FREQ
/oracle/app/oracle/11.2/db_1/dbs/q1_orders    Q1_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/q2_orders    Q2_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/q3_orders    Q3_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/q4_orders    Q4_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/2006_orders  2006_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/2005_orders  2005_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/2004_orders  2004_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/old_orders   OLD_ORDERS
/oracle/app/oracle/11.2/db_1/dbs/cc_this_mont CC_THIS_MONTH

数据文件都节点1本地。

案例重演：
sys@RAC> show parameter db_create_file_dest

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest             string     +DATA

采用了omf管理
sys@RAC> create tablespace qn datafile size 20m ;

Tablespace created.

sys@RAC> select file_name ,tablespace_name from dba_data_files ;

FILE_NAME                      TABLESPACE_NAME
--------------------------------------------- ------------------------------
.........
+DATA/rac/datafile/qn.277.928807173          QN
此时发现数据文件qn建在ASM存储上

sys@RAC> create tablespace qn2 datafile 'qn2' size 20m ;
Tablespace created.
sys@RAC> select file_name ,tablespace_name from dba_data_files ;

FILE_NAME                      TABLESPACE_NAME
--------------------------------------------- ------------------------------
/oracle/app/oracle/11.2/db_1/dbs/cc_prev_12   CC_PREV_12MTH
/oracle/app/oracle/11.2/db_1/dbs/cc_old_tran  CC_OLD_TRAN
+DATA/rac/datafile/qn.277.928807173          QN
/oracle/app/oracle/11.2/db_1/dbs/qn2          QN2
此时发现数据文件qn2建在系统文件上,这样会出问题的，其节点报错。

那么如何把这个数据库的系统文件迁移到ASM上呢？

在线迁移数据文件至ASM上：

1. offline数据文件
   select file_name ,tablespace_name from dba_data_files  where tablespace_name in ('Q1_ORDERS','Q2_ORDERS','Q3_ORDERS','Q4_ORDERS','2006_ORDERS','2005_ORDERS','2004_ORDERS','OLD_ORDERS','CC_THIS_MONTH','CC_PREV_MONTH','CC_PREV_12MTH','QN2' ) ;
   FILE_NAME                             TABLESPACE_NAME
   ------------------------------------------------------------ ------------------------------
   /oracle/app/oracle/11.2/db_1/dbs/q1_orders             Q1_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/q2_orders             Q2_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/q3_orders             Q3_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/q4_orders             Q4_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/2006_orders             2006_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/2005_orders             2005_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/2004_orders             2004_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/old_orders             OLD_ORDERS
   /oracle/app/oracle/11.2/db_1/dbs/cc_this_month             CC_THIS_MONTH
   /oracle/app/oracle/11.2/db_1/dbs/cc_prev_month             CC_PREV_MONTH
   /oracle/app/oracle/11.2/db_1/dbs/cc_prev_12             CC_PREV_12MTH
   /oracle/app/oracle/11.2/db_1/dbs/qn2                 QN2

2. rman copy
   alter tablespace Q1_ORDERS offline ;

   backup as copy datafile '/oracle/app/oracle/11.2/db_1/dbs/q1_orders'  format '+DATA';
   or
   copy datafile  '/oracle/app/oracle/11.2/db_1/dbs/q1_orders' to '+DATA';


  RMAN>  copy datafile  '/oracle/app/oracle/11.2/db_1/dbs/q1_orders' to '+DATA';

  Starting backup at 2016-11-25 02:55:42
  using target database control file instead of recovery catalog
  allocated channel: ORA_DISK_1
  channel ORA_DISK_1: SID=28 instance=rac1 device type=DISK
  channel ORA_DISK_1: starting datafile copy
  input datafile file number=00009 name=/oracle/app/oracle/11.2/db_1/dbs/q1_orders
  output file name=+DATA/rac/datafile/q1_orders.278.928810547 tag=TAG20161125T025546 RECID=1 STAMP=928810550
  channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  Finished backup at 2016-11-25 02:55:50

3. rename
  alter database rename file 'D:\NSOADP\SYSTEM01.DBF' to '+ORADATA/nsoa/datafile/system.260.877082571';
  or
  switch datafile 37 to copy;

  RMAN> switch datafile '/oracle/app/oracle/11.2/db_1/dbs/q1_orders' to copy ;
  datafile 9 switched to datafile copy "+DATA/rac/datafile/q1_orders.278.928810547"


4. recover
    recover datafile '+DATA/rac/datafile/q1_orders.278.928810547';

5. online
  alter tablespace Q1_ORDERS online

  sys@RAC> select file_name ,tablespace_name from dba_data_files  where tablespace_name in ('Q1_ORDERS')
    2  /

  FILE_NAME                             TABLESPACE_NAME
  ------------------------------------------------------------ ------------------------------
  +DATA/rac/datafile/q1_orders.278.928810547             Q1_ORDERS

快速恢复:
  sys@RAC> select file_name ,tablespace_name from dba_data_files  where tablespace_name in ('Q2_ORDERS','Q3_ORDERS','Q4_ORDERS','2006_ORDERS','2005_ORDERS','2004_ORDERS','OLD_ORDERS','CC_THIS_MONTH','CC_PREV_MONTH','CC_PREV_12MTH','QN2' ) ;

  FILE_NAME                             TABLESPACE_NAME
  ------------------------------------------------------------ ------------------------------
  /oracle/app/oracle/11.2/db_1/dbs/q2_orders             Q2_ORDERS
  /oracle/app/oracle/11.2/db_1/dbs/q3_orders             Q3_ORDERS
  /oracle/app/oracle/11.2/db_1/dbs/q4_orders             Q4_ORDERS
  /oracle/app/oracle/11.2/db_1/dbs/2006_orders             2006_ORDERS
  /oracle/app/oracle/11.2/db_1/dbs/2005_orders             2005_ORDERS
  /oracle/app/oracle/11.2/db_1/dbs/2004_orders             2004_ORDERS
  /oracle/app/oracle/11.2/db_1/dbs/old_orders             OLD_ORDERS
  /oracle/app/oracle/11.2/db_1/dbs/cc_this_month             CC_THIS_MONTH
  /oracle/app/oracle/11.2/db_1/dbs/cc_prev_month             CC_PREV_MONTH
  /oracle/app/oracle/11.2/db_1/dbs/cc_prev_12             CC_PREV_12MTH
  /oracle/app/oracle/11.2/db_1/dbs/qn2                 QN2

sys@RAC>    select 'alter tablespace '|| tablespace_name||' offline;'  from dba_data_files  where tablespace_name in ('Q2_ORDERS','Q3_ORDERS','Q4_ORDERS','2006_ORDERS','2005_ORDERS','2004_ORDERS','OLD_ORDERS','CC_THIS_MONTH','CC_PREV_MONTH','CC_PREV_12MTH','QN2' ) ;

'ALTERTABLESPACE'||TABLESPACE_NAME||'OFFLINE;'
--------------------------------------------------------
alter tablespace Q2_ORDERS offline;
alter tablespace Q3_ORDERS offline;
alter tablespace Q4_ORDERS offline;
alter tablespace 2006_ORDERS offline;
alter tablespace 2005_ORDERS offline;
alter tablespace 2004_ORDERS offline;
alter tablespace OLD_ORDERS offline;
alter tablespace CC_THIS_MONTH offline;
alter tablespace CC_PREV_MONTH offline;
alter tablespace CC_PREV_12MTH offline;
alter tablespace QN2 offline;

sys@RAC> sys@RAC> alter tablespace Q2_ORDERS offline;
alter tablespace Q3_ORDERS offline;
alter tablespace Q4_ORDERS offline;
alter tablespace 2006_ORDERS offline;
alter tablespace 2005_ORDERS offline;
alter tablespace 2004_ORDERS offline;
alter tablespace OLD_ORDERS offline;
alter tablespace CC_THIS_MONTH offline;
alter tablespace CC_PREV_MONTH offline;
alter tablespace CC_PREV_12MTH offline;
alter tablespace QN2 offline;

sys@RAC> alter tablespace "2006_ORDERS" offline
                 *
ERROR at line 1:
ORA-02140: invalid tablespace name

sys@RAC> alter tablespace 2005_ORDERS offline
                 *
ERROR at line 1:
ORA-02140: invalid tablespace name

sys@RAC> alter tablespace 2004_ORDERS offline
                 *
ERROR at line 1:
ORA-02140: invalid tablespace name

alter tablespace "2004_ORDERS" offline;
alter tablespace "2005_ORDERS" offline;
alter tablespace "2006_ORDERS" offline;

 select 'copy datafile '''||file_name||''' to ''+DATA'';'  from dba_data_files  where tablespace_name in ('Q2_ORDERS','Q3_ORDERS','Q4_ORDERS','2006_ORDERS','2005_ORDERS','2004_ORDERS','OLD_ORDERS','CC_THIS_MONTH','CC_PREV_MONTH','CC_PREV_12MTH','QN2' ) ;

'COPYDATAFILE'''||FILE_NAME||'''TO''+DATA'';'
----------------------------------------------------------------------------------------------------------------------------------------------------------
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/q2_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/q3_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/q4_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/2006_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/2005_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/2004_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/old_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_this_month' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_month' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_12' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/qn2' to '+DATA';

RMAN> copy datafile '/oracle/app/oracle/11.2/db_1/dbs/q2_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/q3_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/q4_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1
/dbs/2006_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/2005_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/2004_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/old_orders' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_this_month' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_month' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_12' to '+DATA';
copy datafile '/oracle/app/oracle/11.2/db_1/dbs/qn2' to '+DATA';Starting backup at 2016-11-25 03:20:57
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=/oracle/app/oracle/11.2/db_1/dbs/q2_orders
output file name=+DATA/rac/datafile/q2_orders.279.928812061 tag=TAG20161125T032059 RECID=3 STAMP=928812062
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 2016-11-25 03:21:02

RMAN>
Starting backup at 2016-11-25 03:21:08
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/oracle/app/oracle/11.2/db_1/dbs/q3_orders
output file name=+DATA/rac/datafile/q3_orders.280.928812071 tag=TAG20161125T032109 RECID=4 STAMP=928812073
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2016-11-25 03:21:17

RMAN>
Starting backup at 2016-11-25 03:21:22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=/oracle/app/oracle/11.2/db_1/dbs/q4_orders
output file name=+DATA/rac/datafile/q4_orders.281.928812085 tag=TAG20161125T032124 RECID=5 STAMP=928812088
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 2016-11-25 03:21:28

RMAN>
Starting backup at 2016-11-25 03:21:33
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=/oracle/app/oracle/11.2/db_1/dbs/2006_orders
output file name=+DATA/rac/datafile/2006_orders.282.928812095 tag=TAG20161125T032134 RECID=6 STAMP=928812099
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2016-11-25 03:21:42

RMAN>
Starting backup at 2016-11-25 03:21:46
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00014 name=/oracle/app/oracle/11.2/db_1/dbs/2005_orders
output file name=+DATA/rac/datafile/2005_orders.283.928812109 tag=TAG20161125T032148 RECID=7 STAMP=928812112
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2016-11-25 03:21:56

RMAN>
Starting backup at 2016-11-25 03:22:00
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00015 name=/oracle/app/oracle/11.2/db_1/dbs/2004_orders
output file name=+DATA/rac/datafile/2004_orders.284.928812123 tag=TAG20161125T032202 RECID=8 STAMP=928812126
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2016-11-25 03:22:10

RMAN>
Starting backup at 2016-11-25 03:22:14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00016 name=/oracle/app/oracle/11.2/db_1/dbs/old_orders
output file name=+DATA/rac/datafile/old_orders.285.928812137 tag=TAG20161125T032216 RECID=9 STAMP=928812141
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2016-11-25 03:22:24

RMAN>
Starting backup at 2016-11-25 03:22:29
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00017 name=/oracle/app/oracle/11.2/db_1/dbs/cc_this_month
output file name=+DATA/rac/datafile/cc_this_month.286.928812151 tag=TAG20161125T032231 RECID=10 STAMP=928812154
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 2016-11-25 03:22:34

RMAN>
Starting backup at 2016-11-25 03:22:45
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00018 name=/oracle/app/oracle/11.2/db_1/dbs/cc_prev_month
output file name=+DATA/rac/datafile/cc_prev_month.287.928812167 tag=TAG20161125T032246 RECID=11 STAMP=928812167
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2016-11-25 03:22:47

RMAN>
Starting backup at 2016-11-25 03:22:52
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00019 name=/oracle/app/oracle/11.2/db_1/dbs/cc_prev_12
output file name=+DATA/rac/datafile/cc_prev_12mth.288.928812175 tag=TAG20161125T032253 RECID=12 STAMP=928812175
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 2016-11-25 03:22:57

Starting backup at 2016-11-25 03:26:09

RMAN>
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00022 name=/oracle/app/oracle/11.2/db_1/dbs/qn2
output file name=+DATA/rac/datafile/qn2.289.928812371 tag=TAG20161125T032611 RECID=13 STAMP=928812376
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2016-11-25 03:26:18


 sys@RAC> select 'switch  datafile '''||file_name||''' to copy;'  from dba_data_files  where tablespace_name in ('Q2_ORDERS','Q3_ORDERS','Q4_ORDERS','2006_ORDERS','2005_ORDERS','2004_ORDERS','OLD_ORDERS','CC_THIS_MONTH','CC_PREV_MONTH','CC_PREV_12MTH','QN2' ) ;

'SWITCHDATAFILE'''||FILE_NAME||'''TOCOPY;'
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/q2_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/q3_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/q4_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/2006_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/2005_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/2004_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/old_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_this_month' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_month' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_12' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/qn2' to copy;

RMAN> switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/q2_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/q3_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/q4_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/
dbs/2006_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/2005_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/2004_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/old_orders' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_this_month' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_month' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/cc_prev_12' to copy;
switch    datafile '/oracle/app/oracle/11.2/db_1/dbs/qn2' to copy;
datafile 10 switched to datafile copy "+DATA/rac/datafile/q2_orders.279.928812061"
RMAN>
datafile 11 switched to datafile copy "+DATA/rac/datafile/q3_orders.280.928812071"
RMAN>
datafile 12 switched to datafile copy "+DATA/rac/datafile/q4_orders.281.928812085"
RMAN>
datafile 13 switched to datafile copy "+DATA/rac/datafile/2006_orders.282.928812095"
RMAN>
datafile 14 switched to datafile copy "+DATA/rac/datafile/2005_orders.283.928812109"
RMAN>
datafile 15 switched to datafile copy "+DATA/rac/datafile/2004_orders.284.928812123"
RMAN>
datafile 16 switched to datafile copy "+DATA/rac/datafile/old_orders.285.928812137"
RMAN>
datafile 17 switched to datafile copy "+DATA/rac/datafile/cc_this_month.286.928812151"
RMAN>
datafile 18 switched to datafile copy "+DATA/rac/datafile/cc_prev_month.287.928812167"
RMAN>
datafile 19 switched to datafile copy "+DATA/rac/datafile/cc_prev_12mth.288.928812175"
RMAN>
datafile 22 switched to datafile copy "+DATA/rac/datafile/qn2.289.928812371"

alter tablespace Q3_ORDERS online;
alter tablespace Q4_ORDERS online;
alter tablespace "2006_ORDERS" online;
alter tablespace "2005_ORDERS" online;
alter tablespace "2004_ORDERS" online;
alter tablespace OLD_ORDERS online;
alter tablespace CC_THIS_MONTH online;
alter tablespace CC_PREV_MONTH online;
alter tablespace CC_PREV_12MTH online;
alter tablespace QN2 online;

sys@RAC>  select file_name ,tablespace_name from dba_data_files  where tablespace_name in ('Q1_ORDERS','Q2_ORDERS','Q3_ORDERS','Q4_ORDERS','2006_ORDERS','2005_ORDERS','2004_ORDERS','OLD_ORDERS','CC_THIS_MONTH','CC_PREV_MONTH','CC_PREV_12MTH','QN2' ) ;
FILE_NAME                             TABLESPACE_NAME
------------------------------------------------------------ ------------------------------
+DATA/rac/datafile/q1_orders.278.928810547             Q1_ORDERS
+DATA/rac/datafile/q2_orders.279.928812061             Q2_ORDERS
+DATA/rac/datafile/q3_orders.280.928812071             Q3_ORDERS
+DATA/rac/datafile/q4_orders.281.928812085             Q4_ORDERS
+DATA/rac/datafile/2006_orders.282.928812095             2006_ORDERS
+DATA/rac/datafile/2005_orders.283.928812109             2005_ORDERS
+DATA/rac/datafile/2004_orders.284.928812123             2004_ORDERS
+DATA/rac/datafile/old_orders.285.928812137             OLD_ORDERS
+DATA/rac/datafile/cc_this_month.286.928812151             CC_THIS_MONTH
+DATA/rac/datafile/cc_prev_month.287.928812167             CC_PREV_MONTH
+DATA/rac/datafile/cc_prev_12mth.288.928812175             CC_PREV_12MTH
+DATA/rac/datafile/qn2.289.928812371                 QN2

至此系统上的数据文件都迁移到asm上。

更多相关教程请访问 MySQL视频教程

本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

热AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智能驱动的应用程序，用于创建逼真的裸体照片

AI Clothes Remover

AI Clothes Remover

用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool

Undress AI Tool

免费脱衣服图片

Clothoff.io

Clothoff.io

AI脱衣机

Video Face Swap

Video Face Swap

使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸！

显示更多

热门文章

如何修复KB5055523无法在Windows 11中安装？
4 周前 By DDD
如何修复KB5055518无法在Windows 10中安装？
4 周前 By DDD
<🎜>：种植花园 - 完整的突变指南
2 周前 By DDD
<🎜>：泡泡胶模拟器无穷大 - 如何获取和使用皇家钥匙
3 周前 By 尊渡假赌尊渡假赌尊渡假赌
如何修复KB5055612无法在Windows 10中安装？
3 周前 By DDD
显示更多

热工具

记事本++7.3.1

记事本++7.3.1

好用且免费的代码编辑器

SublimeText3汉化版

SublimeText3汉化版

中文版，非常好用

禅工作室 13.0.1

禅工作室 13.0.1

功能强大的PHP集成开发环境

Dreamweaver CS6

Dreamweaver CS6

视觉化网页开发工具

SublimeText3 Mac版

SublimeText3 Mac版

神级代码编辑软件(SublimeText3)

显示更多

热门话题

Java教程
1663
14
CakePHP 教程
1420
52
Laravel 教程
1313
25
PHP教程
1266
29
C# 教程
1239
24
显示更多
Related knowledge
oracle打不开怎么办 oracle打不开怎么办 Apr 11, 2025 pm 10:06 PM

Oracle 打不开的解决办法包括：1. 启动数据库服务；2. 启动监听器；3. 检查端口冲突；4. 正确设置环境变量；5. 确保防火墙或防病毒软件未阻止连接；6. 检查服务器是否已关闭；7. 使用 RMAN 恢复损坏的文件；8. 检查 TNS 服务名称是否正确；9. 检查网络连接；10. 重新安装 Oracle 软件。

oracle游标关闭怎么解决 oracle游标关闭怎么解决 Apr 11, 2025 pm 10:18 PM

解决 Oracle 游标关闭问题的方法包括：使用 CLOSE 语句显式关闭游标。在 FOR UPDATE 子句中声明游标，使其在作用域结束后自动关闭。在 USING 子句中声明游标，使其在关联的 PL/SQL 变量关闭时自动关闭。使用异常处理确保在任何异常情况下关闭游标。使用连接池自动关闭游标。禁用自动提交，延迟游标关闭。

oracle怎么循环创建游标 oracle怎么循环创建游标 Apr 12, 2025 am 06:18 AM

Oracle 中，FOR LOOP 循环可动态创建游标， 步骤为：1. 定义游标类型；2. 创建循环；3. 动态创建游标；4. 执行游标；5. 关闭游标。示例：可循环创建游标，显示前 10 名员工姓名和工资。

oracle日志写满怎么办 oracle日志写满怎么办 Apr 12, 2025 am 06:09 AM

Oracle 日志文件写满时，可采用以下解决方案：1）清理旧日志文件；2）增加日志文件大小；3）增加日志文件组；4）设置自动日志管理；5）重新初始化数据库。在实施任何解决方案前，建议备份数据库以防数据丢失。

HDFS配置CentOS需要哪些步骤 HDFS配置CentOS需要哪些步骤 Apr 14, 2025 pm 06:42 PM

在CentOS系统上搭建Hadoop分布式文件系统（HDFS）需要多个步骤，本文提供一个简要的配置指南。一、前期准备安装JDK:在所有节点上安装JavaDevelopmentKit(JDK)，版本需与Hadoop兼容。可从Oracle官网下载安装包。环境变量配置:编辑/etc/profile文件，设置Java和Hadoop的环境变量，使系统能够找到JDK和Hadoop的安装路径。二、安全配置：SSH免密登录生成SSH密钥:在每个节点上使用ssh-keygen命令

甲骨文在商业世界中的作用 甲骨文在商业世界中的作用 Apr 23, 2025 am 12:01 AM

Oracle不仅是数据库公司，还是云计算和ERP系统的领导者。1.Oracle提供从数据库到云服务和ERP系统的全面解决方案。2.OracleCloud挑战AWS和Azure，提供IaaS、PaaS和SaaS服务。3.Oracle的ERP系统如E-BusinessSuite和FusionApplications帮助企业优化运营。

oracle数据库怎么停止 oracle数据库怎么停止 Apr 12, 2025 am 06:12 AM

要停止 Oracle 数据库，请执行以下步骤：1. 连接到数据库；2. 优雅关机数据库（shutdown immediate）；3. 完全关机数据库（shutdown abort）。

oracle视图怎么导出 oracle视图怎么导出 Apr 12, 2025 am 06:15 AM

可以通过 EXP 实用程序导出 Oracle 视图：登录 Oracle 数据库。启动 EXP 实用程序，指定视图名称和导出目录。输入导出参数，包括目标模式、文件格式和表空间。开始导出。使用 impdp 实用程序验证导出。

See all articles