如果事务回滚已发现坏块位于对象上,而非 rollback 段本身,则 undo 操作可能已被放弃。在这种情况下,可能需要在恢复完成后重建索引/检查数据完整性。 如果要恢复的文件包含自上次备份以来执行的 NOLOGGING 操作的数据,在使用了数据文件或数据库恢复的情况下,这些块将被标记为“坏块”。在某些情况下,这会使情况更加糟...
# - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it ...
Which two statements are true about unexpired undo? A. It is required when a transaction issues a ROLLBACK statement. B. It is the first type of UNDO overwritten when trying to avoid out-of-space errors. C. It may be used to support flashback queries. D. It is retained if possible...
Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFF...
Which two statements are true about unexpired undo? A. It is required when a transaction issues a ROLLBACK statement. B. It is the first type of UNDO overwritten when trying to avoid out-of-space errors. C. It may be used to support flashback queries. D. It is retained if possible...