WAL batch management method, system and device and storage medium

The invention relates to a WAL batch management method, system and device and a storage medium. The method comprises a method for removing the WAL and a method for recovering the WAL, and the method for removing the WAL comprises the following steps of inquiring a WWID, accessing an SAN storage corresponding to the WWID, checking a control file of a database in the SAN storage, obtaining the WAL of a current database check point, and recording the WAL number of the WAL; obtaining a WAL list stored in the SAN storage; backing up and deleting the WALs in the SAN storage according to the specified number; the method for recovering the WAL comprises the following steps of: querying a WWID, and obtaining a list of the WAL stored in a temporary storage directory; and recovering the WAL from the temporary storage directory to the SAN storage according to the specified number. Compared with the prior art, the method has the advantages that on the basis of a single WAL moving command, the functions of protecting datab