Home » RDBMS Server » Backup & Recovery » offline backup (oracle 10g linux)
offline backup [message #393405] Sun, 22 March 2009 10:33 Go to next message
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,
Re: offline backup [message #393406 is a reply to message #393405] Sun, 22 March 2009 10:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: offline backup [message #393842 is a reply to message #393405] Tue, 24 March 2009 10:51 Go to previous messageGo to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
perhaps you could use RMAN to duplicate the existing database.
Re: offline backup [message #393856 is a reply to message #393842] Tue, 24 March 2009 13:16 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: offline backup [message #393857 is a reply to message #393856] Tue, 24 March 2009 13:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: offline backup [message #393858 is a reply to message #393857] Tue, 24 March 2009 13:26 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: offline backup [message #393859 is a reply to message #393858] Tue, 24 March 2009 13:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks for the details.

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


Current Time: Wed Dec 07 10:28:27 CST 2016

Total time taken to generate the page: 0.15894 seconds