hi
svrmgrl> alter database backup controlfile to trace;
can I rename the file at this stage rather going inot udump and copying to another name
Thanks
Printable View
hi
svrmgrl> alter database backup controlfile to trace;
can I rename the file at this stage rather going inot udump and copying to another name
Thanks
I think not.Quote:
Originally posted by netbar
hi
svrmgrl> alter database backup controlfile to trace;
can I rename the file at this stage rather going inot udump and copying to another name
Thanks
http://download-west.oracle.com/docs...5a.htm#2078364 look for "trace_file_clause" to probably do what you are trying to do
If you are talking about renaming the backup controlfile(multiplexing control files), then yes you can
Just give the absolute path and name of the backup controlfile.Code:SQL> alter database backup controlfile to 'e:\test.ctl';
Else, Jeff has shown you the link.
HTH
Oh, it is possible:Quote:
Originally posted by marist89
http://download-west.oracle.com/docs...5a.htm#2078364 look for "trace_file_clause" to probably do what you are trying to do
SQL> alter database backup controlfile to trace as '/opt/oracle9/aaa.trc';
Database altered.
Not with 8.1.7 under NT:
Code:alter database backup controlfile to trace as 'C:\Temp\aaa.trc'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
its working on Oracle 9.2.0.2.1 on windows 2000 server.Quote:
Originally posted by DaPi
Not with 8.1.7 under NT:
Code:alter database backup controlfile to trace as 'C:\Temp\aaa.trc'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
Code:SQL> alter database backup controlfile to trace as 'e:\trace.lst';
Database altered.
SQL>
I did that on SQL*Plus: Release 9.2.0.3.0Quote:
Originally posted by DaPi
Not with 8.1.7 under NT:
Code:alter database backup controlfile to trace as 'C:\Temp\aaa.trc'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
Looks like they have got round to fixing it at last - it was broken already in 7.3.4 under NT.