Wednesday, October 19, 2011

Hot backup if tablespace is in nologging mode???

We can surely put the NOLOGGING tablespace is BACKUP mode and make a operating system copy of the file in question.

However, if there are any NOLOGGING changes made to the tablespace after the backup was taken and if recovery is issued beyond this time, media recovery will soft-corrupt all blocks that are
affected by the NOLOGGING changes.

No comments:

Post a Comment