Well, the controlfiles and the data files do have a system change number (SCN) in the file headers and nearly every microsecond this scn is changing (don't want to bother you with internals). If you have more than one control file, all of these need to have the same SCN in the file headers and typically also the data files. What you should use is the recovery manager to duplicate the database to the new host (you can follow the cook book of oracle 11g): https://docs.oracle.com/cd/E28271_01/backup.1111/e10642/rcmdupdb.htm
Hello Joerg, thanks for the attention.
I can not use RMAN, it is for payment. Therefore, I modified the spfile with the most recent control file, using the instruction "alter system set control_files = '/ oracle / app / oracle / fast_recovery_area / msaproc / control03.ctl' scope = spfile;". I was able to solve this, and I was able to mount the database, however, now it gives me the following error "ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/sisrem/msaproc/system01.dbf' " I am currently investigating this error, my database is not in archive mode.
rman is free as part of the database, it is NEVER an extra cost option - I am doing licensing for Oracle software for over 20 years now.
If your database is not in an archive log running mode, all database files must be closed to get a consistent backup of the database - the error you get is again due to the different system change numbers in the data file headers -> inconsistency means media recovery.
So the only possibilty is to MOUNT the database (after a clean shutdown - so all SCN numbers are the same for the controlfiles and the data files), back it up with RMAN, or shut it down and copy/rsync/doing a fast snapshot at storage level and use the copy / the snapshot to create the new database.
Thanks Joerg, your information has been very useful to me.
Marco De la Fuente
@marco de la Fuente
You're welcome, please mark your question as answered then.