Block corruption on physical Standby database
edited May 28, 2009 12:03AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
The following error has occurred:
ORA-01578: ORACLE data block corrupted (file # 3, block # 3236947)
ORA-01110: data file 3: '/bkp/oradata/orcl_raw_dat
ORA-26040: Data block was loaded using the NOLOGGING option
when i checked out the oracle metalink i found that we have to copy the datafile from primary to standby....but my question is i take a hot backup of datafile from primary and paste it to the standby when i mopunt the standby ,oracle server matches the SCN of all the files and it will found that the SCN is differ what it had at the time of shutdown of the stanbdby db ,so will be able to open the db or not....
ORA-01578: ORACLE data block corrupted (file # 3, block # 3236947)
ORA-01110: data file 3: '/bkp/oradata/orcl_raw_dat
ORA-26040: Data block was loaded using the NOLOGGING option
when i checked out the oracle metalink i found that we have to copy the datafile from primary to standby....but my question is i take a hot backup of datafile from primary and paste it to the standby when i mopunt the standby ,oracle server matches the SCN of all the files and it will found that the SCN is differ what it had at the time of shutdown of the stanbdby db ,so will be able to open the db or not....
0