Re: RECOVER DATABASE question again.

Obviously the Backup is invalid. It looks from U'r description that you seem to know that the Tablespaces have to be in Backup mode when copying the Datafiles and yet you didnt do it !!! It is perfectly logical that ORacle called it as a Fuzzy Backup !!

Why dont U try the Proper Way( include Begin & End Backup modes) and then Copy the Datafiles,Archived Redo log files to the 2nd node. Also do a
svrmgr>Alter database backup controlfile to trace; on the 1st Database
and copy this file over to the 2nd Host,Edit it to reflect the new file locations and

Recreate the Database using
>Startup nomount;
>Create Controlfile set database "DB_2 " RESETLOGS ....;
will create New Controlfile,Redolog files and the Database using the Copied Datafiles.
>Recover database using backup controlfile until Cancel;
will recover the Database by applying the Archived redolog files;

>Alter database open resetlogs;

This procedure works fine ..

-Thiru

Alexander Chupin 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.
Received on Mon Jul 12 1999 - 15:36:54 CDT