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: Database recovery from user error

Re: Database recovery from user error

From: rs <info_at_bytelife.com>
Date: Fri, 7 Jun 2002 11:56:55 +0200
Message-ID: <adq0a0$hio$1@newswriterENV1.svr.pol.co.uk>


Hello Rudy,

Isn't the servermanager asking for .ARCH files to be applied? I don't seen anything in your posting about this. If "recover database until time" won't do it then try "recover database until cancel".
Good luck,

     Roelof Schierbeek

R.Schierbeek, DBA
sql : www.bytelife.com/sql4dba.htm

<rsusanto_at_atlas-sp.com> schreef in berichtnieuws adpqj2$hnn$1_at_news.netmar.com...
> Hi all,
>
> I'm trying to perform recovering the tables after deleting them. Before i
> deleting them, i perform hot backup, after deleting them i try to recover
but
> failed. Sometime i can do it successfully and sometime is not, i don't
know
> the actually what is going on.

......<snip>

> This is my script to recover the database:
> shutdown immediate
> host copy y:\data\v817-rs\hotbackup-1\APPDATA01.DBF G:\DATA\V817\DISK1\
> host copy y:\data\v817-rs\hotbackup-1\APPDATA02.DBF G:\DATA\V817\DISK2\
> host copy y:\data\v817-rs\hotbackup-1\INDX01.DBF D:\ORACLE\ORADATA\V817\
> host copy y:\data\v817-rs\hotbackup-1\RBS01.DBF D:\ORACLE\ORADATA\V817\
> host copy y:\data\v817-rs\hotbackup-1\SYSTEM01.DBF D:\ORACLE\ORADATA\V817\
> host copy y:\data\v817-rs\hotbackup-1\TEMP01.DBF D:\ORACLE\ORADATA\V817\
> host copy y:\data\v817-rs\hotbackup-1\TOOLS01.DBF D:\ORACLE\ORADATA\V817\
> host copy y:\data\v817-rs\hotbackup-1\USERS01.DBF D:\ORACLE\ORADATA\V817\
> startup mount
> recover database until time '07-jun-2002 09:30:00'
> alter database open resetlogs;
> exit
>
> i got error message when i tried to run 'recover database until time' and
the
> error message is
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> below
> ORA-01195: online backup of file 1 needs more recovery to be consistent
> ORA-01110: data file 1: 'D:\ORACLE\ORADATA\V817\SYSTEM01.DBF'
>
> Although i try to recover all of the datafiles that got error message when
i
> try to perform 'ALTER DATABASE OPEN RESETLOGS' like
> RECOVER DATAFILE 'D:\ORACLE\ORADATA\V817\SYSTEM01.DBF',
> RECOVER DATAFILE 'D:\ORACLE\ORADATA\V817\TOOLS01.DBF', and so on.
> But I still can't get the tables back.
>
> Please help me.
>
> Thanks in advance,
> Rudy Susanto
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net Received on Fri Jun 07 2002 - 04:56:55 CDT

Original text of this message

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