OraFAQ Forum: Server Administration » alter database backup controlfile to trace as 'j:\ctl.txt' ;

Home » RDBMS Server » Server Administration » alter database backup controlfile to trace as 'j:\ctl.txt' ; (not working)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alter database backup controlfile to trace as 'j:\ctl.txt' ; [message #336441]

Sat, 26 July 2008 15:19

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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

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.

Report message to a moderator

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

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68676
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 19:19:25 CDT 2024