OraFAQ Forum: Backup & Recovery » Restore database !!!

Home » RDBMS Server » Backup & Recovery » Restore database !!!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore database !!! [message #72015]

Sun, 23 February 2003 19:03

pennie
Messages: 7
Registered: February 2003

Junior Member

I have a database version 8.1.6 resides at 2 servers (SUN Server). Host A is the production server and host B is for recovery purpose. Everyday night, I need to restore the full production database from host A to host B. Is there any way for me to perform this other than export/import?
Can anyone help me on this?
Thanks a lot

Report message to a moderator

Re: Restore database !!! [message #72017 is a reply to message #72015]

Mon, 24 February 2003 05:38

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can also do a copy backup to server B
or
use RMAN to CLONE server A to Server B

Report message to a moderator

Re: Restore database !!! [message #72022 is a reply to message #72015]

Mon, 24 February 2003 18:28

pennie
Messages: 7
Registered: February 2003

Junior Member

Can I know what is the meaning of 'do a copy backup', I am not so sure about it.
Besides that, can you show me the steps on how to restore the database by using RMAN to clone? I am quite new to the recovery method.
Anyway, you had give me some ideas about it. Thanks a lot Raj.

Report message to a moderator

Re: Restore database !!! [message #72025 is a reply to message #72015]

Tue, 25 February 2003 06:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

typo!
i meant a cold copy backup.
refer to RMAN docs in oracle DOCS.
RMAN does the Online backup of databases. It creates "backup pieces" inlcuding the current control file.
Using RMAN u need to apply these backuppiecs in another machine and ur new CLONED database is ready~
we clone our production system to TEST and DEV machines
frequently using the rman backup.

Report message to a moderator

Previous Topic:	Re: Safe to not backup index tablespace?
Next Topic:	Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 04 17:47:16 CDT 2026