Understand the recovery process for a database running in noarchive mode and recover a failed database. Understand the complete recovery process for a database in archivelog mode and perform complete recovery in various situations. Understand the incomplete recovery process for a database in archive mode and perform incomplete recovery in various situations. Identify the uses, modes, levels and compatibility issues of Export utility, and use the Export utility to create an export file. Identify the uses, modes and NLS considerations of the Import utility, and the steps in which a table is imported.
Import objects into a schema.
Sequence steps to start an Oracle database with a missing data file. Identify the methods to enable parallel recovery, recover from lost control file, Recovery Catalog, data file corruptions. Identify the features and usage guidelines of standby database. Manage standby database and identify the characteristics of the offline data files in a standby database. Identify the causes of statement failure.