oracle数据库实验记录

ORACLE10g将数据文件，志文件和控文件迁移不同的路径Colnamefora50数据文件，控制文件和志文件原路径在:"d:\oracle\10g\orcl",现在将它们迁移至“d:\oracle\database\orcl”中。具体操作截图如：数据文件移：SQL>selectname,file#fromv$datafile;NAME--------------------------------------------------------------------------------FILE#----------D:\ORACLE\10G\ORCL\SYSTEM01.DBF1D:\ORACLE\10G\ORCL\UNDOTBS01.DBF2D:\ORACLE\10G\ORCL\SYSAUX01.DBF3NAME--------------------------------------------------------------------------------FILE#----------D:\ORACLE\10G\ORCL\USERS01.DBF4SQL>shutdownimmediate数据库已关闭。

已经卸载据库。ORACLE例程已经关。SQL>$moved:\oracle\10g\orcl\system01.dbfd:\oracle\database\orcl\system01.dbfSQL>$moved:\oracle\10g\orcl\undotbs01.dbfd:\oracle\database\orcl\undotbs01.dbfSQL>$moved:\oracle\10g\orcl\sysaux01.dbfd:\oracle\database\orcl\sysaux01.dbfSQL>$moved:\oracle\10g\orcl\users01.dbfd:\oracle\database\orcl\users01.dbfSQL>startupmountORACLE例程已经启。TotalSystemGlobalArea167772160bytesFixedSize1247900bytesVariableSize92276068bytesDatabaseBuffers71303168bytesRedoBuffers2945024bytes数据库装完毕。SQL>alterdatabase2rename3'd:\oracle\10g\orcl\system01.dbf',4'd:\oracle\10g\orcl\undotbs01.dbf',5'd:\oracle\10g\orcl\sysaux01.dbf',6'd:\oracle\10g\orcl\users01.dbf'7to8'd:\oracle\database\orcl\system01.dbf',9'd:\oracle\database\orcl\undotbs01.dbf',10'd:\oracle\database\orcl\sysaux01.dbf',11'd:\oracle\database\orcl\users01.dbf';数据库已改。SQL>alterdatabaseopen2;数据库已改。

SQL>selectname,statusfromv$datafile;NAME------------------------------------------STATUS-------D:\ORACLE\DATABASE\ORCL\SYSTEM01.DBFSYSTEMD:\ORACLE\DATABASE\ORCL\UNDOTBS01.DBFONLINED:\ORACLE\DATABASE\ORCL\SYSAUX01.DBFONLINENAME------------------------------------------STATUS-------D:\ORACLE\DATABASE\ORCL\USERS01.DBFONLINE日志文件移SQL>select*v$log;GROUP#THREAD#SEQUENCE#BYTESMEMBERSARC-----------------------------------------------------FIRST_CHANGE#FIRST_TIME---------------------------112524288001NOCURRENT54267707-11月-06210524288001YESUNUSED0

311524288001YESINACTIVE53490707-11月-06SQL>select*v$logfile;GROUP#STATUS------------------------MEMBER--------------------------------------------------------------------------------IS_---3ONLINED:\ORACLE\10G\ORCL\REDO03.LOGNO2ONLINED:\ORACLE\10G\ORCL\REDO02.LOGNOGROUP#STATUS------------------------MEMBER--------------------------------------------------------------------------------IS_---1ONLINED:\ORACLE\10G\ORCL\REDO01.LOGNOSQL>altersystemswitchlogfile;系统已更。

SQL>shutdownimmediate数据库已关闭。已经卸载据库。ORACLE例程已经关。SQL>$moved:\oracle\10g\orcl\redo01.logd:\oracle\database\orcl\redo01.logSQL>$moved:\oracle\10g\orcl\redo02.logd:\oracle\database\orcl\redo02.logSQL>$moved:\oracle\10g\orcl\redo03.logd:\oracle\database\orcl\redo03.logSQL>startupmountORACLE例程已经启。TotalSystemGlobalArea167772160bytesFixedSize1247900bytesVariableSize96470372bytesDatabaseBuffers67108864bytesRedoBuffers2945024bytes数据库装完毕。SQL>alterdatabase2rename3'd:\oracle\10g\orcl\redo01.log',4'd:\oracle\10g\orcl\redo02.log',5'd:\oracle\10g\orcl\redo03.log'6to7'd:\oracle\database\orcl\redo01.log',8'd:\oracle\database\orcl\redo02.log',9'd:\oracle\database\orcl\redo03.log';数据库已改。SQL>alterdatabaseopen2;数据库已改。SQL>altersystemswitchlogfile;

系统已更。SQL>select*v$logfile;GROUP#STATUS------------------------MEMBER--------------------------------------------------------------------------------IS_---3ONLINED:\ORACLE\DATABASE\ORCL\REDO03.LOGNO2ONLINED:\ORACLE\DATABASE\ORCL\REDO02.LOGNOGROUP#STATUS------------------------MEMBER--------------------------------------------------------------------------------IS_---1ONLINED:\ORACLE\DATABASE\ORCL\REDO01.LOGNO控制文件移将数据库SHUTDOWN,然后修改pfile的控制文件的路径，以pfile文件动数据库，然后createspfilefrompfile.最后以spfile动数据库即可。ORA-01078&LRM-00109

错误信息SQL>startupORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile'/opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.or