user12045405 wrote:Why are we even discussing user mangaged backups (ALTER ... BEGIN BACKUP; ALTER .... END BACKUP;)?
Also it might be the controlfile backup is older than ur datafile backup..So when u take a new hot backup things to keep in mind
alter tablespace <tablespace_name> begin backup;
copy all datafiles belonging to this tablespace.
alter tablespace <tablespace_name> end backup;
once all this is done now take a controlfile backup.
user12045405 wrote:On further review, I see that the OP was doing and ALTER DATABASE (not ALTER TABLESPACE) and splitting the mirror. I've not had any first hand experience with this type of backup but understand it is a rather common way to take a quick backup of very large databases. Since I've never used it I'm not sure of the requirements for actually using the backup for recover/restore. But am willing to concede that this might be one legitimate reason to not use rman .. or at least in addition to rman.
True what you are saying.
But the discussion just went according to his requirement.