Re: database revovery issue(my system is down)

Hi Howard,
Thanx for your help.

> You should have "decided" to restore the two datafiles that were reported as
> problematic, and recovered the *datafiles*, not the database. The database
> isn't at fault here, only two specific data files.

I have realized it.

> Let's see if I got this right. You are building a data warehouse RAC on a
> machine for which you have no reliable and functioning backup software and
> for which you have no backup medium capable of storing the stuff you
> actually care about -namely your data. Are you quite sure this is the
> direction you want to be going in??

Of course it is not. I am not the architect of this system . If i would , sure things would be better now. Although i am new with oracle , i know how to treat a database system . The company has already started the project and purchased the system when i started the job. Thats why i have 4 unknowns at my hands , itanium,linux,rac,emc. Legato has not released a version on itanium yet , the emc box has not enough disks for backups .

> I think so. You report corruption in SYSTEM and USER, and you state you have
> backups for system.dbf and user.dbf. Since you only need to restore those
> two files, then you should be able to do the resotre. Can you then do the
> recovery? So long as you have all the archived redo logs produced since the
> time of those files' backups, and the online redo logs, yes.
>

i will try this. I have already suggested this to the one who supposed to do the restore but could not insist since i am new with oracle.

> 'recover database using backup controlfile'
>
> Oh, why do people "experiment" with recovery commands.

No i did not experiment it.It was the command that oracle dbas run.
>
> Did you restore a binary version of the controlfile? No?? Then why in
> Heaven's name would you even think you need the 'using backup control file'
> command?
>

 i will ask this .

> And why are you restoring the undo tablespace? Did dbverify report that to
> be corrupt?? Not according to your post it didn't. So why are you restoring
> things that don't need restoring??
>

Yes , undo tablespace has also corrupted blocks.

> Your mistake is to blunder about, issuing inappropriate restore and recovery
> commands, and hoping you'll muddle through somehow.

> So many questions. Learn about backup and recovery, and the answers will be
> obvious to you. You've royally stuffed things up by throwing ad hoc recovery
> commands at a database that didn't need them. You should just have restored
> the two datafiles that dbv reported to be corrupt, and said 'recover
> datafile 'system.dbf', followed by 'recover datafile user.dbf', rollowed by
> 'alter database open'. End of story. Once you start restoring other things,
> and issuing recover commands that aren't needed, Lord knows what state your
> database is in, and since you don't have a complete database backup you
> can't reverse the process to find out.
>
> Bye-bye database.
>

I understand your point but believe me it is not my style to deal with a serious system like this. Although i am new with with oracle ,i have strong experience with database systems. I restored lots of database server systems only difference is they were not oracle, and i trained lots of people about data archive procedures , rules , check-lists ,etc. Suggested them same things that you suggested to me , and posted messages to people who played with their system like a toy in order to make them understand the value of their system. So , again i know your point.But my point is , i am new with this job , large database , missing procedures , and actions taken by whom are considered experienced with their job. i agree with you that i am asking so many questions , but i am not blindly playing with the gigabytes server .

 Anyway , thanks again for your comments.

