Ask the Expert

Backing up database on another PC in local network

  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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: