How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Control File Structure → Information about the database is stored in different sections of the control file. Each section is … a set of records about an aspect of the database. For example, one section in the control file … multiple logical control file blocks. Records can span blocks within a section. The control
Viewing Oracle ASM File Access Control Information → You can view information about Oracle ASM File Access Control in the columns of the V$ASM_USER, V … Oracle ASM File Access Control users displayed in the V$ASM_USER view. Example 6-6 shows information … about Oracle ASM File Access Control user groups displayed in the V$ASM_USERGROUP
About Control File Records → The control file contains two types of records: circular reuse records and noncircular reuse … available record slots are full, the database either expands the control file to make room for a new … make backups of a target database, the database records these backups in the control file.
Protecting the Control File → you protect each target database control file. You can use the following strategy to protect the … control file. To protect the control file: Create redundant copies of control files through multiplexing … control files without requiring you to restore
10.1 What Is a Control File? → Every Oracle Database has a control file, which is a small binary file that records the physical … structure of the database. The control file includes: The database name Names and locations of … number Checkpoint information The control file must be available for writing
10.6.1 Recovering from Control File Corruption Using a Control File Copy → If a control file becomes corrupted, then you can recover it using a control file copy. This method … the control file directory is still accessible, and that you have a multiplexed copy of the control … file. With the instance shut down, use an operating
Re-Creating a Control File → remain intact, then you can recover the database after creating a new control file. You are not … and currency of a control file backup, you have the options listed in Table 31-2 for generating the … the Control File If you... Then... Executed ALTER DATABASE BACKUP CONTROLFILE TO TRACE
Maintaining the Control File Repository → control file of each target database on which it performs operations. If you register a target database … Reference for descriptions of the RMAN maintenance commands Maintaining the Control File Repository RMAN is … , then the control file of each target database is the exclusive repository
10.2.1 Provide File Names for the Control Files → You specify control file names using the CONTROL_FILES initialization parameter in the database … Files, then the database creates a control file and uses a default file name. The default name is … initialization parameter file. The instance recognizes and opens all the listed file
10.6 Recovering a Control File Using a Current Copy → You can recover your control file from a current backup or from a multiplexed copy.
Preventing the Loss of Control File Records → About Fast Recovery Area and Control File Records When a control file record containing information … database expands the size of the control file section containing the record for this file. The database … control file record type:
When RMAN Performs Control File Autobackups → control file and the current server parameter file (if used to start the database) after a successful … BACKUP command. For CDB s, by default, the control file autobackup is turned on. If the database runs … in ARCHIVELOG level, RMAN makes control file autobackups when
How RMAN Performs Control File Autobackups → RMAN backs it up in the same backup set as the control file autobackup. After the autobackup completes … to the alert log located in the Automatic Diagnostic Repository (ADR). Note: Control file … autobackups are never duplexed. The control file autobackup file name
About Recovery with a Backup Control File → If all copies of the current control file are lost or damaged, then you must restore and mount a … backup control file. You must then run the RECOVER command, even if no data files have been restored … , and open the database with the RESETLOGS option. If some copies of the current control file
Configuring the Snapshot Control File Location → When RMAN needs a read-consistent version of the control file, it creates a temporary snapshot … control file. RMAN needs a snapshot control file when resynchronizing with the recovery catalog or when … making a backup of the current control file. The
Performing Recovery with a Backup Control File → backup control file. This section contains the following topics: About Recovery with a Backup Control … File Performing Recovery with a Backup Control File and No Recovery Catalog … This section explains what to do when all current control files are lost and you must
control file → A binary file that records the physical structure of a database and contains the names and
Backing Up the Control File to a Binary File → The primary method for backing up the control file is to use a SQL statement to generate a binary … sets and copies (if you use RMAN). If COMPATIBLE is 10.2 or higher, binary control file backups … include temp file entries. To back up the control file after a structural
Configuring Control File and Server Parameter File Autobackups → Database Backup and Recovery Reference for CONFIGURE syntax Configuring Control File and Server Parameter … File Autobackups As explained in \" About RMAN Control File and Server Parameter File Autobackups … \", you can configure RMAN to automatically back up the control
Restoring the Server Parameter File from a Control File Autobackup → If you have configured control file autobackups, then the server parameter file is backed up with … the control file whenever an autobackup is taken. To restore the server parameter file from the … control file autobackup, you must first set the DBID