Controlfile script appended to existing file instead of new creation |
 |
EXPERT RESPONSE FROM: Brian Peasland1
|
|
|
| > |
QUESTION POSED ON: 18 August 2004
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.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
