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

Comments embedded.
AnySQL (d.c.b.a) wrote:
> I am not using my tool to recovery standby, just copy datafile without
> put tablespace in hot backup mode or rman when building standby,

You're BUILDING a standby database by editing the datafile header using a 'tool' (and I use the term LOOSELY) which Oracle has neither written nor approved. This is a guarantee of a lawsuit from Oracle if I ever saw one.

> 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.

It works until you have a crash and can't recover due to your file header manipulation.

>
> 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?
>

Again, I state you have only proven yourself less than qualified to touch an Oracle database, much less write 'faulty' tools to perform unspeakable acts against the datafiles. Taking shortcuts inevitably leads to frustration by circumventing known, reliable, standard procedures to perform the same act. Hot backups can be used to create standby databases; your 'home-brewed' method of subverting that procedure is a sure route to failure, as your incomplete changes will result in a lost datafile, or a lost database due to file header corruption creating an inability to recover the files. This equals lost data, lost time, lost revenue and excessive expense for any potential customer who may feel brave enough to use your 'product', along with lawsuits against you by the customer, and by Oracle Corporation for attempted reverse-engineering of the Oracle software.

> Thanks.
>

You're welcome. Now stop this nonsense and use the tools Oracle provides.

> http://www.anysql.net

I've visited your website, even though I don't read Chinese. The fact you claim yourself as an Oracle Certified Professional is disturbing, to say the least, as one would expect an OCP to respect the software from Oracle corporation, not try to pull an 'end run' around it to cut corners.

David Fitzjarrell Received on Tue Jul 05 2005 - 10:16:11 CDT