Re: Shutdown abort and then I Lost Redo log files


peter wrote:
Hello DBAs,

My database is in Archivelog and I have user manage backup. Now I lost
my redo log files and my database is also shutdown abort.
Now when try to open database I cannot do that........
when I try to do "Recover database until cancel" I find "Recover
success but need more recovery to be consistent datafile
"c:\oracle.....\system01.dbf" error.
after that I cann't do "Alter database open resetlogs". Please help me
to recover my database from this stage.....................

Thank You

As you lost the online redolog, you need to perform *in*complete
recovery, as opposed to complete recovery.
Incomplete recovery means
recover database until cancel using backup controlfile.

Surely you did rehearse recovery and/or read the backup and recovery
manual prior to putting the database in production?
Or alternatively, do you plan to never read any document, and to fully
rely on this forum?
You are only asking questions for which the answer can be found by
searching on http://tahiti.oracle.com in less than a minute!!!

Please stop being lazy and expecting we will pamper you and help you
out always!

--
Sybrand Bakker
Senior Oracle DBA

.

Relevant Pages

  • Re: How can I back up a log-shipped database?
    ... This means that a later log backup from the production database will not just be ... able to add the log records to the log-shipped database, because the transaction log has been ... It's clear I don't understand the whole RECOVERY business. ...
    (microsoft.public.sqlserver.server)
  • Re: Audacity and Gentoo
    ... > What's the UPS, btw? ... Still, a difference system would save a lot of space, unless database ... It would also be useful in case of data recovery as you'd at least be ... > Backup and Point-In-Time Recovery'). ...
    (uk.comp.os.linux)
  • Re: How can I back up a log-shipped database?
    ... When you bring a db out of standby mode, you get the recovery ... log backup onto this, as the log records in that log backup are totally out-of sync with the database you have ... Or MS would need to change SQL Server so it allow us to do a backup of a database in STANDBY mode. ...
    (microsoft.public.sqlserver.server)
  • Re: Shared databases and improving reliability
    ... For me that's one of the major tasks of a database! ... The mere job of data conversion is rather cumbersome for FMP itself ... After recovery the 700 000 records where available ... The backup solution ...
    (comp.databases.filemaker)
  • Re: Oracle: how to demonstrate successful restore?
    ... > We could always backup the database in tape, but we might NEVER get it ... That's called a black hole backup. ... tape could be bad after leaving there for a while. ... Are you sure that the tape is ripe enough for a recovery ...
    (comp.databases.oracle.server)