Q

Backing up database on another PC in local network

How can I back up my database in another PC in a local network by using RMAN and the SQL prompt?

  1. How can I back up my database in another PC in a local network by using RMAN and the SQL prompt?
  2. I have all database backups using RMAN on the same disk; when a database was lost I could not recover the database from backup files. I could not go in MOUNT phase so I could not recover the database from backup.
RMAN will only back up to local tape or local disk. If the disk is on another machine, you can create a networked file share and then have RMAN back up to the file share. From RMAN's point of view, the backup destination is local.

I am not sure why you could not recover your database. There are many things that could go wrong and without more information, such as the exact syntax of the commands you were issuing and the error messages, I cannot help with this issue.

This was first published in October 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close