Problem solve Get help with specific problems with your technologies, process and projects.

Controlfile script appended to existing file instead of new creation

In Oracle version, when I issued "alter database backup controlfile to trace," it is not creating the new trace file. But it is appending the create controlfile script to the existing trace file only. Can you tell me the reason for this?
When you issue this command, the control file will be backed up to your current session's trace file. If that trace file already exists, then the information is appended to that existing trace file. If the trace file does not exist, a new one is created. If you get out of SQL*Plus and start a new session, it will receive a new session identifier and the control file backup to trace will be placed in a new trace file.
This was last published in August 2004

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.