Oracle RMAN – How to Duplicate from Backup Set Only

disaster recoveryduplicationoraclerman

I have what appears to be an RMAN backup set, it has been multiplexed in 32 files, each containing 2-3 dbf's inside. The backupset refers to an SPFILE file, but it was not included in the set, the backup piece containing just that file was not included.

I have no catalog, no infrastructure, and no way to connect to original database. In addition the creators of the backupset have been evading my requests, I'm not sure why exactly but it appears to be business reasons. In other words this is what I have, I cannot get anything better than what I've got right now.

I have an Oracle enterprise server, with the data in a backup directory.
What is the proper way to proceed? Is it possible to duplicate from an auxiliary backup data TO a fresh blank database? Meaning, is it possible to use an auxiliary as a primary?

Best Answer

If you know the sid name, you can copy a pfile over and edit it to change the values to match the database name. Make sure that you set B_CREATE_FILE_DEST to where you want the data files.

Then do a startup nomount on the database. In RMAN do "CATALOG START WITH '/full_path_to_your_backup';" You can then use DB_FILE_NAME_CONVERT to convert the file names to be in the right directory.

You can then try to restore a control file. try list backup; and restore the oldest control file. Mount the database and try to restore the database.

It could be that the reason why the people who gave you the backup are avoiding you is because they know the backup is incomplete. But you have to try to restore what you can, then at least when you go back to them you can ask a more specific question.

Related Solutions

How to have RMAN treat the restored data files like they are originals

Issue switch to copy, then crosscheck.

Duplicating a Database with RMAN

If my source database uses SPFILE then do I have create a PFILE from the SPFILE?

Yes, you need to create a temporary PFILE to use while duplicating the database. You will later switch the new instance to use the SPFILE.

Use

CREATE PFILE = 'path/to/pfile' FROM SPFILE;

You only need to create directories that are referenced in the PFILE or SPFILE. Which directories need to be created?

You will start the database as NOMOUNT to begin the duplication. This means the controlfiles will not be read, and so you don't need to have the directories in which the datafiles reside present in your new host. However, the directories references in the parameter files must be present. From your transcript,

DB11G.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
*.audit_file_dest='/u01/app/oracle/admin/DB11G/adump' 
*.control_files='/u01/app/oracle/oradata/DB11G/control01.ctl','/u01/app/oracle/oradata/DB11G/control02.ctl'#Restore Controlfile
*.db_recovery_file_dest='/u01/app/oracle/fra'
*.diagnostic_dest='/u01/app/oracle'
*.log_archive_dest_1='location=/u01/app/oracle/archive_logs'

You may find this chapter of the documentation useful: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#i1006474

Best Answer

Related Solutions

How to have RMAN treat the restored data files like they are originals

Duplicating a Database with RMAN

Related Question