Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> alter database backup controlfile to trace;
mts
post Sep 17 2009, 11:06 AM
Post #1


Advanced Member
***

Group: Members
Posts: 44
Joined: 20-November 08
Member No.: 38,883



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?

dry.gif

Thanks,
-- mts
Go to the top of the page
 
+Quote Post
burleson
post Sep 17 2009, 12:21 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,623
Joined: 26-January 04
Member No.: 13




>> 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 . . .


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
mts
post Sep 17 2009, 01:00 PM
Post #3


Advanced Member
***

Group: Members
Posts: 44
Joined: 20-November 08
Member No.: 38,883



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
Go to the top of the page
 
+Quote Post
burleson
post Sep 18 2009, 08:58 AM
Post #4


Advanced Member
***

Group: Members
Posts: 11,623
Joined: 26-January 04
Member No.: 13




>> 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.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th October 2014 - 06:31 PM