Dear Experts.
Please request your support, as all the datafiles in my Production Database have fuzzy status.
This situation has caused me problems, since I tried to restore a Backup Full RMAN corresponding to this database on another server, but when I try to make recover database, I requested very old archiveslogs that no longer exist in Production Database.
I have tried to make a recover database until sequence, but it does not work, although I am restoring the controlfile of the most recent autobackp in the Production Database, but it generates multiple errors. And I suppose it is associated with the production datafiles, it has the Fuzzy = YES status. I would like to consult them, if there is a procedure to solve the status of datafiles in production and thus not have problems when performing a Backup / Restore.
The errors registered in the alert.log during the restore are as follows:
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 5 from a fuzzy file. If not the current file
ALTER DATABASE OPEN RESETLOGS
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
Thank you.