Home » RDBMS Server » Server Administration » Error while Recreating controlfile (oracle 9i,linux 4)
Error while Recreating controlfile [message #387965] Sun, 22 February 2009 12:40 Go to next message
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
Re: Error while Recreating controlfile [message #387967 is a reply to message #387965] Sun, 22 February 2009 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove blank lines.

Regards
Michel
Re: Error while Recreating controlfile [message #387968 is a reply to message #387965] Sun, 22 February 2009 12:46 Go to previous message
BlackSwan
Messages: 25046
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.
Previous Topic: how to convert from WE8MSWIN1252 to WE8ISO8859P1
Next Topic: session_cached_cursor
Goto Forum:
  


Current Time: Thu Dec 08 22:19:57 CST 2016

Total time taken to generate the page: 0.09760 seconds