Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?

From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Wed, 6 Jul 2011 10:04:02 -0700 (PDT)
Message-ID: <1309971842.12207.YahooMailRC_at_web65903.mail.ac4.yahoo.com>

Here are the reasons I think why object level checkpoint is needed for Truncate or Drop operation:

Datafiles on primary and standby need to be same bit by bit and block by block. This is fundamentally required for Oracle physical standby and physical backups. This will be broken if object level checkpoint wasn't done.
Database level flashback can logically corrupt the data, when flashback database command is used, if thread level checkpoint wasn't done as part of Truncate or Drop operation.

Marking buffers as invalid for writes is only done in Active DataGuard environment on physical standby databases in some situations.

Hope it helps.

Thanks,
Sai
http://sai-oracle.blogspot.com

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

Received on Wed Jul 06 2011 - 12:04:02 CDT

This message: [ Message body ]
Next message: mek s: "add s resource to crs"
Previous message: Subodh Deshpande: "Re: anyone ran into ORA-00752 on dataguard node with ASM/11.1.0.7 Linux?"
Maybe in reply to: Paresh Yadav: "What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?"
Next in thread: Jonathan Lewis: "Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?"
Reply: Jonathan Lewis: "Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message