| Backup Strategies for DB > 2 TB [message #174201] |
Fri, 26 May 2006 08:02  |
spanek
Messages: 21
Registered: May 2005
|
Junior Member |
|
|
Hello,
we have a database which is in fact larger than 2 TB and growing very fast. It is a Oracle 9.2.0.7 Version. The System is HP with Storage XP12000.
We are looking for a Backup Strategy how we could handle this.
Also the recovery time which we had is not so much, while it is a 24*7 Production System.
Do you have some good an bullet proofed tips?
(RMAN, Split mirror, Standby 9.2, etc.)
regards
|
|
|
|
| Re: Backup Strategies for DB > 2 TB [message #174357 is a reply to message #174201] |
Sun, 28 May 2006 08:00  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Here is what I do.
Each night the operators run a job. We have 5 versions, that is 5 nights of backups at any time. By changing the directory name we move directory 4 to directory 5, directory 3 to directory 4 and so on. Then we build a list of all table spaces in plsql, excluding temporary tablespaces. The job puts the tablespaces, one by one, into and out of backup mode and copies the tablespace to directory 1. Then we switch logfiles and include it in the directory 1, which is our 'destination directory' and backup the controlfile and logfiles as well. Then we compress all the files.
I have all the code for you if you wish. This code is for any unix running any version of Oracle. Let me know if you need the code.
The operator needs to be sure the backup completes because you do not want to leave a tablespace in backup mode any longer that necessary.
Restore is a little tricker. It requires Knowlege of tablespace and archivelog locations. You NEVER want to restore a controlfile unless it is your only option. The controlfile does not know anything that happened after the backup so you lose data.
We run live backups usually after the batch jobs run.
Another option is the export/import mode. I do not use it because of the limitations.
I am glad I have only had to restore 2 times in the last 10 years. Both times we because of a 'user' error. You have to do a 'point in time' recovery.
Good luck and let me know if you need the shell scripts for the backup.
Neil.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
