Oracle RMAN 通道和并行度的配置过程包括指定 Oracle RMAN 备份通道的文件系统目标以及用于备份和恢复操作的总通道数。可通过在所有可用 ZFS Storage Appliance 共享资源上配置 16 个 Oracle RMAN 通道来实现性能优势。配置 Oracle RMAN 通道,将它们平均分配到 Oracle 数据库实例和 RAC 群集中的节点上,并且平均分配到从 ZFS Storage Appliance 中导出的共享资源上。
以下代码片段显示了针对备份集和映像副本执行备份和恢复操作以及将增量合并应用到映像副本的 Oracle RMAN 运行块样例。此样例代码基于以下数据库配置:
数据库名称:dbname
SYSDBA 登录名:sys/welcome
扫描地址:ad01-scan
备份的服务名称:dbname_bkup
可在单池配置中配置 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; }