Database Backup and Recovery (MOSC)

MOSC Banner

How to perform RMAN Duplicate database steps needed?

edited Jun 11, 2012 4:09AM in Database Backup and Recovery (MOSC) 3 commentsAnswered

 I have to refresh production data with dev data, this is our data warehouse environment and has 2tb of data. I have few questions and need your opinion regarding the fastest and easiest approach that can be taken to get the refresh done, with no data loss. 

Production Env Source information:
 DWH1 database (11.2.0.2) version
Using ASM 11.2.0.2

DEV Target env information:
DWD1 database (11.2.0.2) version 
Using ASM 11.2.0.2


1) RMAN Duplicate database need the steps to do the refresh? Any knowledge articles etc that would be hepful? pros and cons etc?

2) RMAN cold backup and restore? would you recommend a cold or hot backup? likewise what are the steps for this procedure? pros and cons?

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