Kind Regards,
hope

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3f9f7236$0$2239$afc38c87_at_news.optusnet.com.au>...
> "utkanbir" <hopehope_123_at_yahoo.com> wrote in message
> news:f6c90ebe.0310282028.8f8834c_at_posting.google.com...
> > Hi Gurus,
> >
> >
> > I am using oracle 9i rac on linux itanium , with emc disk + raid 5. We
> > are building a datawarehouse system .Today ,
> > we got error in one of the disks , unfortunately that disk contains
> > system.dbf.
> > Than the disk is replaced , when we try to start the database , we got
> > corrupted blocks . DB verify also reported corrupted blocks in
> > system.dbf and user.dbf. So we decided to recover database BUT:
>
> You should have "decided" to restore the two datafiles that were reported as
> problematic, and recovered the *datafiles*, not the database. The database
> isn't at fault here, only two specific data files.
>
> > our data backups does not contain all the tablespaces , it contains
> > system,undo,user ... but not our data tablespaces. (This is beacuse of
> > the itanium machine .Our data backup software has no version for
> > itanium , the only way to backup data is first store it in disk than
> > tape. We dont have enough disk space to store all the data archive.)
>
> Let's see if I got this right. You are building a data warehouse RAC on a
> machine for which you have no reliable and functioning backup software and
> for which you have no backup medium capable of storing the stuff you
> actually care about -namely your data. Are you quite sure this is the
> direction you want to be going in??
>
> > Is it possible to recover this database by using this backup?
>
> I think so. You report corruption in SYSTEM and USER, and you state you have
> backups for system.dbf and user.dbf. Since you only need to restore those
> two files, then you should be able to do the resotre. Can you then do the
> recovery? So long as you have all the archived redo logs produced since the
> time of those files' backups, and the online redo logs, yes.
>
> >If i
> > recover system,user,undo tablespace , will i use the other tablespaces
> > again? I know that other tablespaces have no corrupted blocks.
> >
> > 'recover database using backup controlfile'
>
> Oh, why do people "experiment" with recovery commands.
>
> Did you restore a binary version of the controlfile? No?? Then why in
> Heaven's name would you even think you need the 'using backup control file'
> command?
>
> And why are you restoring the undo tablespace? Did dbverify report that to
> be corrupt?? Not according to your post it didn't. So why are you restoring
> things that don't need restoring??
>
> >
> > We tried the command , it asks some redo log file numbers to recover ,
> > than we
> > resetted the redo logs. But we still get data block corruption
> > messages and database cant be opened.
> >
> > If i restore system.dbf , undo and user , can i use other tablespaces?
> > May be we made a great m&#305;stake of resetting logs.Instead of
> > resetting logs , we must recover system.dbf from backup ??
>
> Your mistake is to blunder about, issuing inappropriate restore and recovery
> commands, and hoping you'll muddle through somehow.
>
> Learn how to backup a single instance database, and to recover it, under a
> variety of circumstances, and then apply that knowledge (without any
> fundamental change) to a RAC database. But you need to learn what it is
> you're supposed to do *before* you try doing it.
>
> And if this is a serious production database, then get Management to
> resource backup and data storage issues before you go any further, because
> otherwise you'll just be wasting their (and your) time.
>
>
> >
> > **********
> > By the way , i can open database as read only , and get my data. But
> > some queries against dictionary gets corruption messsages , suc as
> > tab$, dba_tables,etc..
> > ***********************
> >
> >
> > So , within this current situation , if i do full restore and returns
> > the tablespaces that are inside archive but not the others , what will
> > be the status of other tablespaces? I mean if dbserver stores the
> > information about tablespaces inside system or control files , can
> > recovering them solve my problem since those tablespaces data are
> > valid? Or will the status of other tablespace be offline? Than may be
> > a patch can be applied?(if exists) Is there any number inside
> > tablspaces (may be in headers) which describes the redo log number
> > which is necessary for that tablespace? What is the relation between
> > redo log file numbers and tablespaces?
>
>
> So many questions. Learn about backup and recovery, and the answers will be
> obvious to you. You've royally stuffed things up by throwing ad hoc recovery
> commands at a database that didn't need them. You should just have restored
> the two datafiles that dbv reported to be corrupt, and said 'recover
> datafile 'system.dbf', followed by 'recover datafile user.dbf', rollowed by
> 'alter database open'. End of story. Once you start restoring other things,
> and issuing recover commands that aren't needed, Lord knows what state your
> database is in, and since you don't have a complete database backup you
> can't reverse the process to find out.
>
> Bye-bye database.
>
> Regards
> HJR
>
>
> >
> > Any help will be appreciated,
> > Kind Regards,
> > hope (although it remains less ...)
Received on Wed Oct 29 2003 - 06:02:49 CST