While preparing comprehensive data recovery plans for various possible scenarios involving database crashes, the database administrator should take into account the use of any operations that are not logged. For example, if a table is created with the create table as select statement with logging of journal information switched off, recovery of the tablespace with that table will need to take this into account. If the recovery is from a backup taken before the table was created, there will be no roll-forward information to create and repopulate the table. The operation that created the table will need to be rerun. If, on the other hand, the backup was taken after the table was created, then the table will exist and, more importantly, any changes made after the original create statement can be rolled forward using journal files.
Coming up with a Data Recovery Plan
August 22nd, 2008 8:55 pm
