Monday, October 22, 2007

Data Guard 10g - drop file

Jomon is doing some research on Dataguard ... Great !. He came with a question. He did drop a newly added datafile (10gr2 new feature allows this) from primary and was expecting the same to go from standby (he was sure about this because of Standby_file_management was auto). But that did not happen and when he added another datafile to primary with same name as that of dropped one everything went for a toss (in standby). I was sure if this the case it would be bug. In few mints he idenitified the bug . wow....

Alter ... drop datafile - on primary ---

No comments: