This content has been marked as final. Show 7 replies
I am using filesystem for storing datafiles on target.no issue,use SET NEWNAME FOR DATAFILE 1 to /file_system/dbf_filename
Please close the thread if you feel you have the answer and keep the Oracle forum clean.
RMAN does support duplication from ASM to NON ASM and vice versa.
However you have to "rename" the datafiles and the Spfile parameters during the restore.
Otherwise RMAN tries to recover to the same directory/directory structure:
spfile PARAMETER_VALUE_CONVERT '<diskgroup>','<path>'
set LOG_FILE_NAME_CONVERT '<diskgroup>,'<path>'
set DB_FILE_NAME_CONVERT '<diskgroup>','<path'>
Another option would be to use
'set newname for database' to replace pathes.
Here is my pfile from target database. i used db_file_name_convert,log_file_name_convert. On source we have flash recovery area configured on diskgroup +flash. Where as on target i decided not to use flash recovery area. Is this related to my problem.
In my source database controlfile autobackup was configured to go in to flash destination. So whenever i run source database backup into '/oracle/backup' location automatically at the end of backup control file autobackup is getting generated into flash with highest SCN than the current controlfile backup created as part of backup. So i disabled controlfile autobackup,taken fresh backup copy of source and tried the cloning and it worked well for me.
My only doubt is when i allocated auxiliary channel to backup location why rman is looking for most recent backup of controlfile.