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

Report message to a moderator

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: 10707
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.

Report message to a moderator

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

Report message to a moderator

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: 10707
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

Report message to a moderator

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

Report message to a moderator

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: 10707
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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: how to use Web Tool
Next Topic: Importance of Control file with RMAN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 15:21:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.