| will hourly export affect the system performance? [message #72969] |
Thu, 25 December 2003 18:06  |
Wilson
Messages: 9
Registered: February 2002
|
Junior Member |
|
|
can anyone pls let me know where can i find info with regards to the effect of export on the system performance? coz i am considering doing hourly backup of my database and i do not want this job to slow down my system.
Please advise. Thank you!
|
|
|
|
| Re: will hourly export affect the system performance? [message #72970 is a reply to message #72969] |
Fri, 26 December 2003 00:32  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
definatly.
export is just a 'logical backup'.
if the database is used heavily, and there is a large volume of data, export will be costly.
Usuallly exports are done only in off-peak-periods only.
if you are looking to restore the datbase in hourly basis ( in case of a db restore..) you can have rman to do a daily full backup and frequent incremental rman backup. still it will have some performance overhead.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
