9 Replies Latest reply on Jan 10, 2020 3:41 AM by Beauty_and_dBest

    Restore old 11i backup

    Beauty_and_dBest

      Hi ALL,

       

      We have migrated our  EBS 11i instance to 12.2.4 , two years ago.

      But we need to restore our 11i backup for some auditing.

       

      I already forgot what are the component folders of EBS 11i 

      Below are the tar backup:

       

      -rw-r--r--. 1 upload upload   3557574924 Dec 20 15:48 oaprodappl.tar.gz

      -rw-r--r--. 1 upload upload   3593343189 Dec 20 15:44 oaprodcomn.tar.gz

      -rw-r--r--. 1 upload upload 57069377387 Dec 20 17:20 oaproddata.tar.gz

      -rw-r--r--. 1 upload upload   3615139741 Dec 20 16:01 oaproddb.tar.gz

      -rw-r--r--. 1 upload upload   5060003175 Dec 20 16:19 oaprodora.tar.gz

       

      Would you know which files belong to the Database Tier?  and which ones belong to the Apps-Tier?

       

       

      Please help....

       

      Kind regards,

      jc

        • 1. Re: Restore old 11i backup
          Maaz Khan

          Hello Jc,

           

          You can use zcat command to check files and folders present in gz file. Actually zcat will display all files present in zipped tarball. One way to simply scan and get some idea is to use command like below -

          zcat -f APPS_Bkp_PROD_21-12-19.tar.gz | more

           

           

          Regards,

          Maaz

          • 2. Re: Restore old 11i backup
            mdtaylor

            Hi jc,

             

            The appl, comn and ora files are app tier backups, db and data are database backups.

             

            You are also use tar -zvtf oaproddata.tar.gz to list the files and see the path stored in the archive.  Change the t to x to extract.

             

            Regards,

            Michael

            • 3. Re: Restore old 11i backup
              Beauty_and_dBest

              Thanks Michael and Maaz,

               

              I found  that proddb and proddata belongs to DbTier,

               

              Now I am running cloning to restore it, but I got error below

               

              $ perl adcfgclone.pl dbTier

              Enter the APPS password [APPS]:

              apps

              ERROR : Unable to set CLASSPATH

                  /home/oraprod/PROD/proddb/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is  missing

               

              First Creating a new context file for the cloned system.

              The program is going to ask you for information about the new system:

               

               

              Error: can't find libjava.so.

              ERROR: context creation not completed successfully.

              Please check /tmp/adcfgclone.err file for errors

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

               

              Which classes111.zip do I need to copy?

              $ find  /home/oraprod/PROD -name classes111.zip

              /home/oraprod/PROD/proddb/9.2.0/olap/wrksht/lib/classes111.zip

              /home/oraprod/PROD/proddb/9.2.0/jdbc/lib/classes111.zip

              /home/oraprod/PROD/proddb/9.2.0/inventory/filemap/jdbc/lib/classes111.zip

               

               

               

              Please help....

               

              Kind regards,

              • 4. Re: Restore old 11i backup
                Beauty_and_dBest

                Hi ALL,

                 

                I tried work around below, but I still have errors

                 

                $ linux32 perl adcfgclone.pl database

                 

                Enter the APPS password [APPS]:

                apps

                 

                First Creating a new context file for the cloned system.

                The program is going to ask you for information about the new system:

                 

                ERROR: context creation not completed successfully.

                Please check /tmp/adcfgclone.err file for errors

                 

                [oraprod@db-stt bin]$ cat /tmp/adcfgclone.err

                /home/oraprod/PROD/proddb/9.2.0/appsutil/clone/jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory

                 

                 

                Please help...

                 

                Kind regards,

                • 5. Re: Restore old 11i backup
                  mdtaylor

                  Hi jc,

                   

                  Please ensure the target server has all OS requirements for 11i:

                   

                  Oracle Applications Installation Update Notes, Release 11i (11.5.10.2) (Doc ID 316806.1)

                   

                  Also be advised 11i is only certified on 32-bit Linux.

                   

                  Regards,

                  Michael

                  • 6. Re: Restore old 11i backup
                    Beauty_and_dBest

                    Thanks Michael, Maaz and ALL,

                     

                    We want only the database to be restored. I forgot if the database was 32 or 64bit?

                    Does it mean the database 9i will not run on 64bit OS?

                     

                     

                    Kind regards,

                    • 7. Re: Restore old 11i backup
                      BPeaslandDBA

                      Beauty,

                       

                      I read this thread and another thread you have about restoring these databases. And while I don't have any advice for your specific problem that hasn't already been stated, I would like to offer some generic advice.

                       

                      As you are going through these restores and trying to get this database up and running. Document what you learn along the way. Your company should have documentation on how this all works. Some day you might win the lottery and immediately retire and your replacement will appreciate the documentation artifact you left behind. Even if you don't care about your replacement because you're rich and its now someone else's problem, you'll appreciate the documentation this time next year when you do the same activity and you realize you really didn't win the lottery. So do the documentation for yourself. Also, if your company is audited by an outside party to maintain compliance with whatever laws and policies your company needs to follow, the auditors like seeing these things documented.

                       

                      You are also finding things that are wrong, missing, and not working as you try to restore the database. Make note of what isn't working, what is missing, and what you need to get things up and running again. Take steps in the next year to fix those issues so they are not issues going forward.

                       

                      Finally, look at how this fits into your overall disaster recovery plans. If you are having problems with this one database then will you have problems with others in a real disaster? Most times, the DBA settles on a backup and recovery plan then implements it for all databases in the enterprise. If this backup and recovery plan is not working for the most important part, *recovery*, then you may have larger problems to tackle.

                       

                      Cheers,
                      Brian

                      • 8. Re: Restore old 11i backup
                        Pravin Takpire

                        9i 32 bit will work on 64 bit OS but OS version has to be compatible with 9i DB. I would suggest if you have that old server kept somewhere use that. restore DB and Oracle Home on old server if possible

                        • 9. Re: Restore old 11i backup
                          Beauty_and_dBest

                          Thanks ALL

                           

                          I was able to clone/restore  EBS 11i database 9i   32bit OL5   to  64bit OL6.

                          I know 9i is not supported in 64bit OL6? But at least I was able to open the database.

                          I can access our database now which is our goal to audit some data, but this does not   include the restoration of the appsTier.

                           

                          The process I did is below:

                          Login as root:

                           

                          # cd /usr/lib

                          ln -s libstdc++-libc6.2-2.so.3  libstdc++-libc6.1-1.so.2

                           

                          Create oraprod user and restore/unzip backup to the target location (same as the source)

                          -rw-r--r--. 1 upload upload 57069377387 Dec 20 17:20 oaproddata.tar.gz

                          -rw-r--r--. 1 upload upload   3615139741 Dec 20 16:01 oaproddb.tar.gz

                           

                          Login to oraprod user:

                           

                          export PATH=/home/oraprod/PROD/proddb/9.2.0/Apache/perl/man:$PATH

                          export PATH=/home/oraprod/PROD/proddb/9.2.0/Apache/perl/:$PATH

                          export PERL5LIB=/home/oraprod/PROD/proddb/9.2.0/Apache/perl/lib/5.00503:/home/oraprod/PROD/proddb/9.2.0/Apache/perl/lib/site_perl/5.005

                          export PATH=/home/oraprod/PROD/proddb/9.2.0/bin:$PATH

                          export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'

                           

                          Run dbTier cloning:

                           

                          $ linux32 perl adcfgclone.pl database

                           

                           

                           

                          Kind regards,