| xsam |
Posted: May 03, 2008 03:08:17 PM |
Total Post: 8
Joined: Jan, 2008
|
Hi,
I need to do a refresh activity. The Prod. DB has to be refreshed onto the test DB. So could you please help by suggesting how i should go about this? |
|
|
 http://shaharear.blogspot.com |
| Posted: May 04, 2008 01:23:05 AM |  |
|
Total Post: 128
Joined: Apr, 2008
|
I don't understand what you try to mean by the words "refresh activity". Please describe clearly ..what you need.
Are you mean replication the words "refresh activity"?
|
|
|
|
|
| suraj_v |
| Posted: May 04, 2008 03:18:25 AM | |
|
Total Post: 8
Joined: Mar, 2008
|
Hey Sam ,you can make use of RMAN Duplicate or tablespace level backups which would be the recommended way for a database refresh if the database size is less than 1 TB .If you had stuck in any steps plz update in the form .
Kind Regards, Suraj V
|
|
|
|
|
| Mohammed Taj |
| Posted: May 04, 2008 10:59:50 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
1. drop test db
2. take backup from production db
3. create new test db
you can use RMAN DUPLICATE / USER MANAGED (INCOMPLETE RECOVERY) / COLD BACKUP
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
