最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

Oracle教程:快照控制文件

来源:动视网 责编:小采 时间:2020-11-09 11:39:10
文档

Oracle教程:快照控制文件

Oracle教程:快照控制文件:The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consisten The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consis
推荐度:
导读Oracle教程:快照控制文件:The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consisten The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consis


The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consisten

The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consistent version of the control file. RMAN only needs a snapshot control file when re-synchronizing with the recovery catalog or when making a backup of the current control file. In Oracle RAC, the snapshot control file is only needed on the nodes on which RMAN performs backups; the snapshot control file does not need to be globally available to all instances in an Oracle RAC environment.

RMAN仅当以下情况下需要快照控制文件:1.同步恢复目录时2.对当前控制文件进行备份时。在RAC环境下,,仅仅在实施RMAN备份的节点上需要快照控制文件;因此快照控制文件是不需要在所有实例上全局可用的。

You can specify a cluster file system file or a raw device destination for the location of your snapshot control file.

你同样可以使用共享文件系统或裸设备指定快照控制文件的位置。

Run the following RMAN command to determine the configured location of the snapshot control file:

SHOW SNAPSHOT CONTROLFILE NAME;

You can change the configured location of the snapshot control file. For example, on UNIX-based systems you can specify the snapshot control file location as $ORACLE_HOME/dbs/scf/snap_prod.cf by entering the following at the RMAN prompt:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$ORACLE_HOME/dbs/scf/snap_prod.cf';

This command globally sets the configuration for the location of the snapshot control file throughout your cluster database. Therefore, ensure that the directory $ORACLE_HOME/dbs/scf exists on all nodes that perform backups.


如果快照控制文件配置在共享存储上时:
If one RMAN job is already backing up the control file while another needs to create a new snapshot control file, you may see the following message:

waiting for snapshot control file enqueue

Under normal circumstances, a job that must wait for the control file enqueue waits for a brief interval and then successfully retrieves the enqueue. Recovery Manager makes up to five attempts to get the enqueue and then fails the job. The conflict is usually caused when two jobs are both backing up the control file, and the job that first starts backing up the control file waits for service from the media manager.

这样看来,每个实例使用自己的快照控制文件可以避免以上问题。

配置实例:

[sql]

文档

Oracle教程:快照控制文件

Oracle教程:快照控制文件:The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consisten The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consis
推荐度:
标签: 文件 数据 oracle
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top