dbTalk Databases Forums  

fuzzy files on standby when applying incremental backups

comp.databases.oracle.server comp.databases.oracle.server


Discuss fuzzy files on standby when applying incremental backups in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
HansP
 
Posts: n/a

Default fuzzy files on standby when applying incremental backups - 09-13-2011 , 06:37 AM






Db version 11.1.0.7.0 EE
OS : Linux

I am playing around with standby and doing the scenario decribed in
section 11.10 of the Oracle Data Guard Concepts and Administration
manual.
The first time I play the scenario everything is fine.
But the second time something goes wrong.

The scenario (see section 11.10 of the manual for the exact steps).
1. duplicate data for standby
2. configure broker
3. ctas with nologging
4. determine nologging scn on standby
5. BACKUP INCREMENTAL FROM SCN <scn> DATABASE of primary
6. transfer backup to standby
7. catalog backup on standby
8. recover database noredo
9. open the database read only

If you do steps 3 to 9 for a 2nd time you will see the database
complaining about fuzzy files.
WARNING! Recovering data file 1 from a fuzzy file. If not the current
file
it might be an online backup taken without entering the begin backup
command.

Looks like a bug, doesn't it?

regards HansP

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.