| i have lost all of controlfile .how do i recover. [message #62100] |
Thu, 24 June 2004 18:58  |
Jerry
Messages: 21
Registered: December 1999
|
Junior Member |
|
|
[sp]
[sp]my db is oracle 8i ....and archive mode....i have lost all of
controlfile ....how do i recover db...i have backup control files
and archive log files...
copy /backup/controlfile01.ctl /disk01/controlfile01.ctl
copy /backup/controlfile02.ctl /disk01/controlfile02.ctl
copy /backup/controlfile03.ctl /disk01/controlfile03.ctl
SQL> startup mount;
ORACLE is started.
Total System Global Area[sp] 237008140 bytes
Fixed Size[sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp] 70924 bytes
Variable Size[sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp] 79572992 bytes
Database Buffers[sp][sp][sp][sp][sp][sp][sp][sp][sp] 157286400 bytes
Redo Buffers[sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp][sp] 77824 bytes
instance is mounted
SQL> recover database using backup controlfile;
ORA-00279: ?? 241565? (06/25/2004 10:00:13?? ???) ??? 1? ?????
ORA-00289: ?? : F:ORACLEORADATATEST1ARCHIVETEST1T001S00016.ARC
ORA-00280: ?? 241565(??? 1? ??)? ????? 16? ????
·Î±× ÁöÁ¤: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: ????? ?? 'F:ORACLEORADATATEST1ARCHIVETEST1T001S00016.ARC
????
ORA-27041: ??? ? ? ????
OSD-04002: FD@O@; ?- <v >x=@4O4Y
O/S-Error: (OS 2) AvA$5H FD@O@; C#@; <v >x=@4O4Y.
SQL> alter database open resetlogs;
alter database open resetlogs
*
1Çà¿¡ ¿À·ù:
ORA-01113: 1 ??? ?? ????? ???
ORA-01110: 1 ??? ??: 'F:ORACLEORADATATEST1SYSTEM01.DBF'
i have some error....i don'tknow why it didn't work...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
