ORA-01578 after clone db on target server using RMAN backup
Hi All,
I have cloned the large(2TB) database(10.2.0.4) from one server to another server using RMAN Backup.
I did take full backup of database and archive logs and shipped the backup to target server and performed restore/recovery of the database.
I could not do the DUPLICATE command as the DB is very huge and network will become very slow.
After successful cloning, when i run DBMS_STATS, i am seeing following block corruption error.
BEGIN dbms_stats.gather_schema_stats(ownname => 'ADMIN',degree => 4, cascade => true); END;
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 4, block # 1965977)
ORA-01110: data file 4: '/edw_uat01/oradata/edwuat/DATAWAREHOUSE02.dbf'
0