You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for control file


1 to 20 of 20744 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Using Views to Display Information

Viewing Oracle ASM File Access Control InformationYou 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-5 Viewing Oracle ASM … File Access Control information with V$ASM_USER SQL> SELECT dg.name AS diskgroup,

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Control Files

Recovering from Control File Corruption Using a Control File Copycorrupted, that 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 system command to overwrite the … bad control file with a good copy: % cp /u03/oracle/prod/control03.ctl /u02/oracle/prod/control02.ctl

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Control Files

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

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Maintaining RMAN Backups and Repository Records

Protecting the Control Fileyou 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

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Maintaining RMAN Backups and Repository Records

About Control File RecordsThe 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.

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Command-Line Reference

CONTROL (control file)Default: none CONTROL specifies the name of the SQL*Loader control file that describes how to load … name is omitted, then SQL*Loader prompts you for it. If the name of your SQL*Loader control file … operating system-specific documentation for more information. See Also: Chapter 9 for a detailed description

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Performing User-Managed Recovery: Advanced Scenarios

Re-Creating a Control Fileremain 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 30-2 for generating the … If all control files have been lost in a permanent media failure, but all online redo log members

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Maintaining RMAN Backups and Repository Records

Maintaining the Control File Repository, however, then the control file of each target database is the exclusive repository for RMAN metadata … . You should know how information is stored in the control file and ensure that your backup and … recovery strategy protects the control file. See Also: Oracle Database Administrator's

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

RMAN Backup Concepts

Control File and Server Parameter File AutobackupsHaving recent backups of your control file and server parameter file is extremely valuable in many … current control file explicitly requested as part of your BACKUP command. With a control file … autobackup, RMAN can recover the database even if the current control

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Control Files

Recovering a Control File Using a Current CopyThis section presents ways that you can recover your control file from a current backup or from a multiplexed copy.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Control Files

Recovering from Permanent Media Failure Using a Control File Copyinaccessible due to a permanent media failure and that you have a multiplexed copy of the control filecontrol file to a new, accessible location: % cp /u01/oracle/prod/control01.ctl /u04/oracle/prod … CONTROL_FILES initialization parameter. Remove the bad control file from CONTROL_FILES

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Maintaining RMAN Backups and Repository Records

Preventing the Loss of Control File RecordsThe best way to prevent the loss of RMAN metadata because of overwritten control file records is to … backup records. Store the control file in a file system rather than on a raw device so that it can … expand. Monitor the alert log to ensure that Oracle Database is not overwriting control

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Performing RMAN Recovery: Advanced Scenarios

Performing Recovery with a Backup Control FileThis section explains what to do when all current control files are lost and you must restore a backup control file.

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

RMAN Backup Concepts

When RMAN Performs Control File AutobackupsIf CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and … command. If the database runs in ARCHIVELOG level, RMAN makes control file autobackups when a … structural change to the database affects the contents of the control file. Note: Beginning

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

RMAN Backup Concepts

How RMAN Performs Control File AutobackupsRMAN 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

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Performing RMAN Recovery: Advanced Scenarios

About Recovery with a Backup Control FileIf 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

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Configuring the RMAN Environment: Advanced Topics

Configuring the Snapshot Control File Locationfile, 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 default … location for the snapshot control file

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Making User-Managed Database Backups

Backing Up the Control File to a Trace FileYou can back up the control file to a text file that contains a CREATE CONTROLFILE statement. You … can edit the trace file to create a script that creates a new control file based on the control file … NORESETLOGS option in the SQL statement, then the

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Configuring the RMAN Environment

Configuring Control File and Server Parameter File AutobackupsAs explained in \"Control File and Server Parameter File Autobackups\", you can configure RMAN to … automatically back up the control file and server parameter file. The autobackup occurs whenever a … whenever the database structure metadata in the control file

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Making User-Managed Database Backups

Backing Up the Control File to a Binary FileThe 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