Now there is a demand, that is, delete oracle archive logs, but need to delete the record to the log file name, use rman can do, please? Check for a long time, I realized the rman delete command is removed at a time, if you want to achieve record delete file name, is to a directory traversal of a single delete operation? Is there any way to do it? Please god to give directions

CodePudding user response:

V $ARCHIVED_LOG this view can be seen

CodePudding user response:

Rman backup, let him to delete,
Do you want to manually delete?

CodePudding user response:

1. If it is the Windows operating system can:
Make the following processing in batch script
Rman target/log D: \ backup \ logs \ rman_ % date. The log cmdfile D: \ backup \ rman TXT
(where D: \ backup \ rman. TXT for rman scripts, D: \ backup \ logs to prevent rman execution record log directory)
That rman execution can check it on the log in detail, using the python or batch script can extract the archive log name,

2. If it is the Linux operating system can:
Spool is added in the ran the script path/rman log
After the execution spool off
Rman records will be recorded in the rman. Log in, the same with the shell or python can extract the archive log file name,