COLD BACKUP(二)

还原整个数据库!

[@more@]

Table created.



COL01
-----------
16-Apr-2007







NAME
------------------------------------------------------------------------------------------------------------------------
D:ORACLEORADATAHUIYISYSTEM01.DBF
D:ORACLEORADATAHUIYIUNDOTBS01.DBF
D:ORACLEORADATAHUIYIDRSYS01.DBF
D:ORACLEORADATAHUIYIEXAMPLE01.DBF
D:ORACLEORADATAHUIYIINDX01.DBF
D:ORACLEORADATAHUIYIODM01.DBF
D:ORACLEORADATAHUIYITOOLS01.DBF
D:ORACLEORADATAHUIYIUSERS01.DBF
D:ORACLEORADATAHUIYIXDB01.DBF
D:ORACLEORADATAHUIYITBS01-01.DBF
D:ORACLEORADATAHUIYITBS01-02.DBF
D:ORACLEORADATAHUIYIPERFSTAT01.DBF

12 rows selected.


Database closed.
Database dismounted.
ORACLE instance shut down.



ORACLE instance started.

Total System Global Area  147921840 bytes
Fixed Size                   453552 bytes
Variable Size             109051904 bytes
Database Buffers           37748736 bytes
Redo Buffers                 667648 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: 'D:ORACLEORADATAHUIYITBS01-01.DBF'



ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.





ORACLE instance started.

Total System Global Area  147921840 bytes
Fixed Size                   453552 bytes
Variable Size             109051904 bytes
Database Buffers           37748736 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.


COL01
-----------
16-Apr-2007





Table created.



COL01
---------
16-APR-07









ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/opt/oracle/oradata/huiyi/tbs01-01.dbf'



ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.




ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.


COL01
---------
16-APR-07

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8799875/viewspace-914230/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8799875/viewspace-914230/