Patent ID: 9684566
Date: 2017-06-20
CPC Classifications: G06F

Claim:
1. A method comprising: storing, by a container database, redo records for multiple particular pluggable databases, wherein the multiple pluggable databases include a particular pluggable database; in response to detecting that a first read-write instance of the particular pluggable database is opened and that no other read-write instances of the particular pluggable database are open, updating offline range data associated with the particular pluggable database to indicate that the particular pluggable database becomes active at a first logical timestamp; in response to detecting that a second read-write instance of the particular pluggable database is closed and that the second read-write instance was a last open read-write instance of the particular pluggable database, updating the offline range data associated with the particular pluggable database to indicate that the particular pluggable database becomes inactive at a second logical timestamp; restoring the particular pluggable database to a restore point based on redo records stored by the container database that are associated with a logical timestamp outside of one or more offline ranges indicated by the offline range data; and wherein the method is performed by one or more computing devices.