oracle数据库移植,数据库备份和恢复.doc

Oracle数据库移植1. 安装oracle9.2（具体见图）2. 更改oracle数据库文件夹中的def_ORACLE.ora文件，路径指向orcl的路径3. 停止orcl服务，shutdown数据库orcl4. sqlplus下由def_ORACLE.ora文件生成D:oracleora92databaseSPFILEORCL.ORA文件5. cmd下重新创建口令文件6. 重新启动orcl服务C:Documents and Settingsyqxsqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期五 4月 23 18:19:02 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL conn sys/sysmv9i as sysdba;已连接。SQL shutdown immediateORA-01109: ?已经卸载数据库。ORACLE 例程已经关闭。SQL startupORACLE 例程已经启动。Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytesORA-01991: ?D:oracleora92DATABASEPWDmv9i.ORASQL exit从Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production中断开C:Documents and Settingsyqxorapwd /?Usage: orapwd file= password= entries= where file - name of password file (mand), password - password for SYS (mand), entries - maximum number of distinct DBA and OPERs (opt), There are no spaces around the equal-to (=) character.C:Documents and Settingsyqxorapwd file=d:oracleoradatamv9imv9i.ora password=sys entries=10C:Documents and Settingsyqxsqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期五 4月 23 18:21:28 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL startupORA-01031: insufficient privilegesSQL conn sys/sysmv9i as sysdba;已连接。SQL startupORA-01081: ? ORACLE - ?SQL shutdown immediateORA-01109: ?已经卸载数据库。ORACLE 例程已经关闭。SQL startupORACLE 例程已经启动。Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytesORA-01991: ?D:oracleora92DATABASEPWDmv9i.ORASQL exit从Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production中断开停止服务 口令修改C:Documents and Settingsyqxorapwd file=d:oracleora92databasepwdorcl8j.ora password=sys entries=10C:Documents and Settingsyqxsqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期五 4月 23 18:23:24 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL conn sys/sysmv9i as sysdba;已连接。SQL startupORA-01081: ? ORACLE - ?SQL shutdown immediateORA-01109: ?已经卸载数据库。ORACLE 例程已经关闭。SQL startupORACLE 例程已经启动。Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytes数据库装载完毕。数据库已经打开。SQL A两处修改字符集HKEY_LOCAL_MACHINESOFTWAREOR