Re: Standby databases and adding datafiles

The datafile could have been backed up when the database was up without putting in hot backup mode. It is also possible that you have issued a shutdown abort before performing a cold backup.

  --> Do shutdown normal or immediate of the primary database and perform a cold backup of the datafile. Restore the file to the standby site.

  Cause: The fuzzy bit in the datafile header has been set.

HTHU Ankur Shah
Oracle DBA
DHR-GA Quoting daniel.hubler_at_aurora.org:

> This is Oracle v8174 on OpenVMS v732.
> We run a standby database in managed mode.
>
> In the past, when we were forced to add datafiles to the primary,
> we would get an ORA-01516 (nonexistent log file, datafile or tempfile
> 'xxxxxxx')
> on the standby, when that transaction hit. We would then do the
> ALTER DATABASE CREATE DATAFILE 'xxxxxxxx'
> AS
> 'yyyyyyyyyyyy'.
> We would then restart manged recovery on the standby.
>
> Recently we have started to get a different message on the standby when
> adding datafiles. It looks like this:
> ==============
> 8-APR-2005 14:45:14.27:
> WARNING! Recovering data file 1514 from a fuzzy file. If not the current
> file
> it might be an online backup taken without entering the begin backup
> command.
> Successfully added datafile 1514 to media recovery
> Datafile #1514: 'PRODD13:[V500.DB_PROD]D_PERSON_15.DBS'
> ===============
> At this point, managed recovery continues on the standby; archive log
> files continue to be processed.
>
> So we then end the managed recovery ("recover managed standby database
> cancel")
> and then alter the new datafile into the standby, just like before.
>
> We then restart recovery. Logs that have already been processed once, get
> processed again.
> I am assuming that the newly created datafile forces this.
>
> This scenario seems to be working. We invoked the standby just last
> weekend and it came up fine.
> We have rebuilt it since, copying from primary, and continue to get the
> "WARNING - fuzzy file" message.
>
> Can anyone explain why we would start getting a different message in this
> situation?
> Thanks.
>
> Dan Hubler
> Database Administrator
> Aurora Healthcare
> daniel.hubler_at_aurora.org
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l