alter database backup controlfile to trace; Options

[mts]

I'm studying for the 1Z0-042 Exam:

When running "alter database backup controlfile to trace;", the file is put into the background_dump_dest instead of the user_dump_dest.
It is also not named in the default format (sid_ora_pid.trc).

Could anyone tell me why?



Thanks,
-- mts

[burleson]

>> When running "alter database backup controlfile to trace;", the file is put into the background_dump_dest

Because it's always worked that way.

Seriously, that's just how it works, no logic behind it that I'm aware of . . .

[mts]

I'm using the following books to study for the exam:

http://www.amazon.com/Oracle-Database-Cert...0227&sr=8-1

and

http://www.amazon.com/OCA-Oracle-Administr...0262&sr=1-1

They both say that the file should be in the user_dump_dest folder. When I tried it on my server it went in the background_dump_dest folder.

I wanted to see if the books were wrong or I had something setup incorrectly on my server.

Now I can see that this has been changed since the books were published in 2005.

Thanks for your help,

-- mts

[burleson]

>> When I tried it on my server it went in the background_dump_dest folder.

In 11g, a new parameter called "diagnostic_dest" determines where files will are created.

In 11g, diagnostic_dest replaces background_dump_dest, user_dump_dest and core_dump_dest.