oracle數(shù)據(jù)庫實驗記錄

ORACLE10g將數(shù)據(jù)文件，志文件和控文件遷移不同的路徑Colnamefora50數(shù)據(jù)文件，控制文件和志文件原路徑在:"d:\oracle\10g\orcl",現(xiàn)在將它們遷移至“d:\oracle\database\orcl”中。具體操作截圖如：數(shù)據(jù)文件移：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數(shù)據(jù)庫已關閉。

已經(jīng)卸載據(jù)庫。ORACLE例程已經(jīng)關。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例程已經(jīng)啟。TotalSystemGlobalArea167772160bytesFixedSize1247900bytesVariableSize92276068bytesDatabaseBuffers71303168bytesRedoBuffers2945024bytes數(shù)據(jù)庫裝完畢。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';數(shù)據(jù)庫已改。SQL>alterdatabaseopen2;數(shù)據(jù)庫已改。

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;系統(tǒng)已更。

SQL>shutdownimmediate數(shù)據(jù)庫已關閉。已經(jīng)卸載據(jù)庫。ORACLE例程已經(jīng)關。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例程已經(jīng)啟。TotalSystemGlobalArea167772160bytesFixedSize1247900bytesVariableSize96470372bytesDatabaseBuffers67108864bytesRedoBuffers2945024bytes數(shù)據(jù)庫裝完畢。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';數(shù)據(jù)庫已改。SQL>alterdatabaseopen2;數(shù)據(jù)庫已改。SQL>altersystemswitchlogfile;

系統(tǒng)已更。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控制文件移將數(shù)據(jù)庫SHUTDOWN,然后修改pfile的控制文件的路徑，以pfile文件動數(shù)據(jù)庫，然后createspfilefrompfile.最后以spfile動數(shù)據(jù)庫即可。ORA-01078&LRM-00109

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