设为首页 加入收藏

TOP

Oracle数据库迁移--->从Windows到Linux(五)
2015-07-24 11:26:34 来源: 作者: 【 】 浏览:25
Tags:Oracle 数据库 迁移 ---> Windows Linux
it.ora -rw-r--r-- 1 oracle oinstall 1331 Sep 4 12:37 initWatson.ora -rw-rw---- 1 oracle oinstall 24 Sep 3 04:23 lkOMR -rw-r----- 1 oracle oinstall 1536 Sep 3 05:32 orapwOMR -rw-r----- 1 oracle oinstall 2560 Sep 4 12:00 spfileOMR.ora 8,startup the database [oracle@even dbs]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 4 12:50:48 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1221972 bytes Variable Size 209717932 bytes Database Buffers 591396864 bytes Redo Buffers 2969600 bytes 8, create spfile which is used for startup instance SQL> create spfile from pfile; File created. 8, restart the instance SQL> startup force nomount; ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1221972 bytes Variable Size 209717932 bytes Database Buffers 591396864 bytes Redo Buffers 2969600 bytes 9, copy the files in the directory /home/oracle/trans to /u01/app/oracle/oradata/Watson [oracle@even trans]$ ll total 2552388 -rw-r--r-- 1 oracle oinstall 262152192 Sep 6 2013 DATA_D-XE_I-2705070866_TS-MMDB_DAT1_FNO-8_06OJ5L65 -rw-r--r-- 1 oracle oinstall 262152192 Sep 6 2013 DATA_D-XE_I-2705070866_TS-MMDB_LOB1_FNO-10_08OJ5L73 -rw-r--r-- 1 oracle oinstall 262152192 Sep 6 2013 DATA_D-XE_I-2705070866_TS-MMDB_NDX1_FNO-9_07OJ5L6K -rw-r--r-- 1 oracle oinstall 262152192 Sep 6 2013 DATA_D-XE_I-2705070866_TS-PMDB_DAT1_FNO-5_04OJ5L4I -rw-r--r-- 1 oracle oinstall 262152192 Sep 6 2013 DATA_D-XE_I-2705070866_TS-PMDB_LOB1_FNO-7_05OJ5L5B -rw-r--r-- 1 oracle oinstall 272637952 Sep 6 2013 DATA_D-XE_I-2705070866_TS-PMDB_NDX1_FNO-6_03OJ5L43 -rw-r--r-- 1 oracle oinstall 461381632 Sep 6 2013 DATA_D-XE_I-2705070866_TS-SYSAUX_FNO-3_01OJ5L2R -rw-r--r-- 1 oracle oinstall 367009792 Sep 6 2013 DATA_D-XE_I-2705070866_TS-SYSTEM_FNO-1_02OJ5L3K -rw-r--r-- 1 oracle oinstall 94380032 Sep 6 2013 DATA_D-XE_I-2705070866_TS-UNDO_FNO-2_0AOJ5L7Q -rw-r--r-- 1 oracle oinstall 104865792 Sep 6 2013 DATA_D-XE_I-2705070866_TS-USERS_FNO-4_09OJ5L7J -rw-r--r-- 1 oracle oinstall 1331 Sep 4 12:33 INIT_00OJ5L2R_1_0.ORA [oracle@even trans]$ cp DATA* /u01/app/oracle/oradata/Watson 10, check the files whether is in it [oracle@even Watson]$ ll total 2552384 -rw-r--r-- 1 oracle oinstall 262152192 Sep 4 12:55 DATA_D-XE_I-2705070866_TS-MMDB_DAT1_FNO-8_06OJ5L65 -rw-r--r-- 1 oracle oinstall 262152192 Sep 4 12:56 DATA_D-XE_I-2705070866_TS-MMDB_LOB1_FNO-10_08OJ5L73 -rw-r--r-- 1 oracle oinstall 262152192 Sep 4 12:56 DATA_D-XE_I-2705070866_TS-MMDB_NDX1_FNO-9_07OJ5L6K -rw-r--r-- 1 oracle oinstall 262152192 Sep 4 12:57 DATA_D-XE_I-2705070866_TS-PMDB_DAT1_FNO-5_04OJ5L4I -rw-r--r-- 1 oracle oinstall 262152192 Sep 4 12:57 DATA_D-XE_I-2705070866_TS-PMDB_LOB1_FNO-7_05OJ5L5B -rw-r--r-- 1 oracle oinstall 272637952 Sep 4 12:58 DATA_D-XE_I-2705070866_TS-PMDB_NDX1_FNO-6_03OJ5L43 -rw-r--r-- 1 oracle oinstall 461381632 Sep 4 12:58 DATA_D-XE_I-2705070866_TS-SYSAUX_FNO-3_01OJ5L2R -rw-r--r-- 1 oracle oinstall 367009792 Sep 4 12:59 DATA_D-XE_I-2705070866_TS-SYSTEM_FNO-1_02OJ5L3K -rw-r--r-- 1 oracle oinstall 94380032 Sep 4 12:59 DATA_D-XE_I-2705070866_TS-UNDO_FNO-2_0AOJ5L7Q -rw-r--r-- 1 oracl
首页 上一页 2 3 4 5 6 7 8 下一页 尾页 5/9/9
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇hibernate4中oracle,sqlserver,my.. 下一篇oracle之表空间(tablespace)、方..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·如何在 C 语言中管理 (2025-12-25 03:20:14)
·C语言和内存管理有什 (2025-12-25 03:20:11)
·为什么C语言从不被淘 (2025-12-25 03:20:08)
·常用meta整理 | 菜鸟 (2025-12-25 01:21:52)
·SQL HAVING 子句:深 (2025-12-25 01:21:47)