RBS problem during ORACLE STARTUP

[gajananpkini]

folks

Can u please tell me what to be done.

SVRMGR> startup
ORACLE instance started.
Total System Global Area 72421536 bytes
Fixed Size 73888 bytes
Variable Size 55398400 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/home1/oracle/oradata/HNS/rbs01.dbf'

SVRMGR> recover database
ORA-00283: recovery session canceled due to errors
ORA-01114: IO error writing block to file 3 (block # 1)
ORA-01110: data file 3: '/home1/oracle/oradata/HNS/rbs01.dbf'
ORA-27091: skgfqio: unable to queue I/O
Linux Error: 9: Bad file descriptor
Additional information: 1

SVRMGR> recover datafile '/home1/oracle/oradata/HNS/rbs01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01114: IO error writing block to file 3 (block # 1)
ORA-01110: data file 3: '/home1/oracle/oradata/HNS/rbs01.dbf'
ORA-27091: skgfqio: unable to queue I/O
Linux Error: 9: Bad file descriptor
Additional information: 1

[hrishy]

Hi

Is there enough space on the device left ?

'/home1/oracle/oradata/HNS/

i think oracle wants to write into this file but since enough space is not available its faling .

regards
Hrishy

[julian]

I also thing it is a disk space issue.

[Rickenbacker]

I'm not so sure that this is a space issue.
If it was, I would expect Linux Error: 28: No space left on device.

Instead it reports a bad file descriptor.

What has happened to this database?

[hrishy]

Originally posted by Rickenbacker
I'm not so sure that this is a space issue.
If it was, I would expect Linux Error: 28: No space left on device.

Instead it reports a bad file descriptor.

What has happened to this database?

lets see if the dude gets back with more information.

regards
Hrishy

[gajananpkini]

SVRMGR> recover datafile '/home1/oracle/oradata/HNS/rbs01.dbf';
SVMRGR> recover database
but both didnt work.

Later on i saw that file permissions were wrong.

[root@mail HNS]# chown oracle rbs01.dbf
[root@mail HNS]# chgrp oinstall rbs01.dbf

SVRMGR> recover datafile '/home1/oracle/oradata/HNS/rbs01.dbf';
ORA-00279: change 6651886 generated at 01/20/2004 15:37:22 needed for thread 1
ORA-00289: suggestion : /home1/oracle/admin/HNS/arch/arch_1_71654.arc
ORA-00280: change 6651886 for thread 1 is in sequence #71654
Specify log: {=suggested | filename | AUTO | CANCEL}

I kept ON PRESSING enter
Log applied.
ORA-00279: change 6672048 generated at 03/09/2004 21:08:49 needed for thread 1
ORA-00289: suggestion : /home1/oracle/admin/HNS/arch/arch_1_71655.arc
ORA-00280: change 6672048 for thread 1 is in sequence #71655
ORA-00278: log file '/home1/oracle/admin/HNS/arch/arch_1_71654.arc' no longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}

Log applied.
ORA-00279: change 6672163 generated at 03/09/2004 21:20:52 needed for thread 1
ORA-00289: suggestion : /home1/oracle/admin/HNS/arch/arch_1_71656.arc
ORA-00280: change 6672163 for thread 1 is in sequence #71656
ORA-00278: log file '/home1/oracle/admin/HNS/arch/arch_1_71655.arc' no longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}

Log applied.
ORA-00279: change 6673804 generated at 03/09/2004 21:39:03 needed for thread 1
ORA-00289: suggestion : /home1/oracle/admin/HNS/arch/arch_1_71672.arc
ORA-00280: change 6673804 for thread 1 is in sequence #71672
ORA-00278: log file '/home1/oracle/admin/HNS/arch/arch_1_71671.arc' no longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}

i did it many times and then i got this message

Log applied.
Media recovery complete.

alter database open;
statement processed

[SANJAY_G]

Instead of keep pressing "Enter" you could have typed "AUTO" and could have had a cup of coffee..

[DaPi]

Originally posted by SANJAY_G
Instead of keep pressing "Enter" you could have typed "AUTO" and could have had a cup of coffee..

Such are the rewards of RTFM.