Database Backup and Recovery (MOSC)

MOSC Banner

Is it possible to restore a table from an RMAN backup to a different database on a different server?

We have an RMAN full backup(level 0) of our production database.In this backup is a massive partitioned table that I would like to restore to the DEV database (on a different server). The schema and table name will be the same but the database names are different.

Is what I have explained possible?

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.

OS: AIX 7100-03

Please advise and (if possible) provide and example of the RMAN code as a guideline.

Muchly appreciated and thanks in advance.

Andre'

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center