| recovery prob [message #63632] |
Thu, 21 October 2004 08:20  |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
After the restore and database recovery, I go to open the database and get a file recovery error on ORA_SYSTEM.DBS.
**************************************
Oracle7 Server Release 7.1.5.2.3 - Production Release
PL/SQL Release 2.1.5.2.0 - Production
SQLDBA> CONNECT INTERNAL
Connected.
SQLDBA> STARTUP MOUNT
ORACLE instance started.
Database mounted.
SQLDBA> RECOVER DATABASE UNTIL BACKUP CONTROLFILE;
ORA-00277: Illegal option to the UNTIL recovery flag BACKUP
SQLDBA>
RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00279: Change 127299846 generated at 10/19/04 18:35:34 needed for thread 1
ORA-00289: Suggestion : $1$DKD104:[[P02_ARCHIVELOGS]]P02_t0001S1889.ARC
ORA-00280: Change 127299846 for thread 1 is in sequence #1889 Specify log: {<RET>=suggested | filename | AUTO | FROM logsource | CANCEL}
Applying suggested logfile...
ORA-00308: cannot open archived log '$1$DKD104:[[P02_ARCHIVELOGS]]P02_t0001S1889.A
RC'
ORA-07528: sfifi: $open error
%RMS-E-FNF, file not found - %SYSTEM-W-NOSUCHFILE, no such file Specify log: {<RET>=suggested | filename | AUTO | FROM logsource | CANCEL} CANCEL Media recovery cancelled.
SQLDBA> ALTER DATABASE OPEN RESETLOGS;
ORA-01194: file 1 needs more recovery to be consistant
ORA-01110: data file 1: 'DKD104:[[ORACLE7.DB_P02]]ORA_SYSTEM.DBS'
SQLDBA> SHUTDOWN
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQLDBA> Exit
*********************************************************
|
|
|
|
| Re: recovery prob [message #63634 is a reply to message #63632] |
Thu, 21 October 2004 10:45  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
Oracle is trying to apply suggested redolog (i assume your database is in archivelog mode) if not...mmm..
i believe it is going to be difficult to recover db.
Don't you havo those archived redo log?, are they on tape?, you will haver to restore all archived redolog.
If not found the suggested archived redolog, you can try recover until time
so you can recover until time from previous redolog that you do chave on disk or tape.
For example, look at the following list:
redofile1.dbf 05/01/04:07:10
redofile2.dbaf 05/01/04:07:30
redofile3.dbf 05/01/04:07:50
redofile4.dbaf 05/01/04:08:20
let's say that oracle will suggest redofile5.dbf
after you specified recover until cancel
as that file does not exist, you can try
recover until time '05/01/04:08:19'
then oracle will cancel recover after applying redofile3.dbf
That's the way i always performed my recovery on oracle7.
Since oracle8i, i use RMAN.
Hope this helps.
Best luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
