COLD BACKUP(四)

完全恢复![@more@]

Table created.



Table created.



COL01
-------------------
2007-04-16 13:57:03



COL01
-------------------
2007-04-16 13:57:12







1 row created.



1 row created.



Commit complete.



COL01
-------------------
2007-04-16 13:57:03
2007-04-16 14:00:06



COL01
-------------------
2007-04-16 13:57:12
2007-04-16 14:00:10



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'




Database altered.


alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: 'D:ORACLEORADATAHUIYITBS01-02.DBF'




Database altered.



Database altered.


select * from t01
              *
ERROR at line 1:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:ORACLEORADATAHUIYITBS01-02.DBF'




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


d:backupcoldTBS01-01.DBF
d:backupcoldTBS01-02.DBF
        2 file(s) copied.


Media recovery complete.

Media recovery complete.


Database altered.



Database altered.



COL01
-------------------
2007-04-16 13:57:03
2007-04-16 14:00:06



COL01
-------------------
2007-04-16 13:57:12
2007-04-16 14:00:10





Table created.



Table created.



COL01
-------------------
2007-04-18 00:48:59



COL02
-------------------
2007-04-18 00:49:15







1 row created.



1 row created.



1 row created.



Commit complete.



COL01
-------------------
2007-04-18 00:48:59
2007-04-18 00:56:38
2007-04-18 00:56:45



COL02
-------------------
2007-04-18 00:49:15
2007-04-18 00:57:05






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'




Database altered.



Database altered.



Database altered.






Media recovery complete.

Media recovery complete.


Database altered.



Database altered.



COL01
-------------------
2007-04-18 00:48:59
2007-04-18 00:56:38
2007-04-18 00:56:45



COL02
-------------------
2007-04-18 00:49:15
2007-04-18 00:57:05

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

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