| yogi |
Posted: Apr 02, 2008 07:01:23 AM |
Total Post: 9
Joined: Apr, 2008
|
hi all
iam newbie to this oracle DBA . i deleted 3 of my controlfile in test database with proper backup .iam not able open my database with this control file script ;
CREATE CONTROLFILE SET DATABASE "NISI" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/d01/aa1/nisi/redo01.log' SIZE 50M,
GROUP 2 '/d01/aa1/nisi/redo02.log' SIZE 50M,
GROUP 3 '/d01/aa1/nisi/redo03.log' SIZE 50M
DATAFILE
'/d01/aa1/nisi/system01.dbf',
'/d01/aa1/nisi/undotbs01.dbf',
'/d01/aa1/nisi/sysaux01.dbf',
'/d01/aa1/nisi/users01.dbf',
'/d01/aa1/nisi/example01.dbf',
'/d01/aa1/nisi/abc.dbf'
CHARACTER SET WE8ISO8859P1
;
its showing me a error ORA-01503: CREATE CONTROLFILE failed
ORA-01158: database already mounted
help me in this issue
|
|
|
 Murtuja |
| Posted: Apr 02, 2008 07:55:59 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
give these commands...
sql > shutdown;
sql > startup nomount;
sql > alter database mount;
sql > alter database open;
|
|
|
|
|
| Murtuja |
| Posted: Apr 02, 2008 07:57:53 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Sorry I forget create contolfile statement in my last post
give these commands...
sql > shutdown;
sql > startup nomount;
sql >CREATE CONTROLFILE SET DATABASE "NISI" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/d01/aa1/nisi/redo01.log' SIZE 50M,
GROUP 2 '/d01/aa1/nisi/redo02.log' SIZE 50M,
GROUP 3 '/d01/aa1/nisi/redo03.log' SIZE 50M
DATAFILE
'/d01/aa1/nisi/system01.dbf',
'/d01/aa1/nisi/undotbs01.dbf',
'/d01/aa1/nisi/sysaux01.dbf',
'/d01/aa1/nisi/users01.dbf',
'/d01/aa1/nisi/example01.dbf',
'/d01/aa1/nisi/abc.dbf'
CHARACTER SET WE8ISO8859P1
;
sql > alter database mount;
sql > alter database open;
|
|
|
|
|
| yogi |
| Posted: Apr 02, 2008 10:47:26 AM | |
|
Total Post: 9
Joined: Apr, 2008
|
hi Murtuja i gave commands it didnt work i got this error
SQL> startup nomount
ORACLE instance started.
Total System Global Area 603979776 bytes
Fixed Size 1263176 bytes
Variable Size 255855032 bytes
Database Buffers 339738624 bytes
Redo Buffers 7122944 bytes
SQL> CREATE CONTROLFILE SET DATABASE "NISI" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 '/d01/aa1/nisi/redo01.log' SIZE 50M,
9 GROUP 2 '/d01/aa1/nisi/redo02.log' SIZE 50M,
10 GROUP 3 '/d01/aa1/nisi/redo03.log' SIZE 50M
11 DATAFILE
12 '/d01/aa1/nisi/system01.dbf',
13 '/d01/aa1/nisi/undotbs01.dbf',
14 '/d01/aa1/nisi/sysaux01.dbf',
15 '/d01/aa1/nisi/users01.dbf',
16 '/d01/aa1/nisi/example01.dbf',
17 '/d01/aa1/nisi/abc.dbf'
18 CHARACTER SET WE8ISO8859P1
19 ;
CREATE CONTROLFILE SET DATABASE "NISI" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/d01/aa1/nisi/system01.dbf'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 02, 2008 11:15:37 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
with datafile name specify FILESIZE ( size clause) also.
in KILOBYTES/MEGABYTES.
|
|
|
|
|
| Murtuja |
| Posted: Apr 02, 2008 12:05:20 PM | |
|
Total Post: 814
Joined: Jan, 2006
|
This problem is due to incorrect DB_BLOCK_SIZE parameter.So we have to specify correct pfile during startup nomount.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
