Re: RECOVER DATABASE question again.

Hi,

  You will not be able to recover using a backup taken while the database was active without putting the tablespace in backup mode. Though not supported, if there was no activity on the production database while you were taking the backup, you should be able to recover. ( I wouldn't bet on it. ) I would suggest taking a proper backup and then try to recover using that.

Regards,
Denny

In article <378a510e.0_at_ns.mosbb.com>,
  "Alexander Chupin" <chupin_at_mail.mosbb.com> wrote:
> Good day,
>
> We have database in archivelog mode.
> Every weekend, when nobody work, our
> operators copy database, redolog and
> control fies to another server using
> xcopy.exe command, without shutdown
> server or other preparation for this
> action (as alter tablespace xxx begin
> backup,etc.).
> Because it strategy of backup was
> developed not by me, I'm interested
> how I can to recover this instance
> on the second server?
> Now I tried the following.
>
> startup mount exclusive;
> alter database recover database until cancel using backup controlfile;
>
> I received in trace file:
>
> ---------- begin of trace file --------------
> Mon Jul 12 11:54:41 1999 -
> alter database recover database until cancel using backup
controlfile
> Mon Jul 12 11:54:41 1999 - Media Recovery Start
> WARNING! Recovering data file 1 from a fuzzy file. If not the
current
> file
> it might be an online backup taken without entering the begin backup
> command.
> WARNING! Recovering data file 2 from a fuzzy file. If not the
current
> file
> it might be an online backup taken without entering the begin backup
> command.
> WARNING! Recovering data file 3 from a fuzzy file. If not the
current
> file
> [...]
> WARNING! Recovering data file 36 from a fuzzy file. If not the
> current file
> it might be an online backup taken without entering the begin backup
> command.
> Media Recovery Log
> ORA-279 signalled during: alter database recover database until
> cancel using...
> Mon Jul 12 12:31:06 1999 -
> alter database recover database until cancel using backup
controlfile
> Mon Jul 12 12:31:06 1999 -
> Media Recovery Start
> ORA-275 signalled during: alter database recover database until
> cancel using...
> Mon Jul 12 12:32:10 1999 -
> alter database recover cancel
> Mon Jul 12 12:32:10 1999 -
> Incomplete recovery done UNTIL CHANGE 1099617362232
> Media Recovery Cancelled
> Completed: alter database recover cancel
> ---------- end of trace file --------------
>
> Production database now is operating Ok, while.
> Can anybody tell me, what I must to do to recover
> second database using archivelog file from
> production database.
> Is it available? Or I must send all files from second
> server to nul.
>
> Thank you in advance.
> WBR, Alexander.

--
Denny Koovakattu
denny_at_vitalsol.com
http://vitalsol.com/

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 12 1999 - 16:28:39 CDT