This post is more than 5 years old
1 Rookie
•
39 Posts
0
3693
Export a replicated MTREE to use with rman
Hello, I`m not a Oracle expert. So I have some questions about restore on replicated mtree.
My customer is using DDBoost for Oracle, and backups are OK.
So, the customer asked me if is possible, replicate the mtree with the rman backups to other DD on site2.
After that, export this mtree on DD-Site2( NFS), and after that do a rman catalog using these data.
I think that there is no problem, because the rman will only read these data and update the catalog.
Well, I would like to know if there is someone that tried a similar configuration.
Thanks in advance.
Deb_PS
156 Posts
1
July 1st, 2015 22:00
Yes it is, only the negative is is RMAN catalog will not be aware of the replication because it will happen from one DD to Another.
To perform file replication, use a command similar to the one shown below. Edit the script
command for your environment, specifying the Data Domain system that is the
destination system for the file replication. Specifying COPIES 2 requires an installed
Replicator license on both the source and destination Data Domain systems. Making a
backup by specifying COPIES 2 requires Oracle Enterprise Edition.
Specifying COPIES 2 instructs the DD Boost RMAN plugin to perform Managed File
Replication to the second Data Domain system. The second Data Domain system name is
specified as part of the file name of the second copy. This is the 'destinationsystem'
in the command below.
The two file names specified in this command must be identical except for the inclusion
of 'destination-system' in the second name. The RMAN plugin requires that the file
names of the two copies be identical. The underscore character "_" is also required.
Omitting the underscore in the file names will result in an error and the backup will fail.
Any changes made to the file name formats shown must include an underscore character
and must guarantee that the file names are identical, except for 'destination-system'
in the name for the second copy. This means that using Oracle formats such as "%U" and
"%c" is not allowed, as these Oracle formats include the copy number in the generated
file name and thus result in the file name generated for the second copy being different
from the file name generated for the first copy.
backup copies 2 database filesperset=1 format '%u_%p', 'destination-system/%u_%p';
Note
Enter a small letter "u" in '%u_%p'. A capital "U," while a valid Oracle format, is invalid
for DD Boost RMAN and causes the replication to fail.
To use COPIES 2, the value of BACKUP_TAPE_IO_SLAVES must be TRUE, which you can
configure by entering:
SQL> show parameter backup_tape
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
backup_tape_io_slaves boolean FALSE
SQL>
SQL> alter system set backup_tape_io_slaves = true scope=spfile;
System altered.
bounce the oracle instance( shutdown and startup) the database
SQL> show parameter backup_tape
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
backup_tape_io_slaves boolean TRUE
SQL>
The only difference from performing a second backup to a different BACKUP_HOST is that
the data flow for Managed File Replication is between the two Data Domain systems. A
normal backup sends data between the backup server and a Data Domain system.
File replication must be performed to a destination storage unit with the same name as
the source storage unit. This means that the target Data Domain system must have a
storage unit that has the same name as the storage unit on the source Data Domain
system containing the file being replicated. The file will be replicated to the identically
named storage unit on the destination Data Domain system.
File replication using RMAN requires that both the source Data Domain system and the
destination Data Domain system are connected to, and accessible from, the RMAN
system performing backups. The network configuration must allow backups to both the
source Data Domain system and to the destination Data Domain system. Replication will
not work in configurations where the destination Data Domain system is only connected
to the source Data Domain system via a private network or link.
Note:
If two copies of a backup have been made using COPIES 2, during restore operations
RMAN will not automatically restore from the second backup copy if the first copy is not
available.
Thanks
Deb
Please Like my Post if you liked it, Please Mark it as Helpful if it helped you, and mark it as Correct Answer if it resolved your query
Deb_PS
156 Posts
1
June 30th, 2015 19:00
Hope the below Scripts helps you
Generic RMAN Backup Script
#
rman target / <
run {
allocate channel dd1 type 'sbt_tape' parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libddobk.so,ENV=(STORAGE_UNIT=rman1,BACKUP_HOST=dd890e)';
backup filesperset 1 database format '%u_%p';
backup archivelog all format '%u_%p';
release channel dd1;
}
EOF
Backup to Primary DD using 4 channels
#
rman target / <
run {
allocate channel dd1 type 'sbt_tape' parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/home/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=rman1,BACKUP_HOST=ddve-01)';
allocate channel dd2 type 'sbt_tape' parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/home/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=rman1,BACKUP_HOST=ddve-01)';
allocate channel dd3 type 'sbt_tape' parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/home/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=rman1,BACKUP_HOST=ddve-01)';
allocate channel dd4 type 'sbt_tape' parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/home/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=rman1,BACKUP_HOST=ddve-01)';
backup filesperset 1 database format '%u_%p';
backup archivelog all format '%u_%p';
release channel dd1;
release channel dd2;
release channel dd3;
release channel dd4;
}
EOF
Backup to Replica DD
#
rman target / <
run {
allocate channel dd1 type 'sbt_tape' parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/home/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=rman1,BACKUP_HOST=ddve-01)';
allocate channel dd2 type 'sbt_tape' parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/home/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=rman1,BACKUP_HOST=ddve-01)';
backup filesperset 1
copies 2 database format '%u_%p','ddve-02/%u_%p';
release channel dd1;
release channel dd2;
}
EOF
PetersonPS
1 Rookie
1 Rookie
•
39 Posts
0
July 1st, 2015 03:00
Hello Deb, thanks by the reply.
Using the example that you sent, the customer will do the same backup twice, correct?
What the customer wants is, do one backup to primary DD, replicate mtree using data domain replication, and mount the mtree replicated on second rman server.
It is possible?
Thanks in advance.
Deb_PS
156 Posts
0
July 1st, 2015 22:00
The following example shows the output of the RMAN list command, which shows the
destination and the storage unit associated with COPIES 2.
RMAN> list backupset 52;
List of Backup Sets
===================
BS Key Type LV Size
------- ---- -- ----------
52 Full 1.62G
List of Datafiles in backup set 52
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 4614599 09-MAY-12 /u02/app/oracle/oradata/Demo/system01.dbf
2 Full 4614599 09-MAY-12 /u02/app/oracle/oradata/Demo/sysaux01.dbf
3 Full 4614599 09-MAY-12 /u02/app/oracle/oradata/Demo/undotbs01.dbf
4 Full 4614599 09-MAY-12 /u02/app/oracle/oradata/Demo/users01.dbf
5 Full 4614599 09-MAY-12 /u02/app/oracle/oradata/Demo/example01.dbf
Backup Set Copy #2 of backup set 52
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:34 09-MAY-12 NO TAG20120509T101338
List of Backup Pieces for backup set 52 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
78 1 AVAILABLE Demo dd670-ostqa06.datadomain.com/20nahpei_1
Backup Set Copy #1 of backup set 52
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:34 09-MAY-12 NO TAG20120509T101338
List of Backup Pieces for backup set 52 Copy #1
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
77 1 AVAILABLE Demo 20nahpei_1
RMAN>
PetersonPS
1 Rookie
1 Rookie
•
39 Posts
0
July 2nd, 2015 05:00
Deb, thanks very much.
I will talk with customer about use of the RMAN to control the copies.
Thanks.
PatricJ
1 Rookie
1 Rookie
•
68 Posts
0
July 10th, 2015 00:00
Take a look into Data-Domain-Boost-for-Oracle-Recovery-Manager
https://support.emc.com/docu55838_Data-Domain-Boost-for-Oracle-Recovery-Manager-1.3.0.0-Administration-Guide.pdf?languag…