-
公开(公告)号:US12008014B2
公开(公告)日:2024-06-11
申请号:US17389835
申请日:2021-07-30
Applicant: Oracle International Corporation
Inventor: Yunrui Li , Giridhar Ravipati , Ian Neall , Frank de Lange , Jing Zheng , Mahesh Girkar , David Gagne , Nitin Karkhanis , Sadhana Kyathappala , Qingguang Cui
CPC classification number: G06F16/27 , G06F11/1471 , G06F16/2358 , G06F16/2365 , G06F2201/82
Abstract: Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.
-
公开(公告)号:US11657037B2
公开(公告)日:2023-05-23
申请号:US15253780
申请日:2016-08-31
Applicant: Oracle International Corporation
Inventor: Vasudha Krishnaswamy , Yunrui Li , Vivekanandhan Raja , Tirthankar Lahiri , Mahesh B. Girkar , Sukhada Pendse , Kartik Kulkarni , Jing Zheng , Shruti Gautam , Henry Chau
CPC classification number: G06F16/2379 , G06F16/2322 , G06F16/2365 , G06F16/258 , G06F16/27 , G06F16/275
Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.
-
公开(公告)号:US10789131B2
公开(公告)日:2020-09-29
申请号:US15254884
申请日:2016-09-01
Applicant: Oracle International Corporation
Inventor: Kumar Rajamani , Muthu Olagappan , Yunrui Li , Giridhar Ravipati , Jing Zheng
Abstract: Techniques are provided for creating a backup of a source pluggable database (SPD) of a source container database and porting the backup for recovery into a different target container database. In an embodiment, a source database server retrieves metadata that describes backups of the SPD. The source database server inserts, into an unplugged pluggable database of the SPD, the metadata that describes each of the backups. For example, unplugging the SPD may automatically create the unplugged pluggable database. Eventually, the unplugged pluggable database may be plugged into the target container database. A target database server transfers the metadata that describes each of the backups from the unplugged pluggable database and into the target container database. Based on at least one backup and the metadata that describes backups of the SPD, the target database server restores a target pluggable database within the target container database.
-
公开(公告)号:US20170116252A1
公开(公告)日:2017-04-27
申请号:US15253780
申请日:2016-08-31
Applicant: Oracle International Corporation
Inventor: Vasudha Krishnaswamy , Yunrui Li , Vivekanandhan Raja , Tirthankar Lahiri , Mahesh B. Girkar , Sukhada Pendse , Kartik Kulkarni , Jing Zheng , Shruti Gautam , Henry Chau
IPC: G06F17/30
CPC classification number: G06F16/2379 , G06F16/275
Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.
-
公开(公告)号:US20240184803A1
公开(公告)日:2024-06-06
申请号:US18438154
申请日:2024-02-09
Applicant: Oracle International Corporation
Inventor: Yunrui Li , Giridhar Ravipati , Ian Neall , Frank Lange , Jing Zheng , Mahesh Girkar , David Gagne , Nitin Karkhanis , Sadhana Kyathappala , Qingguang Cui
CPC classification number: G06F16/27 , G06F11/1471 , G06F16/2358 , G06F16/2365 , G06F2201/82
Abstract: Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In an embodiment of a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.
-
公开(公告)号:US20230033806A1
公开(公告)日:2023-02-02
申请号:US17389835
申请日:2021-07-30
Applicant: Oracle International Corporation
Inventor: Yunrui Li , Giridhar Ravipati , Ian Neall , Frank Lange , Jing Zheng , Mahesh Girkar , David Gagne , Nitin Karkhanis , Sadhana Kyathappala , Qingguang Cui
Abstract: Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In an embodiment of a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.
-
公开(公告)号:US20200026609A9
公开(公告)日:2020-01-23
申请号:US15254884
申请日:2016-09-01
Applicant: Oracle International Corporation
Inventor: Kumar Rajamani , Muthu Olagappan , Yunrui Li , Giridhar Ravipati , Jing Zheng
Abstract: Techniques are provided for creating a backup of a source pluggable database (SPD) of a source container database and porting the backup for recovery into a different target container database. In an embodiment, a source database server retrieves metadata that describes backups of the SPD. The source database server inserts, into a unplugged pluggable database of the SPD, the metadata that describes each of the backups. For example, unplugging the SPD may automatically create the unplugged pluggable database. Eventually, the unplugged pluggable database may be plugged into the target container database. A target database server transfers the metadata that describes each of the backups from the unplugged pluggable database and into the target container database. Based on at least one backup and the metadata that describes backups of the SPD, the target database server restores a target pluggable database within the target container database.
-
公开(公告)号:US20180060181A1
公开(公告)日:2018-03-01
申请号:US15254884
申请日:2016-09-01
Applicant: Oracle International Corporation
Inventor: Kumar Rajamani , Muthu Olagappan , Yunrui Li , Giridhar Ravipati , Jing Zheng
Abstract: Techniques are provided for creating a backup of a source pluggable database (SPD) of a source container database and porting the backup for recovery into a different target container database. In an embodiment, a source database server retrieves metadata that describes backups of the SPD. The source database server inserts, into a unplugged pluggable database of the SPD, the metadata that describes each of the backups. For example, unplugging the SPD may automatically create the unplugged pluggable database. Eventually, the unplugged pluggable database may be plugged into the target container database. A target database server transfers the metadata that describes each of the backups from the unplugged pluggable database and into the target container database. Based on at least one backup and the metadata that describes backups of the SPD, the target database server restores a target pluggable database within the target container database.
-
-
-
-
-
-
-