| hot backup [message #142954] |
Tue, 18 October 2005 08:27  |
gjayasekar
Messages: 45
Registered: October 2005
|
Member |
|
|
hi,
1.we are ruuning prod db 40gb size
pl suggest which backup is best and give the steps for it.
2. then we want to move prod data's every month end to development, and we are keeping 30 days data's only.
how to move data's to dev give steps
3. then delete the old records in prod table which is best delete or truncate in the prod table
pl explain
thanks
jai
|
|
|
|
|
|
| Re: hot backup [message #142970 is a reply to message #142954] |
Tue, 18 October 2005 08:59  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>pl suggest which backup is best and give the steps for it.
I prefer RMAN.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/toc.htm
>>2. then we want to move prod data's every month end to development, and we are keeping 30 days data's only.
Use RMAN duplication
>>3. then delete the old records in prod table which is best delete or truncate in the prod table
delete / truncate will remove the data.
You want to do that?
Are you looking to archive? How about partitions?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
