Database Backup and Recovery (MOSC)

MOSC Banner

Oracle 19c Standard running on Windows 2019 Server

I run a pl sql script to recover a stand by database.

I use the following to do so:

alter session set container = CDB$ROOT;

set autorecovery on;

alter database recover automatic standby database until cancel;

alter database recover cancel;

This is a stand by database so how can I tell if all the files in the archive folder have been processed successfully in an automated way. I just want to be able to delete the archive files after they been successfully recovered from the scheduled job I run.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center