2

In Oracle 12.1, if the DBAs restored a single table from backup, would there be evidence anywhere in the data dictionary? If so, what would it be?

1 Answer 1

2

Depends on how the DBA restored it; if flashback is enabled for the database, there could be evidence that it was restored using the

flashback table scott.mytab to before drop;

command. Here are stats on a personal table, before dropping, then after restoring it via the above command; I imagine other recovery techniques might also fill in the same data:

SYS@dev01> select CREATED, LAST_DDL_TIME, TIMESTAMP from dba_objects where object_name='MYTAB';

CREATED             LAST_DDL_TIME       TIMESTAMP
------------------- ------------------- -------------------
2018-07-09 19:18:29 2018-07-09 19:18:29 2018-07-09:19:18:29

SYS@dev01> drop table "MARK.STEWART".mytab;

Table dropped.

AtlasDev:SYS@dev01> flashback table "MARK.STEWART".mytab to before drop;

Flashback complete.

SYS@dev01> select CREATED, LAST_DDL_TIME, TIMESTAMP from dba_objects where object_name='MYTAB';

CREATED             LAST_DDL_TIME       TIMESTAMP
------------------- ------------------- -------------------
2018-07-09 19:18:29 2018-12-15 03:09:31 2018-12-15:03:09:31

SYS@dev01>

Now the DBA could have defined triggers to monitor table creation and deletion, and auditing could capture such activity if enabled.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.