3 Replies Latest reply on Dec 2, 2012 6:13 PM by nnarimanov

    Creating a Database with only RMAN backup


      I have a RMAN full backup of a 10g database( in RHEL5 server. This backup has only backup piece does not include SP file and control file. I want to create a new database with this backup in a new server. Is this possible??? How to proceed further??

        • 1. Re: Creating a Database with only RMAN backup

          The control file is going to be an issue.

          Even if you have CONTROLFILE AUTOBAKUP set to OFF, any backup including system tablespace should include a current control file backup.

          Find it and use this :
          RMAN>RESTORE CONTROLFILE FROM '/backup_dir/piece_name';
          Autobackup is not available but controlfile backupset is available
          rman target /
          startup nomount;
          restore controlfile from <backupset_location>;
          alter database mount;
          restore database; --required if datafile(s) have been added after the backup
          recover database;
          alter database open resetlogs; 
          If you can find the control file this may help :

          RMAN recovery to a different server when nocatalog is available


          Best Regards

          1 person found this helpful
          • 2. Re: Creating a Database with only RMAN backup
            Shivananda Rao

            Refer this You can 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/

            RMAN automatically backs up spfile and controlfile in the backup of datafile 1 (SYSTEM datafile). So, you can restore them from the backup piece that is having the system datafile.
            4.3.5 Backing Up Control Files with RMAN
            Handle:      007
            Status Level:      Newbie (25)
            Registered:      Sep 6, 2010
            Total Posts:      272
            Total Questions:      154 (123 unresolved)
            Name      Khanth
            Location      India
            Occupation      Junior DBA
            I feel unhappy when you do not close your threads if they have been answered. If you feel that the threads have been answered, then please consider closing them by providing appropriate points and marking them as answered. Please keep the forum clean !!

            • 3. Re: Creating a Database with only RMAN backup
              You can create controlfile, if you know the names of datafiles, DB characterset and national characterset, in other words you can simulate a controlfile. After this step just force a "catalog" via rman.