| How to find the control file I backup [message #75040] |
Sat, 14 April 2001 01:21  |
wyshuai
Messages: 13
Registered: December 2000
|
Junior Member |
|
|
svrmgr>alter database backup controlfile to trace;
How to find the trace file ?
----------------------------------------------------------------------
|
|
|
|
| Re: How to find the control file I backup [message #75044 is a reply to message #75040] |
Mon, 23 April 2001 09:19  |
Tom Wiltsch
Messages: 1
Registered: April 2001
|
Junior Member |
|
|
Look in your init.ora or v$parameter to find the value of user_dump_dest. This is the default storage location for the trace file. Because it will have an ora_xxxx.trc file name, you'll have to pick it out be time or grep for something within the file to locate it. When you find it, rename it.
----------------------------------------------------------------------
|
|
|
|
| Re: How to find the control file I backup [message #75068 is a reply to message #75040] |
Wed, 27 June 2001 11:03 |
Anthony Ajebon
Messages: 4
Registered: June 2001
|
Junior Member |
|
|
The destination of your udump in the init.ora tells you where your user trace files are.
Search through your udump for the variuos .trc files and rename the controlfile to a meaningful name. Otherwise if you did not specify the dest in the init.ora, the default is in $ORACLE_HOME/rdbms/log. Find your controlfile there by searching through the files, one after the other using vi.
Good luck.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
