Create Standby Database Using Transportable Media Option

Follow
Description

Is it possible to use a shared location between Primary and Standby for the Create Standby Database (CSD) process?

Solution

Yes, this is possible by using the Transportable Media option in the Dbvisit CSD process.

Transportable Media saves time during the transfer/copy of RMAN backups created during the CSD process. We can specify a shared location (NFS) between Primary and Standby Server or an external device such as a USB drive. The external device is first plugged into the primary server and then manually transferred to the standby site and plugged into the standby server to complete the process.

The below example shows the Dbvisit Standby Command Line Interface (CLI) for using a shared location /standby_nfs/backup/ between Primary and Standby Server:

Do you want to use TRANSPORTABLE MEDIA to transfer the database backup to the standby server? Transportable media is an external device such as a USB drive that is first plugged into the primary server and then manually transferred to the standby site and plugged into the standby server to continue the process. It can be used for large databases or slow networks.

Specifying No means the network will be used to transfer the database backup.

Transportable media will be used: Y

Is this correct? <Yes/No> [Yes]: Yes

A transportable media location must be specified on dbvlin803 where the
database will be backed up to first.
This location must be big enough to hold RMAN backup of the whole database
(2.00GB).

Specify the location on this server: [/usr/tmp]: /standby_nfs/backup/

Directory for transportable media location will be: /standby_nfs/backup/

Is this correct? <Yes/No> [Yes]: Yes

Please specify the transportable media location on dbvlin804. This is where the
backup of the database will be found after plugging the transportable media
into the remote server.

Specify location on remote server: [/standby_nfs/backup/]:

Directory for transportable media will be: /standby_nfs/backup/

Is this correct? <Yes/No> [Yes]: Yes

For more detailed process see User Guide:

Version 7.0

https://dbvisit.atlassian.net/wiki/display/UGDS7/Create+Standby+Database+using+Transportable+Media+option+-+CLI

Version 8.0

https://dbvisit.atlassian.net/wiki/pages/viewpage.action?pageId=104431673#CreateStandbyDatabase(CSD)-3.2.UsingTransportableMediaOption

Ankit Arora September 03, 2014 19:44

Have more questions? Submit a request

Comments