OraFAQ Forum: Server Administration » Error while Recreating controlfile

Home » RDBMS Server » Server Administration » Error while Recreating controlfile (oracle 9i,linux 4)

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

Error while Recreating controlfile [message #387965]

Sun, 22 February 2009 12:40

imraan
Messages: 21
Registered: June 2008
Location: ayangudi

Junior Member

hi i try to recreate the controlfile, but it's end in error;

the contents of the controlfile while recreation is

CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS ARCHIVELOG

MAXLOGFILES 32

MAXLOGMEMBERS 2

MAXDATAFILES 32

MAXINSTANCES 16

MAXLOGHISTORY 1815

LOGFILE

GROUP 1'/oracle/app/oracle/oradata/TEST/REDO1.LOG'SIZE 20M,

GROUP 2'/oracle/app/oracle/oradata/TEST/REDO2.LOG'SIZE 20M

DATAFILE

'/oracle/app/oracle/oradata/TEST/SYSTEM.DBF',

'/oracle/app/oracle/oradata/TEST/UNDOTBS1.DBF',

'/oracle/app/oracle/oradata/TEST/ABC1.DBF'

CHARACTER SET US7ASCII

;

The error is:

SQL> SQL> SP2-0734: unknown command beginning "MAXLOGMEMB..." - rest of line ignored.
SQL> SQL> SP2-0734: unknown command beginning "MAXDATAFIL..." - rest of line ignored.
SQL> SQL> SP2-0734: unknown command beginning "MAXINSTANC..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL> SQL> SP2-0734: unknown command beginning "MAXLOGHIST..." - rest of line ignored.
SQL> SQL> SP2-0042: unknown command "LOGFILE" - rest of line ignored.
SQL> SQL> SP2-0734: unknown command beginning "GROUP 1'/o..." - rest of line ignored.
SQL> SQL> SP2-0734: unknown command beginning "GROUP 2'/o..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL> SQL> SP2-0042: unknown command "DATAFILE" - rest of line ignored.
SQL> SQL> SP2-0734: unknown command beginning "'/oracle/a..." - rest of line ignored.
SQL> SQL> SP2-0734: unknown command beginning "'/oracle/a..." - rest of line ignored.
SQL> SQL> SP2-0734: unknown command beginning "'/oracle/a..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL> SQL> SP2-0734: unknown command beginning "CHARACTER ..." - rest of line ignored.

what is the problem with this,pls explain

Report message to a moderator

Re: Error while Recreating controlfile [message #387967 is a reply to message #387965]

Sun, 22 February 2009 12:45

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remove blank lines.

Regards
Michel

Report message to a moderator

Re: Error while Recreating controlfile [message #387968 is a reply to message #387965]

Sun, 22 February 2009 12:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Here is a free clue.
SQLPLUS does not like blank lines within single SQL statement.

Report message to a moderator

Previous Topic:	how to convert from WE8MSWIN1252 to WE8ISO8859P1
Next Topic:	session_cached_cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 18:43:34 CDT 2024