Home » RDBMS Server » Backup & Recovery » backup detail
backup detail [message #142955] Tue, 18 October 2005 08:30 Go to next message
gjayasekar
Messages: 45
Registered: October 2005
Member
hi,
1.db size is 40 GB,how many hrs it to take hot backup
and logical exp backup

2.how frequent should take backup while per day data growing is 1 GB.

3.how many backup copy we should have

thanks
jai
Re: backup detail [message #143452 is a reply to message #142955] Thu, 20 October 2005 08:49 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

1. Nobody can answer such a question without knowing how fast your tapes are, how fast your disks are, transfer rates, etc. Best would be to test it yourself and see how long it takes.

2. If your DB is in archlog mode, a daily, weekly, monthly and yearly backup cycle should be good enough.

3. It depends on how important the data is and how much money you have. One or 2 copies are normally more than adequate.

Best regards.

Frank
Previous Topic: IMP-00069: Could not convert to environment national character set's handle
Next Topic: Archival Process
Goto Forum:
  


Current Time: Thu Mar 28 10:57:06 CDT 2024