Enabling Automatic Shared Memory Management This section describes how to change to automatic shared memory management if either automatic memory management or manual shared memory management is ...
Enabling Flashback Database To revert the entire database to a prior point in time, you can either revert the entire database to a prior point in time by restoring a backup and doing point-in-time recovery, or you can enable Flashback Database. When you enable Flashback Database, the database ge...
Enabling Row Movement on a Table Before you can use Flashback Table, you must ensure that row movement is enabled on the table to be flashed back, or returned to a previous state. Row movement indicates that rowids will change after the flashback occurs. This restriction exists because if rowids...
Encrypted Tablespaces Encrypted tablespaces primarily protect your data from unauthorized access by means other than through the database. For example, when encrypted tablespaces are written to backup media for travel from one Oracle database to another or for travel to an off-site facility for ...
From an existing database (structure as well as data) You can create a new template that has both the structural information and physical data files of an existing database. Databases created using such a template are identical to the source database. User-defined schemas and their data will be ...
Full Backups and Incremental Backups A full backup of a data file includes all used blocks of the data file. A full backup can be either an image copy or backup set. An incremental backup copies only those blocks in a data file that change between backups. A level 0 incremental backup, which cop...
Getting Started with Database Administration This chapter provides a brief roadmap for administering your database. It introduces you to Oracle Enterprise Manager Database Express (EM Express), the Web-based interface for managing an Oracle database. This chapter contains the following sections:...
Granting Access to EM Express for Nonadministrative Users As a database administrator, you can log in to EM Express with the SYS or SYSTEM user account to perform administrative and other tasks. Nonadministrative users may also want to log in to EM Express. For example, application developers may...
How to Use This Guide with Related Material This guide is part of a comprehensive set of learning material for administering Oracle Database, which includes a 2 Day DBA Oracle By Example (OBE) series, available on the Web. Every chapter in
Image Copies and Backup Sets Database backups created by RMAN are stored as image copies or backup sets. Image copies are exact byte-for-byte copies of files. You can create an image copy by copying a file at the operating system level. Unlike copying files at the operating system level, however...
