Home » RDBMS Server » Backup & Recovery » create backup database
create backup database [message #214706] Wed, 17 January 2007 12:30 Go to next message
sajut
Messages: 69
Registered: January 2007
Member
Can anyone guide me in creating a backup database in a different location and periodically apply logs generated in the primary database into the backup database

Thanks in advance
Re: create backup database [message #214709 is a reply to message #214706] Wed, 17 January 2007 12:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please do not crosspost.
Are you looking into standby database?
or
Just a duplicate database?
Both the cases are exclusively deal in the RMAN documentation.
Please refer documentation.
Re: create backup database [message #214710 is a reply to message #214709] Wed, 17 January 2007 12:43 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
by mistake, initially I posted in security, then I realised the error and re posted.

What I intend to create is a second database which is in a different location, which can be used in case of a disaster to the 1st database
Re: create backup database [message #214712 is a reply to message #214710] Wed, 17 January 2007 12:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Standby Database is what you want.
For 9i
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm#1656
You can create a standby with RMAN.
In 10g, you can use RMAN or dataguard
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm

Re: create backup database [message #214715 is a reply to message #214712] Wed, 17 January 2007 13:05 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
Thanks for the timely reply.

I have an Oracle 9i R2 standard edition. Can I use it to create a standby database
Re: create backup database [message #214716 is a reply to message #214715] Wed, 17 January 2007 13:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes.
You can use RMAN as said before
or
data-guard
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96653/standbycon.htm
Re: create backup database [message #215350 is a reply to message #214706] Sun, 21 January 2007 13:34 Go to previous messageGo to next message
cbruhn2
Messages: 41
Registered: January 2007
Member
To sajut,

please notice that standard editition doesn't support automatically transfer of redologs, so you have to ftp or use nfs or some other product to get the archived redologs to the standby node.

best regards.
Re: create backup database [message #215371 is a reply to message #215350] Sun, 21 January 2007 21:56 Go to previous message
sajut
Messages: 69
Registered: January 2007
Member
Thank you very much
Previous Topic: how to use Web Tool
Next Topic: Importance of Control file with RMAN
Goto Forum:
  


Current Time: Mon Dec 05 08:31:23 CST 2016

Total time taken to generate the page: 0.10577 seconds