DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: alert.log !Warning message

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323

    alert.log !Warning message

    Hi

    I have following message in my alert.log. This is caused when i recover database until cancel using backup controlfile . The recovery was success. Database opened without any problem. Backup was COLD BACKUP.

    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.


    The above warning message was returned for all of my datafiles.

    Any ideas..

    Thanks in Advance.
    Nagesh

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    The fuzzy backup message means that the file is in an incomplete state.
    This happened because you issued a hot backup and the ALTER TABLESPACE %s END BACKUP command was executed before the copy command finished.

    If you are using HOT backup mode, use the ocopy.exe command on windows (it allows copy of open files).

    cheers.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width