How to know the trace file name?

[ramesh_v]

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....????

[rigatoni]

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.

[ajnasaji]

which is the default location of trace file and it's format?

how can reuse the autobackup controlfile ?

[davey23uk]

how can reuse the autobackup controlfile ?

what?