In this example, we are setting up automatic snapshot maintenance for the backup01 share. We are instructing the ZFS Storage Appliance to perform a daily snapshot of the backup01 share on a nightly basis at 1AM. We are also instructing the ZFS Storage Appliance to keep 21 days of rolling snapshots.

zfs1:> shares
zfs1:shares (zpool1)> select default
zfs1:shares (zpool1) default> select backup01
zfs1:shares (zpool1) default/backup01> snapshots
zfs1:shares (zpool1) default/backup01 snapshots> automatic

zfs1:shares (zpool1) default/backup01 snapshots automatic> create
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> show
Properties:
                     frequency = (unset)
                           day = (unset)
                          hour = (unset)
                        minute = (unset)
                          keep = 0

zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set frequency=day
                     frequency = day (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set hour=03
                          hour = 01 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set minute=00
                        minute = 00 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> set keep=21
                          keep = 21 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> get
                     frequency = day (uncommitted)
                           day = (unset)
                          hour = 01 (uncommitted)
                        minute = 00 (uncommitted)
                          keep = 21 (uncommitted)
zfs1:shares (zpool1) default/backup01 snapshots automatic (uncommitted)> commit
zfs1:shares (zpool1) default/backup01 snapshots automatic> show
Properties:
                       convert = true

Automatics:

NAME                 FREQUENCY            DAY                  HH:MM KEEP
automatic-000        day                  -                    03:00   21

zfs1:shares (zpool1) default/backup01 snapshots automatic> done
zfs1:shares (zpool1) default/backup01 snapshots> show
Snapshots:
                       oct2014
                      sept2014

Children:
                        automatic => Configure automatic snapshots


We will post the 10th session shortly …

Session #

Title

Room Assignment and Time

604

Rolling your own Database Operations Center (DOC) using Oracle Technology you already own

Mile High Ballroom 2A => Mon, Apr 08, 2013 (09:45 AM – 10:45 AM)

344

Performance Tuning your DB Cloud in OEM 12c Cloud Control – 360 Degrees

Mile High Ballroom 4A  => Mon, Apr 08, 2013 (09:45 AM – 10:45 AM)

614

Automate Data Guard Best Practices

Mile High Ballroom 2B => Mon, Apr 08, 2013 (05:00 PM – 06:00 PM)

 

 

 

477

Why Every Database Needs to be Virtualized

Mile High Ballroom 4A => Tue, Apr 09, 2013 (12:00 PM – 12:30 PM)

343

Oracle VM, OEM 12c and Cloud Computing:  Panel of Experts

C#13 vSIG Meeting => Tue, Apr 09, 2013 (4:15 PM – 5:15 PM)

 

 

 

441

ASM New Features – The New ASM Frontier

Mile High Ballroom 2C => Wed, Apr 10, 2013 (08:15 AM – 09:15 AM)

414

Engineered Systems Curriculum: The Perfect Marriage: ZFS Storage Appliance with Exadata

Mile High Ballroom 1C => Wed, Apr 10, 2013 (11:00 AM – 12:00 PM)

783

Virtualized Oracle Stretched RAC Cluster using VMware vSphere and EMC VPLEX

Mile High Ballroom 2A => Wed, Apr 10, 2013 (04:15 PM – 05:15 PM)

 

 

 

757

From Big Data to Exadata: The Best of Both Worlds for Business Analytics

Mile High Ballroom 1B => Thu, Apr 11, 2013 (09:45 AM – 10:45 AM)

 

 

 


For RMAN Backups to disk (D2D) with ZFS Storage Appliance, you need to review MOS Note:  1072545.1: RMAN Performance Tuning Using Buffer Memory Parameters.  
 
You can effectively optimize high-bandwidth low latency backups and restores using Oracle RMAN and the Sun ZFS Storage Appliance by adjusting the init.ora parameters that control I/O buffering.

For Oracle Exadata, you can tune the following four parameters:
• _backup_disk_bufcnt – Number of buffers used to process backup sets
• _backup_disk_bufsz – Size of the buffers used to process backup sets
• _backup_file_bufcnt – Number of buffers used to process image copies 
• _backup_file_bufsz – Size of the buffers used to process image copies

For backup operations, set the buffer size to 1 MB for backup sets and 4 MB for image copies.  Form RMAN image copies, use the following settings: 

For database restores, the buffer size should be set to 128 kB as shown below:

For RMAN database backup sets and image copies, set the number of buffers for backup sets and image copies to 64:




If you are going to be at Oracle OpenWorld this year, please stop by and say Hi ..

Here’s all the sessions that I will be a presenter or a panelist at:

UGF4410
The Perfect Marriage: Oracle Exadata with Sun ZFS Storage Appliance
Session ID: UGF4410
Sunday 30-SEP-2012 9:00AM
Moscone West – 2018

UGF7700
Session Title: Oracle on Oracle VM: Expert Panel
Venue / Room: Moscone West – 2012
Date and Time: Sunday – 9/30/12, 12:30 – 14:00

UGF6511
Database Performance Tuning: Get the Best out of Oracle Enterprise Manager 12c Cloud Control
Sunday, Sep 30, 2:15 PM – 3:15 PM
Moscone West – 2011

CON8435
Expert Customer Panel:
Exadata Data Protection Best Practices
Session ID: CON8435
10/1/12 (Monday) 12:15 PM
Moscone South – 252

 

Charles Kim Presentation at OOW 2012