WHat backup are you using to clone?
IF it's a cold backup, you would never require the redo logs at all.
IF it's a hot backup, you will anyway use adcfgclone.pl dbTechStack followed by manual recovery of database where you can create control file and keep all files in one location and simply recover.
Yes its a cold backup, and I understand about redo logs. Yet I need to tell the clone at some point about the changed location of the redo logs.
My feeling is that specifying 2 data tops will be enough - yet my question remains:
Number of DATA_TOP's on the Target System  :
If I enter "2", then give the path to the datafiles for 1, then the path to the redo logs for 2, is that all I need to do?
Control file will get created with this information, and the db will start, and those redo logs are going to written to. Or is there an additional step / preliminary step to take?
The best way for you is to split dbTechStack and manually bring up database with your own controlfile.
- Run adcfgclone.pl dbTechStack (Do not worry about DATA_TOP locations at all as you will be bringing up Database Manually)
- Create Control File script with required locations
- Startup mount
- alter database open resetlogs
- sqlplus '/ as sysdba' @$ORACLE_HOME/appsutil/install/[CONTEXT NAME]/adupdlib.sql
- adcfgclone.pl dbConfig
You are done. Alternatively, specify all the locations of files including Redolog files and run it. Above process will be 100% successful in all the occasions including Hot Backup.
This is not a hot backup.
Now that I have specified x2 DATA_TOPs in adcfgclone, once the clone is complete, I mount the db and use alter database rename file to change the location of redologs in database then reopen the instance.
Sadly, I now how x2 control files in the second DATA_TOP!
I think I made a mistake - there is no need to specify in DATA_TOP the second location of redo logs. I think all is needed is to use the alter database rename file command to update the data dictionary with new location . It will then be saved to control file.
Does anyone else agree or disagree?
Control File locations doesn't matter. Keep whatever you want to keep in PFILE CONTROL_FILES and remove others. Whatever Control File location you specify in pfile, specify those locations in the DATA_TOP.
As I told before, even if its cold backup and you are worrying about recovery/restore, Run dbTechStack and simply connect "sqlplus '/as sysdba' and start database with resetlogs. Ensure control file has all locations of Data Files and RedoLogs. Then run dbConfig.