i have restored full back up database using RMAN sucessfully from one server to another .Restoration process do not contain any error.
New Database contain job when it executes then it leaves mesaage in alert log.
"ORA-01578 oracle data block corrupted file # 6 block # 6888812"
"ORA-26040 data block was loaded using nologging option".
please let me know how it could recovered and prevented.
In short, your full backup has happened when a NOLOGGING transaction was on flight. Hence the recovery process should get the transaction's data out of archive logs. BUT the data doesn't exist in archivelog beause the transaction was NOLOGGING. For comprehensive detail read the documents above.
To prevent this situation, backup the database when no NOLOGGING transaction is running.
I have this Blog Posting that explains the NOLOGGING effects and how to address them:
You may find it useful :-)
"Don't believe it, test it!"