No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
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
Nishant, If you don't want to use any resources...... Philip Wisse Dec 07, 2019, 20:14
Hi Philip, no need for TSPITR, from 12c onward ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Ales Kavsek Dec 10, 2019, 07:23

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, 180 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, 178 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, 176 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

Subject: Re: RMAN PITR - Table from PROD to NON PROD environment
Author: Philip Wisse, Netherlands
Date: Dec 07, 2019, 20:14, 173 days ago
Message: Nishant,

If you don't want to use any resources on the production database restore to a new location.
Or maybe the data is not available any more in production?

As a minimum you need to restore and recover the essential tablespaces SYSTEM and UNDO and then the data tablespace(s).
Then you can export the data you want using datapump.
Converting physical backup to logical . . .

Oracle has automated TSPITR but there are restictions:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/performing-rman-tspitr.html#GUID-CAACDB53-7C3A-45B4-8249-C5D855D47571

HTH, 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: Ales Kavsek, Slovenia
Date: Dec 10, 2019, 07:23, 170 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Philip,

no need for TSPITR, from 12c onward we can use TPITR (Table Point in time recovery)....

https://oracle-base.com/articles/12c/rman-table-point-in-time-recovery-12cr1

There is no way to do it directly to NON PROD database, OP must execute table point in time recovery to dump file and then import to non-prod...

https://oracle-base.com/articles/12c/rman-table-point-in-time-recovery-12cr1#table-pitr-recovery-dump-file

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