Q

Controlfile script appended to existing file instead of new creation

In Oracle version 9.2.0.3.0, 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 first published in August 2004

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close