OK. Now I have several problems. And maybe learn new stuff too.
There are 1 new db and the old one, with the old ID that I want to replace. The new db full backup is around 3 gig, but full backup with archive log is around 12 gig. This is because there are around 3 month worth of archive log.
The old one can't be opened, it gives this error
ORA-10458: standby database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DRDATA1/dsgkles/datafile/system.326.837647047'
This is causing active standby duplication won't work.
How do I make above database can be opened? Note, I doesn't need the db anymore and it will be replaced. It uses ASM, but ASM can't be used (another story).
There is two data base. New and old.
The new one can't be opened due to full FRA with 3 month worth of archive log. The old one can be opened. The problem here is that the SYS and SYSTEM password have been changed, its not the same between those two (hence 3 month worth of archive log), and nobody knows it. Can sign in and mouth with / as sysdba, but since it can't be opened, no ALTER or changing password.
Full db backup is around 3 gig, but full backup with archive log is more than 13 gig obviously, the space just filled and rman stopped.
So, if I plan to rebuild the old db, do I need to backup with archivelog, or just full backup only?
I managed to duplicate using active db. Now I'm trying to make DR work. Been googling around, but none with clear answer. Oracle source is too much text and parameters info but lack of sample code. Sad really.