Restore/Recover-Performance of Logs saved via archive_stage

[former_member272646]

Hello,

we discovered when doing system-copies of our LiveCache-OneDB-Systems with point-in-time-recovery including many Logs a bad Log-Recovery-Performance. The Logs were saved with archive_stage.

The logs are read directly via pipe from our networker-Server and applied through this pipe.

There is no possibility to restore Logs in parallel to file system and do the recover afterwards like Oracle-Rman.

So, there is a discussion under way to look for another solution for doing log-Backups; substitue the archive_stage-Log-Backup with a own written script. But this is no Maxdb-Standard.

Is there a possibility to accelearate the Log-Recovery of Logs saved via archive_stage?

Regards

Thomas

[markus_doehr2]

> The logs are read directly via pipe from our networker-Server and applied through this pipe.

Are you using a tape backup? Means, are those logs saved on tape?

Markus

[former_member272646]

Hi,

the log-backups are stored with archive_stage to tapes on our networker server.

Regards

Thomas

[markus_doehr2]

> the log-backups are stored with archive_stage to tapes on our networker server.

And here comes the problem.

Tapes are known to be slow if they can't "stream" data. If they have to interrupt, rewind and read again you'll loose quite a lot of time waiting for the data to arrive and hence the restore is very slow.

I would use an archive_stage directory and save the files from there to tape - and recover them from files which is much faster.

Markus

[former_member272646]

This means no use of archive_stage; save of archivedLogs via an own script.

Are there scripts from SAP which can be used?