No question at this time
DBA Top 10
1 A. Kavsek 12400
2 M. Cadot 7300
3 B. Vroman 6400
4 P. Wisse 5600
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 A. Chavan 300
9 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48458
Total active users1485
Act. users last 24h4
Act. users last hour0
Registered user hits last week184
Registered user hits last month815
Go up

RMAN PITR - Table from PROD to NON PROD environment
Next thread: Extract SQl from SQLNet trace files
Prev thread: Data retention for dba_hist_undostat and v$undostat

Message Score Author Date
Problem statement is I want a backup of a table or...... Nishant Kariya Nov 30, 2019, 17:44
Hi, Using DB Link and CTAS it's just 1 step. ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Dec 02, 2019, 08:52
Is there any way by which I can recover single tab...... Nishant Kariya Dec 04, 2019, 05:48

Follow up by mail Click here


Subject: RMAN PITR - Table from PROD to NON PROD environment
Author: Nishant Kariya, India
Date: Nov 30, 2019, 17:44, 6 days ago
Message: Problem statement is I want a backup of a table or table partition from PROD environment into Non-PROD environment, without affecting any other object in NON-PROD database.

I read about the new 12c recovery manager feature for PITR of table or table partition. But examples shown are recovering data to same environment. How can I do it from PROD to UAT?

Also, it internally uses DBPump to achieve its purpose, so If I go and use DBPUMP myself to export the desired table from PROD into dump file and then import into DEV.


If possible, then which one will be faster and space efficient. Assuming table size in TB's . DBPUMP would require size on the PROD server for dump creation and then transport of this dumpfile to DEV server. If it is possible to do directly with RMAN, then can I do it easily?

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RMAN PITR - Table from PROD to NON PROD environment
Author: Philip Wisse, Netherlands
Date: Dec 02, 2019, 08:52, 5 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

Using DB Link and CTAS it's just 1 step.

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RMAN PITR - Table from PROD to NON PROD environment
Author: Nishant Kariya, India
Date: Dec 04, 2019, 05:48, 3 days ago
Message: Is there any way by which I can recover single table or single schema from PROD to DEV using RMAN?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here