??????ζ?Oracle??????????????????????????????????????Щ?????????????????????????????????????????????????????

???????????

??????oracle10g?????

????coldbak?????

--connect database
connect sys/???趨?????? as sysdba??
--shutdown database
shutdown immediate??
--Copy Data file
Host xcopy d??Oracleproduct10.2.0oradataorcl*.dbf d??DbBakup??
--Copy Control file
Host xcopy d??Oracleproduct10.2.0oradataorcl*.ctl d??DbBakup??
--Copy Log file
Host xcopy d??Oracleproduct10.2.0oradataorcl*.log d??DbBakup??
--startup database
startup??

?????????????????????±??б????*.sql??????????????п??????(*.ctl)?????????(*.dbf)????????(*.log)??·?????????·??????“d??DbBakup”?????·???????????????????????е???????????????е?dbf???????????????У???????EM?в???????е????????·?????

??????????????裺

????1.????????????cmd??

????2.??cmd??????????sqlplus/nolog????sql*plus??

????3.??dba????????????conn sys/???趨?????? as sysdba??

????4.????????????@??????·????

?????????????

?????????????????????????????????????????????????????汾oracle?????????????????

??????????????裺

????1.????????????cmd??

????2.??cmd??????????sqlplus/nolog????sql*plus??

????3.??dba????????????conn sys/???趨?????? as sysdba??

????4.????shutdown immediate??

????5.?????????????濽??????????oracle???С?

????6.??????????sql>???????startup??

???????????????EM????????oracle???????????????????????????????????????????裬??????????????????????????????????????????????????????????????????????軹????EM??

???????EM???裺

????????????EM????

????1.???EM

????A.??cmd??????????emca -repos drop

????B.?????????????а??????????????????

????2.????EM

????A.??cmd??????????emca -repos create

????B.?????????????а??????????????????

????3.????EM

????A.??cmd??????????emca -config dbcontrol db

????B.?????????????а??????????????????

????????Oracle????????????????????????????????????ε??????????????Щ???лл??