Ask the Expert

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?

    Requires Free Membership to View

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 first published in August 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: