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