You Asked
Hi Team,
i restored database to another server using RMAN backups and Archived logs, database restored fine, my question is i wanted to also restore data of unarchived online redolog files also ? how can i include unarchived online redolog files in recovery process ? incase there is disaster and online redolog files was not archived yet.
i also put online redo log file into the folder with backup/archived log files, but when i cataloged the folder with RMAN, RMAN gave following error.
List of Files Which Where Not Cataloged
=======================================
File Name: /home/oracle/backup/2022_09_21/redo03.log
RMAN-07529: Reason: catalog is not supported for this file type
Following is the spool of the recovery.
https://drive.google.com/file/d/1igqswnwLkxvfGNltO7j4ZlAgnyIKRSin/view?usp=sharing
and Connor said...
If you want to restore unarchived redo logs from an active system, then you need to archive them.
If preservation of the redo logs is essential during a disaster, then you should be looking at DataGuard which can real time transfer online redo to an alternate database/location, or the zero data loss recovery appliance which in effect does a similar thing, ie, redo changes are shipping in real time to a safe location.
If you had a disaster on your current system *and* you still had the *current* control files and the redo logs, then copying them to a new server and then restoring the datafiles + archived redo from backup should allow for a complete recovery because the control file will know the recovery SCN and continue on through the archived redo and onto the current redo. (You would open the database with noresetlogs in this case)
If you're just looking at cloning an existing database to be as up to date as possible, then DUPLICATE FROM ACTIVE is probably the easiest way to go.
Is this answer out of date? If it is, please let us know via a Comment