Invention Grant
- Patent Title: Forceful closure and automatic recovery of pluggable databases in a shared-everything cluster multitenant container database
-
Application No.: US15014969Application Date: 2016-02-03
-
Publication No.: US09928147B2Publication Date: 2018-03-27
- Inventor: Yunrui Li , Chi Cao Minh , Wilson Chan , Tolga Yurek , Ping-Hsiu Hsieh
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F11/14
- IPC: G06F11/14 ; G06F17/30

Abstract:
Embodiment provide that each pluggable database (PDB) in a container database is associated with a distinct distributed lock manager (DLM) domain. Thus, in order to access a PDB, a database server instance joins the DLM domain for the PDB. To perform actions on the PDB, the instance secures locks that belong to the DLM domain for the particular PDB. As such, buffers storing data for the PDB may be managed separately from buffers storing data for other PDBs using the PDB-specific DLM domains. An instance forcefully closing a particular PDB marks the DLM domain of the PDB as invalid, which allows detection of the forceful closure by a recovery instance. Detection of an invalid DLM domain by an instance causes the instance to automatically recover the PDB by accessing pertinent ranges of redo logs and replaying changes made to data blocks for the PDB indicated in the logs.
Public/Granted literature
Information query