Oracle Database 19c 1z0-083 Oracle Study Notes

The unified audit trail is written to a read-only table.

The unified audit trail is written to a read-only external file.

Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

Audit records are created for SYS.

Audit records are created for non-sys users.

Online Redo Log backups can be created while connected to CDB$ROOT

Control file backups can be created while connected to CDB$ROOT.

The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.

Archived Redo Log backups can be created while connected to PDB

Control file backups can not be created while connected to a PDB

The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

The database must be in MOUNT state when performing Database Point-in-Time Recovery.

Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

The Database must be in ARCHIVE LOG mode.

The target point for the recovery must be specified as a stime or System Change Number (SCN).

The database must be open RESETLOGS after Database Point-in-Time Recovery.

Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.

Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.

Pre-existing backups of the database to be duplicated are always used if they exist.

Image copies can be used to duplicate the active database.

The active database must be duplicated while in OPEN state.

No connection to the recovery catalog is required for active database duplication.

Backup sets can be used to duplicate the active database.