backup controlfile to trace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: backup controlfile to trace

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

  2. #2
    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,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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."

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

    Amar's Blog  Get Firefox!

  5. #5
    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,12c
    email: ocp_9i@yahoo.com

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

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

  8. #8
    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,12c
    email: ocp_9i@yahoo.com

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width