JavaScript is required to for searching.
  »  ... Oracle® ZFS Storage Appliance 管理指南  »  集成  »  配置 ZFS Storage Appliance 以便备份  »  配置 Oracle RMAN
跳过导航链接
退出打印视图
Oracle® ZFS Storage Appliance 管理指南
Oracle 技术网
文档库
PDF
打印视图
反馈
search filter icon
search icon

文档信息

使用本文档

 1 Oracle ZFS Storage Appliance 概述

 2 状态

 3 初始配置

 4 网络配置

 5 存储配置

 6 存储区域网络配置

 7 用户配置

 8 设置 ZFSSA 首选项

 9 警报配置

 10 群集配置

 11 ZFSSA 服务

 12 共享资源、项目和模式

 13 复制

 14 影子迁移

 15 CLI 脚本化

 16 维护工作流

 17 集成

Oracle Exadata Database Machine 备份

手动配置 Sun ZFS Storage Appliance

配置网络、池和共享资源

网络配置

基本网络配置

池配置

共享资源配置

配置 Oracle RMAN 和 Oracle 数据库实例

后续步骤

针对 Sun ZFS Storage Appliance 配置 Oracle Exadata

配置 Exadata：为 Sun ZFS Storage Appliance 配置 Oracle Exadata

大致实施步骤

具体实施步骤

设置在主机上挂载共享资源的目录结构

更新 /etc/fstab 文件

创建 init.d 服务

更新 oranfstab 以访问 ZFS Storage Appliance 导出

在主机上挂载共享资源

设置挂载共享资源的所有权

Oracle SPARC SuperCluster 备份

配置 ZFS Storage Appliance 以便备份

配置 ZFS Storage Appliance InfiniBand 数据链路

配置 Oracle SPARC SuperCluster InfiniBand 交换机以添加 ZFS Storage Appliance

为单个 IP 连接配置 ZFS Storage Appliance 网络

配置 ZFS Storage Appliance 网络以实现主动-主动配置

配置 ZFS Storage Appliance 存储池

配置 ZFS Storage Appliance 共享资源

配置 ZFS Storage Appliance DTrace Analytics

配置客户机 NFS 挂载

调整 Solaris 11 网络和内核

配置 Oracle Direct NFS (dNFS)

为 Oracle RMAN 备份和恢复操作调整 Oracle 数据库实例

为 Oracle RMAN 操作创建专用服务

配置 Oracle RMAN

后续步骤

为 ZFS Storage Appliance 备份配置 Oracle SPARC SuperCluster

配置 SSC：为 ZFS Storage Appliance 备份配置 Oracle SPARC SuperCluster

大致实施步骤

具体实施步骤

设置在主机上挂载共享资源的目录结构

更新 /etc/vfstab 文件

启用 NFS 客户机服务

更新 oranfstab 以访问 ZFS Storage Appliance 导出

在主机上挂载共享资源

设置挂载共享资源的所有权

Oracle Intelligent Storage Protocol

设置最佳的文件记录大小

为每个请求使用 ZFS Latency（延迟）或 Throughput（吞吐量）写入模式

适用于 Oracle Solaris Cluster 的 Sun ZFS Storage Appliance 网络文件系统插件

用于 Oracle Solaris Cluster Geographic Edition 的 Sun ZFS Storage Appliance 插件

适用于 Oracle Enterprise Manager Grid Control 的 Sun ZFS Storage 管理插件

适用于 Oracle Enterprise Manager Grid Controller 的 Oracle Grid Controller Sun ZFS Storage 管理插件

Configure for Oracle Enterprise Manager Monitoring（配置 Oracle Enterprise Manager 监视）

Unconfigure Oracle Enterprise Manager Monitoring（取消配置 Oracle Enterprise Manager 监视）

适用于 Sun ZFS Storage Appliance 的 Oracle 虚拟机存储连接插件

适用于卷影副本服务软件的 Sun ZFS Storage Appliance 提供程序

对 Symantec DMP/Storage Foundation 的 FC 支持

针对以下 OS 版本提供对 Symantec Storage Foundation 5.1RP2 及更高版本的 FC 支持

适用于 VMware Site Recovery Manager 的 Sun ZFS Storage 7000 Storage Replication Adapter

索引

配置 Oracle RMAN

Oracle RMAN 通道和并行度的配置过程包括指定 Oracle RMAN 备份通道的文件系统目标以及用于备份和恢复操作的总通道数。可通过在所有可用 ZFS Storage Appliance 共享资源上配置 16 个 Oracle RMAN 通道来实现性能优势。配置 Oracle RMAN 通道，将它们平均分配到 Oracle 数据库实例和 RAC 群集中的节点上，并且平均分配到从 ZFS Storage Appliance 中导出的共享资源上。

以下代码片段显示了针对备份集和映像副本执行备份和恢复操作以及将增量合并应用到映像副本的 Oracle RMAN 运行块样例。此样例代码基于以下数据库配置：

可在单池配置中配置 ZFS Storage Appliance，此设备将在此池中导出用作八个挂载点的八个共享资源。

以下各节中的示例显示了使用备份集和映像副本进行备份和恢复操作的 Oracle RMAN 运行块。在这些示例中，将把四个共享资源的配置的挂载点作为 /zfssa/dbname/backup1 到 /zfssa/dbname/backup4 进行访问。而且，在这些示例针对的配置中，ZFS Storage Appliance 导出四个共享资源，这些共享资源用作 16 个 Oracle RMAN 通道的四个挂载点。

备份集级别 0 备份： 

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   backup as backupset incremental level 0 section size 32g database<br/>
   tag ’FULLBACKUPSET_L0’ plus archivelog tag ’FULLBACKUPSET_L0’;    
}

备份集级别 1 备份： 

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   backup as backupset incremental level 1 database tag<br/>
   ’FULLBACKUPSET_L1’ plus archivelog tag ’FULLBACKUPSET_L1’;
}

映像副本备份： 

run
{<br/>
   sql ’alter system set "_backup_file_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   backup incremental level 1 for recover of copy with tag ’IMAGECOPY’<br/>
   database;    
}

增量合并到映像副本： 

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   recover copy of database with tag ’IMAGECOPY’;
}

恢复验证： 

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   restore validate database;
}
版权所有 © 2009, 2014, Oracle 和/或其附属公司。 保留所有权利。 法律声明
上一页 下一页