Home » RDBMS Server » Backup & Recovery » Database duplication
Database duplication [message #238276] Thu, 17 May 2007 05:12 Go to next message
coolbalaga
Messages: 24
Registered: September 2006
Junior Member
Hello,
Iam trying to duplicate the database but I am getting the below error :
<---
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename C:\ORACLE\ORAHOME_1\FLASH_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_3_34P3FCHN_.LOG conflicts with a file used by the target database
...
--->

I have executed the steps mentioned in the "http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmdupdb.htm#441879"

and used the below rman command:
run {
allocate channel ...
duplicate target database to 'DUPORCL';
}
I have not used the "CONFIGURE AUXNAME " or the "Set newname".

Want to know is there any pfile parameter like db_file_name_convert or log_file_name_convert for the flash recovery area online log ??

Need your help.

~ Balu

Re: Database duplication [message #238337 is a reply to message #238276] Thu, 17 May 2007 07:49 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

YOu must set db_file_name_convert or log_file_name_convert parameter is you create duplicate database on some machine.

http://dbataj.blogspot.com/2006/12/duplicating-database-with-recovery.html


flash recovery area online log ??


flash recovery area configure through two parameters
1.db_recovery_file_dest
2.db_recovery_file_dest_size


and log file created "db_recovery_file_dest" parameter location.

Regards
Taj
Previous Topic: DB duplication - RMAN-06025 missing archive logs
Next Topic: database cloning using rman
Goto Forum:
  


Current Time: Sat Nov 30 03:10:26 CST 2024