Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

3666

June 30th, 2015 12:00

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.

156 Posts

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

156 Posts

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

37 Posts

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.

156 Posts

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>

37 Posts

July 2nd, 2015 05:00

Deb, thanks very much.

I will talk with customer about use of the RMAN to control the copies.

Thanks.

1 Rookie

 • 

68 Posts

July 10th, 2015 00:00

No Events found!

Top