Home » RDBMS Server » Server Administration » alter database backup controlfile to trace as 'j:\ctl.txt' ; (not working)
alter database backup controlfile to trace as 'j:\ctl.txt' ; [message #336441] Sat, 26 July 2008 15:19 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
Oracle 9i , Windows


when trying to backup control file..... getting following error

SQL> alter database backup controlfile to trace as 'j:\ctl.txt' ;
alter database backup controlfile to trace as 'j:\ctl.txt'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended

Re: alter database backup controlfile to trace as 'j:\ctl.txt' ; [message #336442 is a reply to message #336441] Sat, 26 July 2008 15:31 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_15a.htm#2078532

[Updated on: Sat, 26 July 2008 15:34] by Moderator

Report message to a moderator

Re: alter database backup controlfile to trace as 'j:\ctl.txt' ; [message #336470 is a reply to message #336441] Sun, 27 July 2008 09:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Which controlfile you trying to create?
1. binary
2. text

SQL> select * from v$version where rownum =1;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production

SQL> alter database backup controlfile to 'e:\tmp\ctrl.ctl';

Database altered.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> --check udump directory for text based controlfile.

Re: alter database backup controlfile to trace as 'j:\ctl.txt' ; [message #336480 is a reply to message #336441] Sun, 27 July 2008 13:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Problem is J: is a mapped drive.

SQL> alter database backup controlfile to trace as 'e:\ctl.txt' ;

Database altered.

[Updated on: Sun, 27 July 2008 13:47]

Report message to a moderator

Re: alter database backup controlfile to trace as 'j:\ctl.txt' ; [message #336504 is a reply to message #336480] Sun, 27 July 2008 22:50 Go to previous messageGo to next message
IT Guru
Messages: 59
Registered: January 2007
Member
ebrian wrote on Sun, 27 July 2008 13:46
Problem is J: is a mapped drive.

SQL> alter database backup controlfile to trace as 'e:\ctl.txt' ;

Database altered.





Want to create text file.


& J: is lcoal drive.
Re: alter database backup controlfile to trace as 'j:\ctl.txt' ; [message #336531 is a reply to message #336504] Mon, 28 July 2008 01:03 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And your Oracle version is, with 4 decimals?

Regards
Michel

[Updated on: Mon, 28 July 2008 01:03]

Report message to a moderator

Previous Topic: Downgrade Database 10g
Next Topic: low disk space error ora 9i
Goto Forum:
  


Current Time: Mon Dec 05 21:28:29 CST 2016

Total time taken to generate the page: 0.08834 seconds