DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to know the trace file name?

  1. #1
    Join Date
    Nov 2004
    Location
    Chennai, INDIA
    Posts
    16

    Red face How to know the trace file name?

    Hi,

    After executing

    "alter database backup controlfile to trace"

    how to identifiy which is my controlfile trace from udump folder,
    i am using the following query....

    select 'ora_'||spid||'.trc' from v$process where addr in
    (select paddr from v$session where sql_hash_value in
    (select hash_value from v$sql where upper(sql_text) like 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE%'))

    but this is not giving the correct file name in RAC environment (even if i use gv$ in all places of the above query instead of v$).

    can any one help me out to findout the filename exactly in all cases....????

    Ramesh V

  2. #2
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    51
    Why not just specify the file name? You can get more details at
    http://www.adp-gmbh.ch/ora/sql/alter_database.html but here's the main idea.

    alter database backup controlfile to ['filename' | trace]

    This command comes in two versions. One backs up the control file in a binary format while the other backs it up in a human readable form. It is required if the database is running in archive log mode and a structural change was made to the database. Backing it up in a binary format:

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

    Backing it up in a human readable format:

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

    If the human readable form is chosen, the file can be made usable if the comments at the beginning are removed and replaced with a connect / as sysdba. If the init.ora file is not at its default location, it has to be appended with a pfile=.... in the line containing a startup.
    ____________________
    Pete

  3. #3
    Join Date
    Jan 2009
    Posts
    1

    trace file

    which is the default location of trace file and it's format?
    how can reuse the autobackup controlfile ?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by ajnasaji View Post
    how can reuse the autobackup controlfile ?

    what?

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