OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » offline backup (oracle 10g linux)

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

offline backup [message #393405]

Sun, 22 March 2009 10:33

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi,

I have created new database using DBCA and also i have offline backup for another database.My management forced me " please restore backup for anoher database into newly created database.

Please provide the steps for it?

Thanks,
Michael,

Report message to a moderator

Re: offline backup [message #393406 is a reply to message #393405]

Sun, 22 March 2009 10:47

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

Senior Member
Account Moderator

>>restore backup for anoher database into newly created database.
Not sure what exactly it means.
Assuming the "new database" is just an empty database (without any custom schema/objects),
You can just restore the backup.
Everything in "new Database" is wiped out.
If you want to retain something from "new database" then export the schema before restore and import back.

Search the forum for "cold restore" or "Consistent backup".
All you need to do is,
recreate controlfile from traced controlfile, recreate the path and place the datafiles and you can just mount it.

Report message to a moderator

Re: offline backup [message #393842 is a reply to message #393405]

Tue, 24 March 2009 10:51

dzt52r
Messages: 19
Registered: July 2007
Location: PA

Junior Member

perhaps you could use RMAN to duplicate the existing database.

Report message to a moderator

Re: offline backup [message #393856 is a reply to message #393842]

Tue, 24 March 2009 13:16

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>perhaps you could use RMAN to duplicate the existing database

Why need to use RMAN duplicate ??

Already Mr Mahesh message very clear.

Babu

Report message to a moderator

Re: offline backup [message #393857 is a reply to message #393856]

Tue, 24 March 2009 13:21

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

Senior Member
Account Moderator

>>Why need to use RMAN duplicate ??
Because, it is still a perfect alternative. Smile

Also will be an RMAN cold restore into another node.

Report message to a moderator

Re: offline backup [message #393858 is a reply to message #393857]

Tue, 24 March 2009 13:26

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

Assuming the "new database" is just an empty database (without any custom schema/objects),
You can just restore the backup.
Everything in "new Database" is wiped out.
If you want to retain something from "new database" then export the schema before restore and import back.

Also. He can create one more new database using DBCA.

Here Rman or Export and import is not require for dummy database.

>>Also will be an RMAN cold restore into another node.

It's dummy database. Why need to use Rman

Correct me; If any thing wrong. Razz

Babu

Report message to a moderator

Re: offline backup [message #393859 is a reply to message #393858]

Tue, 24 March 2009 13:37

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

Senior Member
Account Moderator

>>It's dummy database. Why need to use Rman
That's right. The target database (where the backup should be restored) is a dummy database.
The OP is looking to refresh this DUMMY database with the backup of "another database".
It can be done with any method , with or without RMAN.

>>Here Rman or Export and import is not require for dummy database.

I already addressed it.
Quoting myself:
>>If you want to retain something from "new database" then export the schema before restore and import back.
The OP has not yet responded. We assume it is "dummy database".
The above statement is valid ***if*** there is something to be retained from "new database".

[Updated on: Tue, 24 March 2009 13:41]

Report message to a moderator

Re: offline backup [message #393860 is a reply to message #393859]

Tue, 24 March 2009 13:51

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thanks for the details.

Babu

Report message to a moderator

Previous Topic:	rman backup in cif mount point
Next Topic:	rman backup command concepts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 09:24:51 CDT 2024