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


21 to 40 of 16045 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Concepts, 11g Release 1 (11.1)

Tablespaces, Datafiles, and Control Files

Control File ContentsA control file contains information about the associated database that is required for access by an … instance, both at startup and during normal operation. Control file information can be modified … only by Oracle Database; no database administrator or user can edit a control file.

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Concepts

SQL*Loader Control FileThe control file is a text file written in a language that SQL*Loader understands. The control file … data, and more. Although not precisely defined, a control file can be said to have three sections … marks are taken literally, including case. In control

Database Reference, 11g Release 1 (11.1)

Descriptions of Wait Events

control file single write# This identifies the control file to which the session is currently writing block# Block number in … the control file where the write begins. The block size is the as the physical block size of the port … This wait is signaled while the control file's shared information is written to disk. This is an

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Control File Reference

Control File ContentsThe SQL*Loader control file is a text file that contains data definition language (DDL … *Loader DDL. To create the SQL*Loader control file, use a text editor such as vi or xemacs. In general … , the control file has three main sections, in the following order: Session-wide

Database Reference, 11g Release 1 (11.1)

Descriptions of Wait Events

control file parallel writewhen: The session starts a control file transaction (to make sure that the control files are up to … date in case the session crashes before committing the control file transaction) The session commits a … transaction to a control file Changing a generic entry in the

Database Reference, 11g Release 1 (11.1)

Descriptions of Wait Events

control file sequential readReading from the control file. This happens in many cases. For example, while: Making a backup of … the control files Sharing information (between instances) from the control file Reading other blocks … read Parameter Description file# The control file

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing User-Managed Recovery: Advanced Scenarios

Copying a Multiplexed Control File to a Default LocationIf the disk and file system containing the lost control file are intact, then you can simply copy … one of the intact control files to the location of the missing control file. In this case, you do not … have to edit the CONTROL_FILES initialization parameter. To replace a damaged control

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Configuring the RMAN Environment: Advanced Topics

Viewing the Configured Location of the Snapshot Control Filecontrol file that has a nondefault filename: RMAN> SHOW SNAPSHOT CONTROLFILE NAME; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/oradata/trgt/snap_trgt.ctl';

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing User-Managed Recovery: Advanced Scenarios

Recovering Through an Added Datafile with a Backup Control FileIf database recovery with a backup control file rolls forward through a CREATE TABLESPACE or an … control file and perform media recovery through the CREATE TABLESPACE operation. You may see the … errors ORA-01244: unnamed datafile(s) added to control file by media recovery ORA-01110:

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Making User-Managed Database Backups

Making User-Managed Backups of the Control FileReference for more information about the DBA_DATA_FILES and DBA_TABLESPACES views Making User-Managed Backups of the Control File … * FROM V$BACKUP WHERE STATUS = 'ACTIVE'; FILE# STATUS CHANGE# TIME … no active datafiles: SQL> SELECT * FROM V$BACKUP WHERE STATUS = 'ACTIVE'; FILE# STATUS CHANGE# TIME

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing User-Managed Recovery: Advanced Scenarios

Recovering Through a RESETLOGS with a Created Control File, or created control file that knows about the prior incarnations You have all available archived … redo logs If you need to re-create the control file, then the trace file generated by ALTER DATABASE … incarnation history. The V$DATABASE_INCARNATION view displays the RESETLOGS history known to the control

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing User-Managed Recovery: Advanced Scenarios

Copying a Multiplexed Control File to a Nondefault LocationAssuming that the disk and file system containing the lost control file are not intact, then you … cannot copy one of the good control files to the location of the missing control file. In this case … control file. To restore a control

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Configuring the RMAN Environment: Advanced Topics

Setting the Location of the Snapshot Control Filesnapshot control file. Subsequent snapshot control files that RMAN creates use the specified filename … /snap_trgt.ctl'; You can also set the snapshot control file name to a raw device. To reset the … snapshot control file location to the default, run the CONFIGURE SNAPSHOT

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing User-Managed Recovery: Advanced Scenarios

Recovering with a Backup Control File in the Default LocationIf possible, restore the control file to its original location. In this way, you avoid having to … specify new control file locations in the initialization parameter file. To restore a backup control … Correct the hardware problem that caused the media failure. Restore the backup control

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing User-Managed Recovery: Advanced Scenarios

Recovering with a Backup Control File in a Nondefault LocationIf you cannot restore the control file to its original place because the media damage is too severe … , then you must specify new control file locations in the server parameter file. A valid control … , then the database prevents you from the mounting the database. To restore a control

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing User-Managed Recovery: Advanced Scenarios

Recovering Read-Only Tablespaces with a Backup Control Filethe backup control file indicates that a tablespace was read/write when the control file was backed … control files rather than backups to recover the database. If you need to use a backup control file, then … file: Take datafiles from read-only tablespaces

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Control File Reference

Comments in the Control FileComments can appear anywhere in the command section of the file, but they should not appear within

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Control File Reference

8 SQL*Loader Control File ReferenceThis chapter describes the SQL*Loader control file. The following topics are included: Control File … Contents Specifying Command-Line Parameters in the Control File Specifying Filenames and Object … Names Identifying XMLType Tables Specifying Datafiles Identifying Data in the Control

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Control File Reference

OPTIONS Clausein a SQL*Loader control file: OPTIONS (BINDSIZE=100000, SILENT=(ERRORS, FEEDBACK) ) Note: Parameter … values specified on the command line override parameter values specified in the control file OPTIONS clause. … = {TRUE | FALSE} ERRORS = n EXTERNAL_TABEL = {NOT_USED | GENERATE_ONLY | EXECUTE} FILE LOAD

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Control File Reference

Filenames That Conflict with SQL and SQL*Loader Reserved WordsSQL and SQL*Loader reserved words must be specified within double quotation marks. The only SQL*Loader reserved word is CONSTANT. You must use double quotation marks if the object name contains special characters other than those recognized by SQL ($, #, _), or if the name is case sensitive. See Also: Oracle Database SQL Language Reference