This content has been marked as final. Show 3 replies
Hello;1 person found this helpful
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 :
Autobackup is not available but controlfile backupset is available
RMAN>RESTORE CONTROLFILE FROM '/backup_dir/piece_name';
If you can find the control file this may help :
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;
RMAN recovery to a different server when nocatalog is available
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 http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642
NewbieI 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 !!
Status Level: Newbie (25)
Registered: Sep 6, 2010
Total Posts: 272
Total Questions: 154 (123 unresolved)
Occupation Junior DBA
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.