SAP Note 434645 - Point-in-time recovery: What must I be aware of?

Component : Basis Components - liveCache

Solution : https://service.sap.com/sap/support/notes/434645 (SAP Service marketplace login required)

Summary :
Due to database errors, hardware malfunctions, or operational mistakes, users may consider performing point-in-time (PIT) recovery of databases to an earlier state. This involves using data backups and redo log information, stopping before all redo logs are applied to revert the database to a previous state without using the latest data. Results include potentially significant data loss and inconsistencies across interconnected systems, which can disrupt business processes due to conflicting or duplicated data in systems like ERP and CRM. SAP strongly recommends against PIT recovery for production systems, suggesting alternatives such as using snapshots or complete recovery from backups. Errors should be analyzed and corrected using system-specific check reports, and any recovery operations should be cautiously managed to avoid further inconsistencies.

Key words :
makt physical matchcode tables secondary index tables, system automatically rolls back, ensure thatthe production system, incomplete recovery include restoring, hard disk prevents, practice document provided, current online logs, importing incorrect transports 5, adequate backup concept, regular restore tests

Related Notes :

1420452FAQ: Restore and recovery with MS SQL Server
1297986Backup and Restore strategy for MS SQL Server
1038709FAQ: SAP MaxDB/liveCache OneDB
966117Oracle Flashback Database technology
952783FAQ: MaxDB high availability
820824FAQ: SAP MaxDB/liveCache technology
605062FAQ: Restore and recovery
533999Restore Until with a Unicode database terminates
445814DBMGUI and Restore Until
438820Point-in-time recovery in the ALE environment
434647Point-in-time recovery in an SAP system group
425825Consistency checks, /sapapo/om17, /sapapo/cif_deltareport
365481Block corruptions
363602New Compare monitor - Request for Compare
319332Content Server backup strategies
31496CC-INFO: Client deleted by mistake