Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help !

Re: Help !

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 23 Dec 2001 16:25:03 GMT
Message-ID: <zznV7.1157$Sa5.1076@rwcrnsc53>


Start over.

1. Create a new database.
2. Run in archive log mode.
3. Take backups.
4. Get a book on Oracle Backup and Recovery.
Jim
"purva" <purvamitra_at_yahoo.com> wrote in message news:1ae62ae2.0112230805.1f62fc9b_at_posting.google.com...
> 1. I have oracle 8.1.7 on win2k
> 2. It's running in noarchive mode.
> 3. Crash
> 4. Restored all oracle files but do not have backups of application data
and
> index files.
> 5. startup
> 6. recover database
> 7. Demands recover with backup controlfile
> 8. recover database using backup controlfile
> 9. demands an arc00079.001 which I don't have ! cancelled
> 10.Now every file in the database is in recover status
>
> I can live with data loss, as there were no changes.
> How should i proceed ??
Received on Sun Dec 23 2001 - 10:25:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US