![]() ![]() If you are re-creating your control file and you are using Recovery Manager for tablespace recovery, and if you specify a different character set from the one stored in the data dictionary, then tablespace recovery will not succeed. Oracle Database prints the current database character set to the alert log in $ORACLE_HOME/log during startup. This clause is required only if you are using a character set other than the default, which depends on your operating system. If media recovery of the database is subsequently required, then this information will be available before the database is open, so that tablespace names can be correctly interpreted during recovery. ![]() If you specify a character set, then Oracle Database reconstructs character set information in the control file. Oracle recommends that you then shut down the instance and take a full backup of all files in the database. If that parameter is not set, then the default value is FALSE, and the database is mounted in EXCLUSIVE mode. After successfully creating the control file, Oracle Database mounts the database in the mode specified by the initialization parameter CLUSTER_DATABASE. If you omit any clauses, then Oracle Database uses the default values rather than the values for the previous control file. This control file is not an Oracle Managed File. If no values are set for any of these parameters, then the database creates a control file in the default location for the operating system on which the database is running. ![]() If a value is specified only for DB_RECOVERY_FILE_DEST, then the database creates one control file in that location. If a value is specified only for DB_CREATE_FILE_DEST, then the database creates one control file in that location. The location specified in DB_CREATE_FILE_DEST is the primary control file. If no value is specified for DB_CREATE_ONLINE_LOG_DEST_ n, but values are set for both the DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST, then the database creates one control file in each location. When DB_CREATE_ONLINE_LOG_DEST_ n is specified, the database does not create a control file in DB_CREATE_FILE_DEST or in DB_RECOVERY_FILE_DEST (the fast recovery area). The file in the first directory is the primary control file. One or more control files as specified in the DB_CREATE_ONLINE_LOG_DEST_ n initialization parameter. If that parameter does not have a value, then the database creates an Oracle-managed control file in the default control file destination, which is one of the following (in order of precedence): The control file resides in the location specified in the CONTROL_FILES initialization parameter. When you issue a CREATE CONTROLFILE statement, Oracle Database creates a new control file based on the information you specify in the statement. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |