Q
Problem solve Get help with specific problems with your technologies, process and projects.

Taking backup from one server to second

I have two servers. I want to take a backup from one server to the second server using RMAN in Oracle 9i.

I have two servers. I want to take a backup from one server to the second server using RMAN in Oracle 9i. On both sides Oracle 9i is installed. Thanks.

Let's assume you have your database on ServerA and you want to back up to disk on ServerB. One option is to create a network pointer to the disk on ServerB from ServerA. In Unix/Linux, this is called a cross mount. In Windows, this is called a file share. Once you can access ServerB's disks from ServerA, tell RMAN to configure a channel to this file share. RMAN will write to the disk, thinking it is local to ServerA, but the disk is really running on ServerB. RMAN will be running on ServerA but backing up to ServerB.

If you cannot create the file share, then you can install Oracle software on ServerB. Then configure a TNSNAMES.ORA entry to point to the database running on ServerA. In RMAN, you can connect to the database on ServerA with the following command:

CONNECT TARGET user/pswd@tns_alias
In this situation, you are running RMAN on ServerB, backing up to disk on ServerB, but backing up the database running on ServerA.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close