Rename control file in oracle

Oracle Database Backup and Recovery User's Guide for information about recovering your database and methods of recovering a lost control file.

If you did not perform recovery, or you performed complete, closed database recovery in step 8 , open the database normally. After creating a new control file and using it to open the database, check the alert log to see if the database has detected inconsistencies between the data dictionary and the control file, such as a data file in the data dictionary includes that the control file does not list.

If a data file exists in the data dictionary but not in the new control file, the database creates a placeholder entry in the control file under the name MISSING nnnn , where nnnn is the file number in decimal. In this case, you must drop the tablespace containing the data file. Conversely, if a data file listed in the control file is not present in the data dictionary, then the database removes references to it from the new control file.

In both cases, the database includes an explanatory message in the alert log to let you know what was found. In this case, you should restore the files you backed up in " Creating New Control Files " and repeat the procedure in that task, using the correct file names.

Back up the control file to a binary file duplicate of existing control file using the following statement:. This command writes a SQL script to a trace file where it can be captured and edited to reproduce the control file.

View the alert log to determine the name and location of the trace file. Oracle Database Backup and Recovery User's Guide for more information on backing up your control files.

You can drop control files, but the database should have at least two control files at all times. You want to drop control files from the database, for example, if the location of a control file is no longer appropriate.

This operation does not physically delete the unwanted control file from the disk. Use operating system commands to delete the unnecessary file after you have dropped the control file from the database. Previous Next JavaScript must be enabled to correctly display this content.

You can create, back up, and drop control files. What Is a Control File? Guidelines for Control Files You can follow guidelines to manage the control files for a database.

Creating Control Files You can create, copy, rename, and relocate control files. Recovering a Control File Using a Current Copy You can recover your control file from a current backup or from a multiplexed copy. Dropping Control Files You can drop control files, but the database should have at least two control files at all times. Control Files Data Dictionary Views You can query a set of data dictionary views for information about control files.

See Also: Oracle Database Concepts for an overview of control files Using Oracle Managed Files for information about creating control files that are both created and managed by the Oracle Database server.

The control file includes: The database name Names and locations of associated data files and redo log files The timestamp of the database creation The current log sequence number Checkpoint information The control file must be available for writing by the Oracle Database server whenever the database is open.

An open database has a tablespace named users that is made up of datafiles all located on the same disk. The datafiles of the users tablespace are to be relocated to different and separate disk drives. Copy the datafiles to their new locations and rename them using the operating system.

The datafile pointers for the files that make up the users tablespace, recorded in the control file of the associated database, must now be changed from the old names to the new names. This method is the only choice if you want to rename or relocate datafiles of several tablespaces in one operation. Copy the datafiles to be renamed to their new locations and new names, using the operating system.

Skip Headers. Renaming and Relocating Datafiles You can rename datafiles to either change their names or relocate them. Previous Post Previous. Next Post Next. Search for: Search Hits by Community.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. You can find out more about Policy by tapping This Link. Manage consent. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website.

Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary Necessary. Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. Home » Articles » Misc » Here. This article presents a brief explanation of how assorted Oracle files can be renamed or moved to a new location. The examples are based on a default Oracle 10g installation on Windows, but the method is the same for different versions of Oracle on any platform, with the exception of the host command used to rename the file.

For instances using a pfile replace the spfile manipulation steps with an amendment of the parameter in the init. Repeating the initial query shows that the the controlfile has been renamed in the data dictionary.