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

Oracle数据库移植 安装oracle9.2（具体见图） 更改oracle数据库文件夹中的def_ORACLE.ora文件，路径指向orcl的路径 停止orcl服务，shutdown数据库orcl sqlplus下由def_ORACLE.ora文件生成D:\oracle\ora92\database\SPFILEORCL.ORA文件 cmd下重新创建口令文件 重新启动orcl服务 C:\Documents and Settings\yqxsqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on 星期五 4月 23 18:19:02 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL conn sys/sys@mv9i as sysdba; 已连接。 SQL shutdown immediate ORA-01109: ?????? 已经卸载数据库。 ORACLE 例程已经关闭。 SQL startup ORACLE 例程已经启动。 Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers bytes Redo Buffers 667648 bytes ORA-01991: ???????D:\oracle\ora92\DATABASE\PWDmv9i.ORA SQL exit 从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production中断开 C:\Documents and Settings\yqxorapwd /? Usage: orapwd file=fname password=password entries=users 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 Settings\yqxorapwd file=d:\oracle\oradata\mv9i\mv9i.ora passwo rd=sys entries=10\ C:\Documents and Settings\yqxsqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on 星期五 4月 23 18:21:28 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL startup ORA-01031: insufficient privileges SQL conn sys/sys@mv9i as sysdba; 已连接。 SQL startup ORA-01081: ????????? ORACLE --- ????? SQL shutdown immediate ORA-01109: ?????? 已经卸载数据库。 ORACLE 例程已经关闭。 SQL startup ORACLE 例程已经启动。 Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers bytes Redo Buffers 667648 bytes ORA