Re: After I remove the online fuzzy tag of the datafile, can it be safe on standby?

"AnySQL (d.c.b.a)" <anysql_at_gmail.com> wrote in news:1120571223.677164.278840_at_g49g2000cwa.googlegroups.com:

> I am not using my tool to recovery standby, just copy datafile without
> put tablespace in hot backup mode or rman when building standby, I read
> the data file header first absolutely, and then read the others block,
> as a matter of fact, I did a simple test on my small database installed
> on my notebook with my tool, It works.
>
> One thing not sure is that how oracle determine the start SCN of
> recovery for a datafile? Accord SCN in the data file headers or others
> SCN in the data file header?
>
> Thanks.
>
> http://www.anysql.net
>

I'm not sure I see what the benefit of suh a tool would be, even if it worked (which I don't think it would). It sounds like you're trying to save a very small amount of processing time at the risk of corrupting your data. It also sounds like a database Darwin Award in the making if you ask me.

Either use rman, or begin/end backup and copy/ftp your files. It's platform independent, safe, and reliable. Received on Tue Jul 05 2005 - 08:35:14 CDT