Which two are Oracle recommendations for media based backups performed for a database
running on a Database Machine?
A.
Allocate equivalent number of channels and instances per tape drive.
B.
Perform periodic level 0 backups and daily cumulative level-1 backups.
C.
Use the InfiniBand network between the database server and media server.
D.
Configure Recovery Manager (RMAN) channels to connect to the least loaded instances.
E.
UseInfiniBand network between the media server and the storage servers.
Explanation:
A:Configure one RMAN channel per tape drive and add tape drives to scale backup rates.
C:Configure the Preferred Network Interface (PNI) to direct the Oracle Secure Backup
traffic over the InfiniBand network interface.
Example:
ob> lspni (List Preferred Network Interface)
mediaserver1:
PNI 1:
interface: mediaserver1-ib
clients: dbnode1, dbnode2, dbnode3, dbnode4,
dbnode5, dbnode6, dbnode7, dbnode8
PNI 2:
interface: mediaserver1
clients: adminserver
dbnode1:
PNI 1:
interface: dbnode1-ib
clients: mediaserver1
Note:
*Using the Sun ZFS Backup Appliance as an Oracle RMAN backup target for an Oracle Exadata
system delivers much faster backup and recovery, enabling organizations to achieveshorter
recovery time objectives and shrink backup windows. The appliance is designed for high sustained
read and write I/O performance, and it is connected to the Oracle Exadata system via a highthroughput InfiniBand network fabric.
*As the only unified storage vendor to support InfiniBand as a storage network for backup and
restore operations, Oracle is leading the way with nativehigh-bandwidth interconnects.*The InfiniBand network provides 40 Gb of bandwidth per port between the database servers,
storage cells, and the Sun ZFS Backup Appliance. Backup and restore operations can be
automatically parallelized across all database nodes, Oracle Exadata storage cells, Sun ZFS
Backup Appliance channels, and controllers.
I think correct answer is B instead of A???
Both A & C options are correct.
A & C
A,C
The correct answer is A & B
C & E is not correct, becasue InfiniBand connection should be connected between Database Machine and Media Servers (not from a database server or storage server, rather a complete database machine)
For a RAC database, it is recommended to configure RMAN to run across all instances using database service.
i think it is A and C .When they say database server it means database machine .Otherwise they would have told compute node or cell node.Also B is not exadata specific as it is recommended for all rman backups
mat, you are right. The answer is A and C. Answer B is suitable for backup strategies, not for backup recommendations.
I prefer B and C.
http://www.oracle.com/technetwork/database/features/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf (page 17)
A & B
question itself says “database machine”. option C and E exclusively says database server and storage server.
when they say database server, it is compute node. Documentation says connection should be from db machine to media server.
Amit,
http://www.oracle.com/technetwork/database/features/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf
As per document itself says throughput from Database server to Tape Library,
“The InfiniBand fabric provides an extremely high performance network for transferring
backup data from storage servers to database servers and then to tape media servers, and
vice versa. ”
Hence answer is A and C.
BC
A:
C:
PAGE 10
This requirement is met by using the methodology defined in this document. The lower range of
bandwidth number is used for a conservative calculation. Table 5 illustrates the throughput values for
the requirements gathered and the hardware components chosen to meet the requirements.
TABLE 5: SCENARIO 1 – BACKUP & RECOVERY SIZING USING INFINIBAND CONNECTIVITY
http://www.oracle.com/technetwork/database/availability/maa-exadata-backup-methodology-495297.pdf
BC
refer : http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf
For tape-based backup solutions, the recommended strategy is to perform the following backups:
● Weekly RMAN level 0 (full) backups of the database
● Daily cumulative RMAN incremental level 1 backups of the database
● Daily backups of the Oracle Secure Backup catalog
Use the following strategies to scale backup rates using the InfiniBand fabric while maintaining
high availability:
1. Start with at least two media servers. There can be a total of two Host Channel
Adapters (HCA) – only one active port per media server – bonded for high availability.
2. Add tape drives until the HCA of each media server’s bandwidth is saturated.
3. Use all Oracle Database server instances for backups.
4. Use one RMAN channel per tape drive.
If you are using a Gigabit Ethernet (GigE) network between the media server and Exadata
Database Machine, your rate will be bound by the number of GigE connections multiplied by
120 MB/sec. In an Exadata Database Machine Full Rack there are eight HA-bonded GigE ports
available or one HA-bonded GigE port per database node.