RBS problem during ORACLE STARTUP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: RBS problem during ORACLE STARTUP

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    RBS problem during ORACLE STARTUP

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I also thing it is a disk space issue.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Feb 2004
    Posts
    50
    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?

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    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

  6. #6
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    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

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Instead of keep pressing "Enter" you could have typed "AUTO" and could have had a cup of coffee..
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width