Home » RDBMS Server » Backup & Recovery » Automatically backup oracle database.  () 1 Vote
Automatically backup oracle database. [message #146836] Mon, 14 November 2005 02:19 Go to next message
kienvang1090
Messages: 4
Registered: August 2005
Junior Member
Hi all,
I want to automatically backup oracle database to another DB server.How can I do ?
Please help me, It is verry agent!
Re: Automatically backup oracle database. [message #146845 is a reply to message #146836] Mon, 14 November 2005 03:39 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Can you elaborate your problem properly????

Go to the SCRIPTS section of this site and there you will find lots of things.

[Updated on: Mon, 14 November 2005 03:47]

Report message to a moderator

Re: Automatically backup oracle database. [message #146849 is a reply to message #146836] Mon, 14 November 2005 03:53 Go to previous messageGo to next message
kienvang1090
Messages: 4
Registered: August 2005
Junior Member
Hi,
I will elaborate my problem. I have 2 database servers. One use to store data, onother use to backup data - Automatically backup . But I don't want to backup by manual.
regards,
kienvang
Re: Automatically backup oracle database. [message #146853 is a reply to message #146849] Mon, 14 November 2005 04:00 Go to previous messageGo to next message
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 #146861 is a reply to message #146853] Mon, 14 November 2005 04:57 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Moved to backup and recovery.

MHE
Re: Automatically backup oracle database. [message #148144 is a reply to message #146836] Tue, 22 November 2005 22:14 Go to previous message
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.
Previous Topic: get all tables
Next Topic: 10g R2 Media Management Agent
Goto Forum:
  


Current Time: Wed Dec 11 16:09:48 CST 2024