Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


Share this Page URL
Help

Chapter 2: Planning for recovery > Table level recovery - Pg. 14

2.4 Table level recovery This section lists the assets that are involved in table recovery. 2.4.1 Table point-in-time recovery Table 2-5 lists the assets that are required for a table point-in-time recovery. Table 2-5 Table point-in-time recovery assets Recovery Asset Versioning Repository Comment You must run Versioning Repository after the object created or if there are any DDL changes on tables, including authorizations. Full offline database or table space backup. Take as frequently as your current recovery strategy dictates. This is the starting point for point-in-time Redo/Undo SQL. Versioning Repository is up-to-date when the backup is taken. Must be available if rolling forward beyond backup. Database or table space backup Database log records