-
backup controlfile to trace
hi
svrmgrl> alter database backup controlfile to trace;
can I rename the file at this stage rather going inot udump and copying to another name
Thanks
-
Re: backup controlfile to trace
Originally posted by netbar
hi
svrmgrl> alter database backup controlfile to trace;
can I rename the file at this stage rather going inot udump and copying to another name
Thanks
I think not.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
http://download-west.oracle.com/docs...5a.htm#2078364 look for "trace_file_clause" to probably do what you are trying to do
Jeff Hunter
-
Re: Re: backup controlfile to trace
If you are talking about renaming the backup controlfile(multiplexing control files), then yes you can
Code:
SQL> alter database backup controlfile to 'e:\test.ctl';
Just give the absolute path and name of the backup controlfile.
Else, Jeff has shown you the link.
HTH
Last edited by adewri; 03-21-2003 at 09:46 AM.
Amar
"There is a difference between knowing the path and walking the path."
-
Oh, it is possible:
SQL> alter database backup controlfile to trace as '/opt/oracle9/aaa.trc';
Database altered.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Not with 8.1.7 under NT:
Code:
alter database backup controlfile to trace as 'C:\Temp\aaa.trc'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Originally posted by DaPi
Not with 8.1.7 under NT:
Code:
alter database backup controlfile to trace as 'C:\Temp\aaa.trc'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
its working on Oracle 9.2.0.2.1 on windows 2000 server.
Code:
SQL> alter database backup controlfile to trace as 'e:\trace.lst';
Database altered.
SQL>
Amar
"There is a difference between knowing the path and walking the path."
-
Originally posted by DaPi
Not with 8.1.7 under NT:
Code:
alter database backup controlfile to trace as 'C:\Temp\aaa.trc'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
I did that on SQL*Plus: Release 9.2.0.3.0
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Looks like they have got round to fixing it at last - it was broken already in 7.3.4 under NT.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|