1 2 Previous Next 16 Replies Latest reply: Sep 10, 2013 11:52 AM by jgarry RSS

    Backup problem

    AnumulaPraveen

      Hi all,

       

      I did backup using rman..after that I try to recover database i got a error that my systems tablespace cant recover.

       

      can anyone help me with this problem.

       

      Thanks

      Praveen

        • 1. Re: Backup problem
          DK2010

          Hi,

           

          Please read this :https://forums.oracle.com/message/9362002#9362002

          and provide all the details like your  Db/os version,backup and recovery command and what error you get

          • 2. Re: Backup problem
            sybrand_b

            I don't see any specific problem.

            You didn't post your four digit Oracle version

            You didn't post your OS

            And most importantly: you didn't post the error stack.

            Your webcam was off, and we are not sitting at your desk.

            No help is possible.

             

            -----------

            Sybrand Bakker

            Senior Oracle DBA

            • 3. Re: Backup problem
              AnumulaPraveen

              Hi

              Thanks to reply me...I will post with the error stack what i got exactly

               

              Praveen

              • 4. Re: Backup problem
                HDeiby

                Please read next Link about restore and recover tablespace:

                 

                http://blog.flimatech.com/2010/11/27/how-to-restore-and-recover-tablespace/

                • 5. Re: Backup problem
                  Aman....

                  This is exactly asking like , I tried to start my car in the morning but it didn't start, what can be the reason?  And the answer is, how do we know ? As others have requested, you would need to tell us at least the exact error message before we can suggest a solution to you.

                   

                  That said, just asking that your db is in the archivelog mode, right?

                   

                  Aman....

                  2fb9f2c1-3571-458b-ab23-0b60478d4792 wrote:

                   

                  Hi all,

                   

                  I did backup using rman..after that I try to recover database i got a error that my systems tablespace cant recover.

                   

                  can anyone help me with this problem.

                   

                  Thanks

                  Praveen

                  • 6. Re: Backup problem
                    jgarry

                    You also might show us what steps you did to try to recover.  Did you restore?

                    • 7. Re: Backup problem
                      Hemant K Chitale

                      Possibly your BACKUP and RESTORE didn't include the ArchiveLogs that are required.

                       

                      Hemant K Chitale


                      • 8. Re: Backup problem
                        AnumulaPraveen

                        yes hemant you are correct..it says like backup archived is not valid..

                        can you say wat should i do

                         

                        Praveen

                        • 9. Re: Backup problem
                          Hemant K Chitale

                          >..it says like backup archived is not valid

                          I don't what that means.  What was the exact command you tried (e.g. to restore archivelogs ?) .  What was the error message returned ?

                           

                          Hemant K Chitale

                          • 10. Re: Backup problem
                            AnumulaPraveen


                            I tried like

                             

                            restore datafile 6;

                             

                            then it restore successfully then i tried

                             

                            recover datafile 6;

                             

                            while doing that i got an error but i dont remember exact error message, and  I tried to recover system tablespace.

                             

                            Praveen

                            • 11. Re: Backup problem
                              Hemant K Chitale

                              In your initial post you said "I try to recover database i got a error that my systems tablespace cant recover."  which meant that you were trying to RECOVER the whole database.  Presumably, you did a RESTORE DATABASE (not just DATAFILE 6 and the SYSTEM tablespace datafile).

                               

                              It is likely that the archivelogs require for the RECOVERy were not available (or not available fully) --- either in backups or on disk.

                               

                               

                              Hemant K Chitale

                              • 12. Re: Backup problem
                                Prashant Namdeo

                                Hi Praveen,

                                 

                                 

                                It looks like you don't have archive logs or the RMAN is unable to find the valid backup of archive logs. What you can do is you can perform an incomplete recovery.

                                 

                                Try commands,

                                 

                                RMAN> Restore datafile 6;

                                RMAN> Recover datafile 6 noredo;

                                 

                                then open the database with resetlog option.

                                 

                                Hope it will help you

                                NOTE: There will be loss of data.

                                 

                                Thanks,

                                Prahsant

                                • 13. Re: Backup problem
                                  AnumulaPraveen

                                  oh..thank you and I will try it

                                   

                                  Hey,dude actually I am looking for dba jobs.. can any one help me how to search and any specific website for dba jobs...please

                                   

                                   

                                  Thanks,

                                  Praveen

                                  • 14. Re: Backup problem
                                    EdStevens

                                    2fb9f2c1-3571-458b-ab23-0b60478d4792 wrote:

                                     


                                    I tried like

                                     

                                    restore datafile 6;

                                     

                                    then it restore successfully then i tried

                                     

                                    recover datafile 6;

                                     

                                    while doing that i got an error but i dont remember exact error message, and  I tried to recover system tablespace.

                                     

                                    Praveen

                                     

                                    There is very little that can be done to help until you start providing actual commands and actual error messages.  Trying to troubleshoot based on your description of your perceptions of what you think you did is just an exercise in futility.

                                     

                                     

                                    ============================================================================

                                    BTW, it would be really helpful if you would go to your profile and give yourself a recognizable name.  It doesn't have to be your real name, just something that looks like a real name.  Who says my name is really Ed Stevens?  But at least when people see that on a message they have a recognizable identity.  Unlike the system generated name of 'ed0f625b-6857-4956-9b66-da280b7cf3a2', which is like going to the pub with a bag over your head.

                                    ============================================================================

                                    1 2 Previous Next