control file trace - Linux
193386May 27 2004 — edited May 27 2004Hello,
On Linux OS, Oracle 8i DB, the first time (after database startup), I issue
alter database backup controlfile to trace
command, the trace file is created in user dump dir
Subsequest times, do not create the trace file
I tried in Windows, Oracle 8i DB, it works fine.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 94044320 bytes
Fixed Size 73888 bytes
Variable Size 77021184 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SQL> show parameter user_dump
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
user_dump_dest string /home/pooja/data/dump/udump
SQL> !ls -l /home/pooja/data/dump/udump
total 0
SQL> alter database backup controlfile to trace;
Database altered.
SQL> !ls /home/pooja/data/dump/udump
ora_6992.trc
SQL> !rm /home/pooja/data/dump/udump/*.*
SQL> alter database backup controlfile to trace;
Database altered.
SQL> !ls /home/pooja/data/dump/udump
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 94044320 bytes
Fixed Size 73888 bytes
Variable Size 77021184 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SQL> alter database backup controlfile to trace;
Database altered.
SQL> !ls /home/pooja/data/dump/udump
ora_7262.trc