Re: Fwd: please help

Jonathan Gennick wrote: > > Fellow list members, I received the following email from a > reader a few minutes ago. If you skip down to where he talks > about backup, you'll see that he's in trouble with a > database that won't recover. I've already suggested that he > open a TAR, and that he supp

RE: Fwd: please help

Man, I had to laugh with this one. And I really need it because I have been in the middle of a downtime. Got paged at 3:30am. I only went to bed at midnight so I am a little punchy right now -Original Message- Sent: Thursday, May 03, 2001 10:46 AM To: Multiple recipients of list OR

Re[2]: Re[2]:Fwd: please help

Jared, Amen to that. Wonder how many of them have even taken the wrapping off the book?? :-) Dick Goulet Reply Separator Author: Jared Still <[EMAIL PROTECTED]> Date: 5/3/2001 10:17 AM DIck, Totally agree. I just wanted to make sure that th

Re[2]: Fwd: please help

Dave, Good Man!! I've said for some time that the most difficult part of a recovery is figuring things out. What is broken & needs restoration and what have I got to do the task with? Once this is figured out it's child's play (almost) to make up a quick checklist & do the recovery. Regre

Re: Re[2]:Fwd: please help

DIck, Totally agree. I just wanted to make sure that the newbies out there understand the implications. Of course, they should read 'Oracle Backup & Recovery Handbook' cover to cover and do all the exercises. Jared On Thursday 03 May 2001 05:57, [EMAIL PROTECTED] wrote: > Jared, > > I a

Re: Fwd: please help

Jared, I think you hit the nail on the head when you said "Best practice of course is to make a backup of your database in it's current condition prior to restoring it." Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, user

Re[2]:Fwd: please help

Jared, I agree, The online redo logs should never be restored back onto a system that is otherwise running. But the intent is to make a hot backup that could be restored to a completely blank system, which I believe was being done here. In that case you need the online logs if for nothing e

RE: Fwd: please help

thank you ruth Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, May 03, 2001 8:31 AM To: Multipl

Re: Fwd: please help

Nechama, I do a level 0 or level 1 and then do archivelog current and then backup my archivelogs. I have been able to do point-in-time and ordinary recovery using this plan. This makes a complete set of backups. Further, we put them on tape each day and store a complete set for recovery. Regard

RE: Fwd: please help

would it be reasonable, then to alter system archive log current, and then back up all archived logs ... are there any pitfalls? ... thanks you Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com Direc

RE: Fwd: please help

mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ "David A. Barbour" To: Multiple recipients of list ORACLE-L ntrix.net>cc: Sent by: Subject: Re: Fwd: please he

Re: Fwd: please help

Looks like he missed one step or he forgot to mention it. He needs to switch all the logfiles and keep the archive logs along with hotbackup files to be used for recovery  . HTH. JyotiGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ

Re: Fwd: please help

ntrix.net>cc: Sent by: Subject: Re: Fwd: please help [EMAIL PROTECTED]

Re: Fwd: please help

Bill, Did you force a log switch before and after the hot backup? Did you backup your archive logs (or alternatively, are they available)? Sounds to me like you need to run ALTER DATABASE RECOVER UNTIL (CANCEL, TIME, CHANGE, USING BACKUP CONTROLFILE); If you didn't force the log switch,

Re: Fwd: please help

>From what I have read there are three problems that Bill has described.  As this seems urgent and it is still daytime the Pacific timezone, I can offer some limited advice.  In order of importance they would be ... 1. Recovery of the database. 2. Slow shutdown. 3. SQL statements hanging. 1. I st

Fwd: please help

Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error message

never mind -- Fwd: Please help !!! 805 client, 815 db again

I got it figured out! FYI, set ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data PS: I'm kinda rely on this list now. I really should spend some time to investigate before I post mail here. :-) Note: forwarded message attached. __ Do You Yahoo!?

never mind -- Fwd: Please help !!! 805 client, 815 db again

I got it figured out! FYI, set ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data PS: I'm kinda rely on this list now. I really should spend some time to investigate before I post mail here. :-) Note: forwarded message attached. __ Do You Yahoo!?