7 Replies Latest reply: Feb 6, 2013 9:49 AM by mseberg RSS

    How To Recover

    user11982706
      Hi All,

      DB Version : 10.2.0.3
      OS version : 6.1

      We have a situation where we were using controlfile instead of rman catalog for backup information. Now we lost the server, which means we have nothing except backup. How can we use
      the available backups after creating the new server. I know data lose is there, but can we recover at all from this situation ?
        • 1. Re: How To Recover
          mseberg
          Hello;

          First write up a plan and review it with somebody. Make sure you include how to recover from the recovery.

          My first slab at a script would be :
          $ORACLE_HOME/bin/rman 
          
          CONNECT TARGET /
          STARTUP NOMOUNT;
          SET DBID ??; #DBID of the database
          
          RUN
          {
             ALLOCATE CHANNEL c1 DEVICE TYPE disk format '??';
             RESTORE CONTROLFILE FROM '??';
             ALTER DATABASE MOUNT;
             RESTORE DATABASE;
             RECOVER DATABASE;
             release channel c1;
          }
          Any chance you have another server to test the recovery on?

          This is the closest document I have :

          http://www.visi.com/~mseberg/rman/restore_database_without_catalog.html

          Your files will be different of course.



          Best Regards

          mseberg
          • 2. Re: How To Recover
            Shivananda Rao
            Hello,

            Take a look at this http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/ Hope it helps !!

            Regards,
            Shivananda
            • 3. Re: How To Recover
              user11982706
              Hi,

              My problem is that my database is never registered with RMAN.... till now we were using controlfile for this DB. Now, all the controlfiles gone along with datafiles. We only have RMAN backup
              pieces at a location with no other information....

              I can start the DB in no mount state but while trying to connect to RMAN for catalog backup, it says database must be in mount state.

              For mounting a database, i need controlfile, which i don't have...
              • 4. Re: How To Recover
                mseberg
                Right.

                To recover a control file you have to start NO MOUNT.

                Once you have recovered it you MOUNT to recover the rest.

                Notice the script I posted before is in NO MOUNT. The other thing to watch out for is autobackup because if you are using FRA the control file and spfile will be in a different location than the rest of the backup.

                The link in the prior post shows a recovery to a different server without catalog. This can be done.

                Make sense? if not which part does not?

                Best Regards

                mseberg
                • 5. Re: How To Recover
                  TSharma-Oracle
                  When RMAn takes the backup of the system tablespace, it automatically save a backup of a controlfile in that backup set. So even if you didnt have a seprate controlfile backup ,you should be able to restore it from one of yor backup pieces.

                  RMAN> Restore controlfile from 'backup set of system tablespace';

                  Rest I do agree with msberg's steps.
                  • 6. Re: How To Recover
                    user11982706
                    Thanks "mseberg", it really helped....
                    • 7. Re: How To Recover
                      mseberg
                      You are welcome.

                      Thanks for letting me know.

                      Best Regards

                      mseberg