Database Backup and Recovery (MOSC)

MOSC Banner

Restore Table from RMAN Backup

edited Nov 8, 2018 10:51AM in Database Backup and Recovery (MOSC) 4 commentsAnswered

Hello All,

I am trying to make use of Restore Table from RMAN Backup feature in 12c to restore table in another database.

I was able to restore table using RMAN on the same DB that RMAN full backup was taken, but now I want to restore this table on another DB running on another machine with totally different SID and  different ORACLE_HOME.

What I tried to do is to copy the backupset from the  first  DB machine to the second DB machine in the FRA directory, but when I run the restore command on the second DB I get the below error:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center