Instantaneous unplug of pluggable database from one container database and plug into another container database
    1.
    发明授权
    Instantaneous unplug of pluggable database from one container database and plug into another container database 有权
    从一个容器数据库中即时拔出可插拔数据库,并插入另一个容器数据库

    公开(公告)号:US09396220B2

    公开(公告)日:2016-07-19

    申请号:US14202091

    申请日:2014-03-10

    CPC classification number: G06F17/303 G06F17/30371 G06F17/30575

    Abstract: A pluggable database is transported between a source DBMS and a destination DBMS, in a way that minimizes downtime of the pluggable database. While a copy of the pluggable database is being made at the destination DBMS, transactions continue to execute against the pluggable database at the source DBMS and change the pluggable database. Eventually, the transactions terminate or cease executing. Redo records generated for the transactions are applied to the copy of the pluggable database at the source DBMS. Undo records generated for at least some of the transactions may be stored in a separate undo log and transported to the destination DBMS. The transported pluggable database is synchronized at a destination DBMS in a “pluggable-ready state”, where it may be plugged into the destination container DBMS.

    Abstract translation: 可插拔数据库在源DBMS和目标DBMS之间传输,从而最大限度地减少可插拔数据库的停机时间。 虽然目标DBMS正在进行可插拔数据库的副本,但是事务将继续针对源DBMS上的可插拔数据库执行,并更改可插拔数据库。 最终,交易终止或停止执行。 为事务生成的重做记录应用于源DBMS的可插拔数据库的副本。 至少为某些事务生成的撤销记录可以存储在单独的撤销日志中,并传送到目标DBMS。 传输的可插拔数据库在目标DBMS上以“可插拔就绪状态”进行同步,可以插入到目标容器DBMS中。

    Techniques for moving data files without interrupting access
    2.
    发明授权
    Techniques for moving data files without interrupting access 有权
    移动数据文件而不中断访问的技术

    公开(公告)号:US09189502B2

    公开(公告)日:2015-11-17

    申请号:US13630582

    申请日:2012-09-28

    CPC classification number: G06F17/303

    Abstract: Techniques for moving data files without interrupting access are described. A first process moves a database file from a first location to a second location while the database file is accessible to one or more other processes for read or write operations. According to one technique, the first process communicates a move status and a copy range into the database file to one or more database server instances executing the one or more other processes. The one or more other processes then perform input/output (IO) operations on the database file based at least in part on the move status and the copy range communicated by the first process.

    Abstract translation: 描述了在不中断访问的情况下移动数据文件的技术。 第一个进程将数据库文件从第一个位置移动到第二个位置,而数据库文件可被一个或多个其他进程访问以进行读取或写入操作。 根据一种技术,第一过程将移动状态和复制范围传达到数据库文件中,以执行一个或多个其他进程的一个或多个数据库服务器实例。 所述一个或多个其他进程至少部分地基于由第一进程传送的移动状态和复制范围对数据库文件执行输入/输出(IO)操作。

    TIME-BASED CHECKPOINT TARGET FOR DATABASE MEDIA RECOVERY
    3.
    发明申请
    TIME-BASED CHECKPOINT TARGET FOR DATABASE MEDIA RECOVERY 审中-公开
    基于时间的检查点目标数据库媒体恢复

    公开(公告)号:US20150317212A1

    公开(公告)日:2015-11-05

    申请号:US14270117

    申请日:2014-05-05

    Abstract: A method, apparatus, and system for a time-based checkpoint target is provided for standby databases. Change records received from a primary database are applied for a standby database, creating dirty buffer queues. As the change records are applied, a mapping is maintained, which maps timestamps to logical times of change records that were most recently applied at the timestamp for the standby database. On a periodic dirty buffer queue processing interval, the mapping is used to determine a target logical time that is mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay. The dirty buffer queues are then processed up to the target logical time, creating an incremental checkpoint. On a periodic header update interval, file headers reflecting a consistent logical time for the checkpoint are also updated. The intervals and the checkpoint delay are adjustable by user or application.

    Abstract translation: 为备用数据库提供了基于时间的检查点目标的方法,装置和系统。 将从主数据库接收的更改记录应用于备用数据库,从而创建脏缓冲区队列。 随着应用更改记录,维护映射,将时间戳映射到最近在备用数据库的时间戳处应用的更改记录的逻辑时间。 在周期性的脏缓冲器队列处理间隔上,该映射用于确定映射到当前时间戳之前至少一个检查点延迟的目标时间戳的目标逻辑时间。 然后将脏缓冲区队列处理到目标逻辑时间,创建一个增量检查点。 在周期性头文件更新间隔中,还会更新反映检查点一致逻辑时间的文件头。 间隔和检查点延迟可由用户或应用程序调整。

    Instantaneous Unplug of Pluggable Database From One Container Database and Plug Into Another Container Database
    4.
    发明申请
    Instantaneous Unplug of Pluggable Database From One Container Database and Plug Into Another Container Database 有权
    从一个容器数据库中即时拔下可插拔数据库,并插入另一个容器数据库

    公开(公告)号:US20150254240A1

    公开(公告)日:2015-09-10

    申请号:US14202091

    申请日:2014-03-10

    CPC classification number: G06F17/303 G06F17/30371 G06F17/30575

    Abstract: A pluggable database is transported between a source DBMS and a destination DBMS, in a way that minimizes downtime of the pluggable database. While a copy of the pluggable database is being made at the destination DBMS, transactions continue to execute against the pluggable database at the source DBMS and change the pluggable database. Eventually, the transactions terminate or cease executing. Redo records generated for the transactions are applied to the copy of the pluggable database at the source DBMS. Undo records generated for at least some of the transactions may be stored in a separate undo log and transported to the destination DBMS. The transported pluggable database is synchronized at a destination DBMS in a “pluggable-ready state”, where it may be plugged into the destination container DBMS.

    Abstract translation: 可插拔数据库在源DBMS和目标DBMS之间传输,从而最大限度地减少可插拔数据库的停机时间。 虽然目标DBMS正在进行可插拔数据库的副本,但是事务将继续针对源DBMS上的可插拔数据库执行,并更改可插拔数据库。 最终,交易终止或停止执行。 为事务生成的重做记录应用于源DBMS的可插拔数据库的副本。 至少为某些事务生成的撤销记录可以存储在单独的撤销日志中,并传送到目标DBMS。 传输的可插拔数据库在目标DBMS上以“可插拔就绪状态”进行同步,可以插入到目标容器DBMS中。

    Techniques to parallelize CPU and IO work of log writes

    公开(公告)号:US10706009B2

    公开(公告)日:2020-07-07

    申请号:US13831489

    申请日:2013-03-14

    Abstract: Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a system, log data is stored in one or more buffers. In response to receiving a request to perform a logical write, a first process writes a first portion of the log data to a log file in persistent storage. While the first portion of the log data is being written to the log file, a second process writes a second portion of the log data in the one or more buffers to the log file in persistent storage. In another embodiment, a request to perform a second logical write may be received before the first logical write completes. While the first log data is being written to the log file, one or more processes write second log data for the second logical write to the log file.

    Time-based checkpoint target for database media recovery

    公开(公告)号:US10152396B2

    公开(公告)日:2018-12-11

    申请号:US14270117

    申请日:2014-05-05

    Abstract: A method, apparatus, and system for a time-based checkpoint target is provided for standby databases. Change records received from a primary database are applied for a standby database, creating dirty buffer queues. As the change records are applied, a mapping is maintained, which maps timestamps to logical times of change records that were most recently applied at the timestamp for the standby database. On a periodic dirty buffer queue processing interval, the mapping is used to determine a target logical time that is mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay. The dirty buffer queues are then processed up to the target logical time, creating an incremental checkpoint. On a periodic header update interval, file headers reflecting a consistent logical time for the checkpoint are also updated. The intervals and the checkpoint delay are adjustable by user or application.

    Time-based checkpoint target for database media recovery

    公开(公告)号:US11048599B2

    公开(公告)日:2021-06-29

    申请号:US16215046

    申请日:2018-12-10

    Abstract: A method, apparatus, and system for a time-based checkpoint target is provided for standby databases. Change records received from a primary database are applied for a standby database, creating dirty buffer queues. As the change records are applied, a mapping is maintained, which maps timestamps to logical times of change records that were most recently applied at the timestamp for the standby database. On a periodic dirty buffer queue processing interval, the mapping is used to determine a target logical time that is mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay. The dirty buffer queues are then processed up to the target logical time, creating an incremental checkpoint. On a periodic header update interval, file headers reflecting a consistent logical time for the checkpoint are also updated. The intervals and the checkpoint delay are adjustable by user or application.

    TIME-BASED CHECKPOINT TARGET FOR DATABASE MEDIA RECOVERY

    公开(公告)号:US20190108107A1

    公开(公告)日:2019-04-11

    申请号:US16215046

    申请日:2018-12-10

    Abstract: A method, apparatus, and system for a time-based checkpoint target is provided for standby databases. Change records received from a primary database are applied for a standby database, creating dirty buffer queues. As the change records are applied, a mapping is maintained, which maps timestamps to logical times of change records that were most recently applied at the timestamp for the standby database. On a periodic dirty buffer queue processing interval, the mapping is used to determine a target logical time that is mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay. The dirty buffer queues are then processed up to the target logical time, creating an incremental checkpoint. On a periodic header update interval, file headers reflecting a consistent logical time for the checkpoint are also updated. The intervals and the checkpoint delay are adjustable by user or application.

Patent Agency Ranking