|
|
|
Re: Automatically backup oracle database. [message #146853 is a reply to message #146849] |
Mon, 14 November 2005 04:00 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
you mean to say that the backup server should get updated automatically whenever there is a change in the main database.
Look into the docs for standby databases.
or search the forum , you will get the link on how to create standby databases?
|
|
|
|
Re: Automatically backup oracle database. [message #148144 is a reply to message #146836] |
Tue, 22 November 2005 22:14 |
ndefontenay
Messages: 14 Registered: November 2005 Location: Thailand
|
Junior Member |
|
|
Hi.
What I do is a script that ftp a hot backup to my backup server and then reun my recovery scripts to recover the database.
It involves:
step1 (weekly)
1) Detecting when ftp is done
2) Checking that all data have been moved properly to the backup location
3) Move the uploaded files (yes the ftp session has to be launched from backup to know when it's finished) to the correct folders
4) Rename the dbfs files location because they are not exactely the same (I'm planning to backup 4 databases)
5) Keep the database mounted but not open
----
Step2 (daily)
1) upload the archives files
2) recover database using backup controlfiles
and voila!
The day you have a problem just
alter database open resetlogs;
The maximum data loss with this solution is 24h.
|
|
|