+ Reply to Thread
Results 1 to 9 of 9
  1. 03-21-2003 08:31 AM #1
    netbar
    netbar is offline Member
    Join Date
    Jul 2001
    Posts
    181

    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
    Reply With Quote Reply With Quote
  2. 03-21-2003 08:32 AM #2
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  3. 03-21-2003 08:34 AM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote
  4. 03-21-2003 08:41 AM #4
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    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 08:46 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  5. 03-21-2003 08:55 AM #5
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by marist89
    http://download-west.oracle.com/docs...5a.htm#2078364 look for "trace_file_clause" to probably do what you are trying to do
    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
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  6. 03-21-2003 09:20 AM #6
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
    Reply With Quote Reply With Quote
  7. 03-21-2003 09:22 AM #7
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  8. 03-21-2003 09:30 AM #8
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  9. 03-21-2003 09:33 AM #9
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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