|
-
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 117442128 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/redo01.log'
shut immediate
then again create the control file
SQL> startup nomount
Create controlfile reuse set database "chaitu"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/system01.dbf',
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/undotbs01.dbf',
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/sysaux01.dbf',
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/users01.dbf',
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/tb1.dbf',
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/tb2.dbf',
'/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/tb3.dbf'
LOGFILE GROUP 1 ('/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/redo03.log') SIZE 51200K
RESETLOGS;
Control file created.
SQL> alter database mount;
SQL> alter database open resetlogs;
try this it will work
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|