2 Replies Latest reply: Jul 3, 2013 2:49 AM by Gajananh999 RSS

    alter tablespace sa online;

    Gajananh999

      Dear Everyone,

       

      SQL> alter tablespace sa online;

      alter tablespace sa online

      *

      ERROR at line 1:

      ORA-01113: file 6 needs media recovery

      ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/tbs_data.dat'

       

      Can anyone tell me what is the problem here

       

      SQL> recover datafile  '/u01/app/oracle/product/11.2.0/db_1/dbs/tbs_data.dat';

      ORA-00279: change 1859444 generated at 06/17/2013 02:57:17 needed for thread 1

      ORA-00289: suggestion :

      /flash_recovery/flash_recovery_area/SA/archivelog/2013_07_01/o1_mf_1_35_%u_.arc

      ORA-00280: change 1859444 for thread 1 is in sequence #35

       

       

       

       

      Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

      AUTO

      ORA-00308: cannot open archived log

      '/flash_recovery/flash_recovery_area/SA/archivelog/2013_07_01/o1_mf_1_35_%u_.arc

      '

      ORA-27037: unable to obtain file status

      Linux-x86_64 Error: 2: No such file or directory

      Additional information: 3

       

       

       

       

      ORA-00308: cannot open archived log

      '/flash_recovery/flash_recovery_area/SA/archivelog/2013_07_01/o1_mf_1_35_%u_.arc'

      ORA-27037: unable to obtain file status

      Linux-x86_64 Error: 2: No such file or directory

      Additional information: 3

       

      Can Anyone please help me on this.

       

      Thanks

      Gajanan

        • 1. Re: alter tablespace sa online;
          EdStevens

          Gajananh999 wrote:

           

          Dear Everyone,

           

          SQL> alter tablespace sa online;

          alter tablespace sa online

          *

          ERROR at line 1:

          ORA-01113: file 6 needs media recovery

          ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/tbs_data.dat'

           

          Can anyone tell me what is the problem here

           

          SQL> recover datafile  '/u01/app/oracle/product/11.2.0/db_1/dbs/tbs_data.dat';

          ORA-00279: change 1859444 generated at 06/17/2013 02:57:17 needed for thread 1

          ORA-00289: suggestion :

          /flash_recovery/flash_recovery_area/SA/archivelog/2013_07_01/o1_mf_1_35_%u_.arc

          ORA-00280: change 1859444 for thread 1 is in sequence #35

           

           

           

           

          Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

          AUTO

          ORA-00308: cannot open archived log

          '/flash_recovery/flash_recovery_area/SA/archivelog/2013_07_01/o1_mf_1_35_%u_.arc

          '

          ORA-27037: unable to obtain file status

          Linux-x86_64 Error: 2: No such file or directory

          Additional information: 3

           

           

           

           

          ORA-00308: cannot open archived log

          '/flash_recovery/flash_recovery_area/SA/archivelog/2013_07_01/o1_mf_1_35_%u_.arc'

          ORA-27037: unable to obtain file status

          Linux-x86_64 Error: 2: No such file or directory

          Additional information: 3

           

          Can Anyone please help me on this.

           

          Thanks

          Gajanan

          Why was tablespace SA offline in the first place?

          What did you do with /flash_recovery/flash_recovery_area/SA/archivelog/2013_07_01/o1_mf_1_35_%u_.arc that the recovery could not find it?

           

          What version (to 4 decimals) and edition (Enterprise, Standard, Standard One) is your database?

          • 2. Re: alter tablespace sa online;
            Gajananh999

            Dear All,

             

            While moving the oracle files from one location to another location i missed the datafile of one table space. So to create that datafile i made this tablespace as offline and tried using RMAN to restore that datafile 6 . It recreated the new datafile 6 but it was unable to recover that file because some log files are missing . Then Simply i did Just deleted the Tablespace SA and created the new one with same. Because there was no much data in database.

             

            And my problem is got solved

             

            Thanks

            Gajanan Hiroji