Re: User-managed incomplete recovery in noarchivelog mode

On Mon, 30 Jun 2008 04:02:31 -0700 (PDT), Helma
<helma.vinke@xxxxxxxxxxx> wrote:


Your only choice is to restore the backup of June 28, pray and forget
about anything that happened after June 28.
If that doesn't work, your database is toast, thanks to the decision
of someone to run in NOARCHIVELOG.


" The tables in USERS tablespace is NOT important, is there any way
for
me to open the database? "

Sybrand,

Can't he use the 29th backup, and drop the USER tablespace ? In that
case, the db should open , i guess. Is that true?

H.

Helma, he could try if he
- restored the db from 29 (including controlfiles)
- MOUNTED the database
- OFFLINED the datafile for the users tablespace
- open the database and drop the users tablespace.

Note: ALL files are from 1 backup!

--
Sybrand Bakker
Senior Oracle DBA
.

Relevant Pages

  • Re: User-managed incomplete recovery in noarchivelog mode
    ... If that doesn't work, your database is toast, thanks to the decision ... of someone to run in NOARCHIVELOG. ... " The tables in USERS tablespace is NOT important, ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Re: User-managed incomplete recovery in noarchivelog mode
    ... I have two full sets of close database files backup. ... Since the database is running in noarchivelog mode and the online redo ... Your only choice is to restore the backup of June 28, ...
    (comp.databases.oracle.server)
  • Scheduling RMAN backups with NOARCHIVELOG
    ... If I schedule a backup through Enterprise Manager for a database with ... NOARCHIVELOG, ... shutdown or will the backup simply fail? ...
    (comp.databases.oracle.server)
  • Re: User-managed incomplete recovery in noarchivelog mode
    ... If that doesn't work, your database is toast, thanks to the decision ... of someone to run in NOARCHIVELOG. ... " The tables in USERS tablespace is NOT important, ... Can't he use the 29th backup, ...
    (comp.databases.oracle.server)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)