Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Any way to generate archive logs for single redo logs?

User_XLWLBFeb 9 2023

For nonarchivelog db's why cant you run an ‘alter system something..’ and for every redolog switch it does afterwards it writes out a matching archive log file? Start that with a backup and turn it off afterwards and you would capture all the transactions needed for recovery even with the db open..

Or.. any chance that there's an RMAN command that writes out redologs as archive logs?

Thanks

Comments
Post Details
Added on Feb 9 2023
2 comments
248 views