Backup controlfile to trace (ASCII??)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Backup controlfile to trace (ASCII??)

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    Question Backup controlfile to trace (ASCII??)

    Hi,

    I backup the controlfile to trace in order to modify the output but the result file is binary and not ASCII.
    Any help how to obtain the output as a ASCII file?

    I run those commands:
    sql> connect internal/oracle
    connected
    sql>alter database backup controlfile to trace;
    or
    sql>alter database backup controlfile to 'C:\trace.trc';

    DB=Oracle 8.1.7
    OS:Win2000

    bensmail

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    looking on google would have sent you to this

    alter database backup controlfile to trace as '/some/arbitrary/path';
    alter database backup controlfile to trace as '/some/arbitrary/path' reuse;

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    those commands works fine on Oracle9i, but in Oracle 8i I got a syntax error:
    SQL> alter database backup controlfile to trace as 'C:\trace.lst';
    alter database backup controlfile to trace as 'C:\trace.lst'
    *
    ERROR at line 1:
    ORA-00933: SQL command not properly ended

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    I tested on 9i, it works fine but not on 8i
    Is there any Issue?

    Best Regards
    Bensmail

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Do you have another Ora8i instance to test? - I do not have any 8i left in the shop but I do not remember such a thing ever happened.

    As far as I know there is no reason why 'alter database backup controlfile to trace' would create a binary file instead of a text file.

    If you are certain this is actually happening I would suggest to open a TAR with Oracle.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    I do have access to an 8i system, which should hopefully be going away soon. The first command creates an ASCII file that can be edited to recreate the control files. It will get created in the $ORACLE_ADMIN/udump directory. The second command will create a binary copy of the control file.

    _USER'@'_CONNECT_IDENTIFIER _PRIVILEGE> alter database backup controlfile to trace;

    Database altered.

    Elapsed: 00:00:00.00
    _USER'@'_CONNECT_IDENTIFIER _PRIVILEGE> alter database backup controlfile to '/tmp/trace.trc';

    Database altered.

    Elapsed: 00:00:00.42
    this space intentionally left blank

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