Create a new control file for the database

Creating New Control Files This section discusses when and how to create new control files. When to Create New Control Files It is necessary for you to create new control files in the following situations: All control files for the database have been permanently damaged and you do not have a control file backup. You want to change the database name.

See Oracle Database Utilities for information about using this utility. Make a list of all datafiles and redo log files of the database. Shut down the database. Back up all datafiles and redo log files of the database. See Also: Oracle Database Backup and Recovery User's Guide for information about recovering your database and methods of recovering a lost control file. All rights reserved. Book List. Master Index. Use the above edit control file command for create new control file.

If you have trace file of control then you found following statement configure RMAN setting. Note: Skip this step if donot have control file trace. Recover database is required if database is not shut-down normal. Open the database normally or resetlog depend upon the Redo log file you lost or have it.

Create temp file as needed. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. You want to change the maximum number of redo log file groups, redo log file members, archived redo log files, datafiles, or instances that can concurrently have the database mounted and open.

If your database contains any read-only or temporary tablespaces, then that SQL script will also contain all the necessary SQL statements to add those files back into the database. The database must not be mounted by any instance. The DBA must then perform media recovery before opening the database. 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 file in the first directory is the primary control 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.

This control file is not an Oracle-managed file. If you omit any clauses, Oracle Database uses the default values rather than the values for the previous control file. Oracle recommends that you then shut down the instance and take a full backup of all files in the database. If you omit this clause and any of these control files already exists, then Oracle Database returns an error.