Oracle's archive logs can be used to restore the database, but if the database to create a table, or on a table to add a new field, then the action will be written to the archive log? If the time period of archive logs to a reduction of database, database will have the new added field?

CodePudding user response:

Nobody reply ah, is a question too dishes?

CodePudding user response:

Records, the following three types of records:
DML
DDL
DCL

if the time period of archive logs to a database restore, the database will have the new added field?
Rman do recovery, meeting some,

CodePudding user response:

refer to the second floor selling fruit net reply:

will record, the following three types of records:
DML
DDL
DCL

if the time period of archive logs to a database restore, the database will have the new added field?
Rman do recovery, meeting some,

Thank you, I thought it would only record the DML

CodePudding user response:

In fact the essence of DDL and DML,

Int, for example, the create table t1 (id name varchar (10));

Will increase in the TAB $a table records, could add two columns in col $records, etc.,

CodePudding user response:

Thanks, educated, whether all the operation will be written to the archive log database?

CodePudding user response:

Recorded, and the content of the archive log can be viewed,