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.