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

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

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

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

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

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

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

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

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: 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: 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