俄语版sapR3虚拟机ORACLE数据库移动参考
种子在pub里找，就是那个俄罗斯的sapR3的9.55G的文件，以前发过一个帖子，后来发现一些问题，这里更新下
增大存在的虚拟磁盘的大小
命令：vmware-vdiskmanager -x 150GB myDisk.vmdk
这条命令将把虚拟磁盘myDisk.vmdk大小增大到150GB
实际命令输入：
C:\Program Files\VMware\VMware Workstation>vmware-vdiskmanager -x 150GB "D:\sapR3\sapr3.vmdk"
执行结果显示：
Using log file C:\DOCUME~1\xujun\LOCALS~1\Temp\vmware-AnEgg\vdiskmanager.log
Grow: 100% done.
The old geometry C/H/S of the disk is: 8322/16/63
The new geometry C/H/S of the disk is: 16383/16/63
Disk expansion completed successfully.
WARNING: If the virtual disk is partitioned, you must use a third-party
utility in the virtual machine to expand the size of the
partitions. For more information, see:
http://www.vmware.com/support/kb/enduser/std_adp.php?p_faqid=1647
#########################################################################################
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>SQLPLUS/NOLOG
#登录Oracle命令行模式#
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Sep 5 09:00:37 2016
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
SQL> CONNECT / AS SYSDBA;
#连接数据库#
Connected.
SQL> SELECT FILE_NAME FROM SYS.DBA_DATA_FILES;
#查询可移动的数据库清单#
FILE_NAME
--------------------------------------------------------------------------------
C:\ORACLE\TST\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
C:\ORACLE\TST\SAPDATA2\ROLL_1\ROLL.DATA1
C:\ORACLE\TST\SAPDATA3\TST_1\TST.DATA1
C:\ORACLE\TST\SAPDATA3\TST_2\TST.DATA2
C:\ORACLE\TST\SAPDATA3\TST_3\TST.DATA3
C:\ORACLE\TST\SAPDATA3\TST_4\TST.DATA4
C:\ORACLE\TST\SAPDATA4\TST_5\TST.DATA5
C:\ORACLE\TST\SAPDATA4\TST_6\TST.DATA6
C:\ORACLE\TST\SAPDATA4\TST_7\TST.DATA7
C:\ORACLE\TST\SAPDATA4\TST_8\TST.DATA8
C:\ORACLE\TST\SAPDATA4\TST_9\TST.DATA9
FILE_NAME
--------------------------------------------------------------------------------
C:\ORACLE\TST\SAPDATA1\TST620_1\TST620.DATA1
C:\ORACLE\TST\SAPDATA1\TST620_2\TST620.DATA2
C:\ORACLE\TST\SAPDATA1\TST620_3\TST620.DATA3
C:\ORACLE\TST\SAPDATA1\TST620_4\TST620.DATA4
C:\ORACLE\TST\SAPDATA2\TST620_5\TST620.DATA5
C:\ORACLE\TST\SAPDATA2\TST620_6\TST620.DATA6
C:\ORACLE\TST\SAPDATA2\TST620_7\TST620.DATA7
C:\ORACLE\TST\SAPDATA2\TST620_8\TST620.DATA8
C:\ORACLE\TST\SAPDATA2\TST620_9\TST620.DATA9
C:\ORACLE\TST\SAPDATA3\TST620_10\TST620.DATA10
C:\ORACLE\TST\SAPDATA4\TST620_11\TST620.DATA11
FILE_NAME
--------------------------------------------------------------------------------
C:\ORACLE\TST\SAPDATA1\TSTUSR_1\TSTUSR.DATA1
23 rows selected.
SQL> SHUTDOWN IMMEDIATE;
#关闭数据库#
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
#进入MOUNT模式#
ORACLE instance started.
Total System Global Area484777796 bytes
Fixed Size
454468 bytes
Variable Size
268435456 bytes
Database Buffers
214695936 bytes
Redo Buffers
1191936 bytes
Database mounted.
SQL>
#执行到这里的时候，复制C:\ORACLE\TST到D:\ORACLE\TST#
#在MOUNT模式下的复制，不用执行后面的“RECOVER”命令#
#如果中途退出，一定再次执行到这里后再进行后面的操作#
################################################################################################
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>SQLPLUS/NOLOG
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Sep 5 14:19:12 2016
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
SQL> CONNECT / AS SYSDBA;
Connected.
SQL> SHUTDOWN IMMEDIATE;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
#中途重启了操作系统，需要重新执行到MOUNT模式下#
ORACLE instance started.
Total System Global Area484777796 bytes
Fixed Size
454468 bytes
Variable Size
268435456 bytes
Database Buffers
214695936 bytes
Redo Buffers
1191936 bytes
Database mounted.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA1\SYSTEM_1\SYSTEM.DATA1' TO 'D:\ORACLE\TST\SAPDATA1\SYSTEM_1\SYSTEM.DATA1';
#将C盘的数据库文件的逻辑地址移动到D盘，共23个文件需要移动#
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA2\ROLL_1\ROLL.DATA1' TO 'D:\ORACLE\TST\SAPDATA2\ROLL_1\ROLL.DATA1';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA3\TST_1\TST.DATA1' TO 'D:\ORACLE\TST\SAPDATA3\TST_1\TST.DATA1';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA3\TST_2\TST.DATA2' TO 'D:\ORACLE\TST\SAPDATA3\TST_2\TST.DATA2';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA3\TST_3\TST.DATA3' TO 'D:\ORACLE\TST\SAPDATA3\TST_3\TST.DATA3';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA3\TST_4\TST.DATA4' TO 'D:\ORACLE\TST\SAPDATA3\TST_4\TST.DATA4';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA4\TST_5\TST.DATA5' TO 'D:\ORACLE\TST\SAPDATA4\TST_5\TST.DATA5';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA4\TST_6\TST.DATA6' TO 'D:\ORACLE\TST\SAPDATA4\TST_6\TST.DATA6';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA4\TST_7\TST.DATA7' TO 'D:\ORACLE\TST\SAPDATA4\TST_7\TST.DATA7';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA4\TST_8\TST.DATA8' TO 'D:\ORACLE\TST\SAPDATA4\TST_8\TST.DATA8';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA4\TST_9\TST.DATA9' TO 'D:\ORACLE\TST\SAPDATA4\TST_9\TST.DATA9';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA1\TST620_1\TST620.DATA1' TO 'D:\ORACLE\TST\SAPDATA1\TST620_1\TST620.DATA1';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA1\TST620_2\TST620.DATA2' TO 'D:\ORACLE\TST\SAPDATA1\TST620_2\TST620.DATA2';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA1\TST620_3\TST620.DATA3' TO 'D:\ORACLE\TST\SAPDATA1\TST620_3\TST620.DATA3';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA1\TST620_4\TST620.DATA4' TO 'D:\ORACLE\TST\SAPDATA1\TST620_4\TST620.DATA4';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA2\TST620_5\TST620.DATA5' TO 'D:\ORACLE\TST\SAPDATA2\TST620_5\TST620.DATA5';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA2\TST620_6\TST620.DATA6' TO 'D:\ORACLE\TST\SAPDATA2\TST620_6\TST620.DATA6';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA2\TST620_7\TST620.DATA7' TO 'D:\ORACLE\TST\SAPDATA2\TST620_7\TST620.DATA7';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA2\TST620_8\TST620.DATA8' TO 'D:\ORACLE\TST\SAPDATA2\TST620_8\TST620.DATA8';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA2\TST620_9\TST620.DATA9' TO 'D:\ORACLE\TST\SAPDATA2\TST620_9\TST620.DATA9';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA3\TST620_10\TST620.DATA10' TO 'D:\ORACLE\TST\SAPDATA3\TST620_10\TST620.DATA10';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA4\TST620_11\TST620.DATA11' TO 'D:\ORACLE\TST\SAPDATA4\TST620_11\TST620.DATA11';
Database altered.
SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\TST\SAPDATA1\TSTUSR_1\TSTUSR.DATA1' TO 'D:\ORACLE\TST\SAPDATA1\TSTUSR_1\TSTUSR.DATA1';
Database altered.
SQL> ALTER DATABASE OPEN;
#在复制C:\ORACLE\TST文件时，没有启动到MOUNT模式下#
#系统两条报错提示，需要执行RECOVER命令#
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\TST\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA1\SYSTEM_1\SYSTEM.DATA1';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA2\ROLL_1\ROLL.DATA1';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA3\TST_1\TST.DATA1';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA3\TST_2\TST.DATA2';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA3\TST_3\TST.DATA3';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA3\TST_4\TST.DATA4';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA4\TST_5\TST.DATA5';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA4\TST_6\TST.DATA6';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA4\TST_7\TST.DATA7';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA4\TST_8\TST.DATA8';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA4\TST_9\TST.DATA9';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA1\TST620_1\TST620.DATA1';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA1\TST620_2\TST620.DATA2';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA1\TST620_3\TST620.DATA3';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA1\TST620_4\TST620.DATA4';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA2\TST620_5\TST620.DATA5';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA2\TST620_6\TST620.DATA6';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA2\TST620_7\TST620.DATA7';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA2\TST620_8\TST620.DATA8';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA2\TST620_9\TST620.DATA9';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA3\TST620_10\TST620.DATA10';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA4\TST620_11\TST620.DATA11';
Media recovery complete.
SQL> RECOVER DATAFILE 'D:\ORACLE\TST\SAPDATA1\TSTUSR_1\TSTUSR.DATA1';
Media recovery complete.
SQL> ALTER DATABASE OPEN;
#重新打开数据库#
Database altered.
SQL> EXIT
#退出ORACLE命令模式，注意语句结尾没有分号#
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
C:\Documents and Settings\Administrator>
|
