Home » RDBMS Server » Backup & Recovery » Refresh of database (10.2.0.3, Windows 2003)
Refresh of database [message #408998] Thu, 18 June 2009 11:23 Go to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Hi all,

We are planning to refresh our database with our clients data. Our client wants to send us the hard drive with a zipped copy of their database. Anyone have any suggestions on how I can refresh this database? I usually refresh using export/import or datapump.

thanks a lot
Re: Refresh of database [message #408999 is a reply to message #408998] Thu, 18 June 2009 11:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unzip the files and put them in their location.

Regards
Michel
Re: Refresh of database [message #409000 is a reply to message #408998] Thu, 18 June 2009 11:38 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Will these be the database files? So, I first remove the database files of our database and then put their unzipped database files in that location and startup the database?

Thanks for your help
Re: Refresh of database [message #409001 is a reply to message #409000] Thu, 18 June 2009 11:43 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


You need zip your export dumpfile.

BAbu
Re: Refresh of database [message #409002 is a reply to message #408998] Thu, 18 June 2009 11:47 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Will these be the database files?
Don't ask us. Ask the client EXACTLY what are they sending you.
Re: Refresh of database [message #409003 is a reply to message #408998] Thu, 18 June 2009 11:57 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Okay. Looks like they are sending the database files. They are running on 10.2.0.4. Our database is 10.2.0.3. Do I have to upgrade my database to 10.2.0.4 to restore the client's database files?

Thanks again
Re: Refresh of database [message #409004 is a reply to message #408998] Thu, 18 June 2009 12:17 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You can install into a new ORACLE_HOME V10.2.0.1 & then upgrade it to V10.2.0.4 and use it to open the client's DB.

Or you could upgrade your s/w & DB to V10.2.0.4.
It is your choice.
Re: Refresh of database [message #409005 is a reply to message #409004] Thu, 18 June 2009 12:32 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

I think this thread move to upgrade topic.

As per your requirement; You have export dumpfile; I belive no need to upgrade your database; Just try to import.

Thanks
Re: Refresh of database [message #409007 is a reply to message #408998] Thu, 18 June 2009 12:44 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Thanks. Will the compatibility of datapump import work if I impdp from 10.2.0.4 to 10.2.0.3 database?

I read in some of the links that I've to mention the version parameter, is it necessary?

Thanks
Re: Refresh of database [message #409012 is a reply to message #409007] Thu, 18 June 2009 13:59 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Re: Refresh of database [message #409017 is a reply to message #408998] Thu, 18 June 2009 14:34 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Thanks for the link.

IF they send datapump export, I've asked the client to mention version parameter in the export.

But, they do not want to give us a export for some reason and would like to send us the database files. They are not sure yet.

If they send us the database files, and I copy them to our database file location, will it change the sys password etc or do I just copy the non default database files?

Thanks much for all your help
Re: Refresh of database [message #409019 is a reply to message #409017] Thu, 18 June 2009 14:45 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
>BlackSwan

>Will these be the database files?
Don't ask us. Ask the client EXACTLY what are they sending you.



Quote:
>>IF they send datapump export

>>If they send us the database files

I never use Suppose/may be/I think/If. As per BlackSwan; Confirm with your client.

Thanks

[Updated on: Thu, 18 June 2009 14:48]

Report message to a moderator

Previous Topic: rman catalogt: how to register and check registration of a DB?
Next Topic: Unable to perform recovery from RMAN backup
Goto Forum:
  


Current Time: Thu Dec 08 12:22:53 CST 2016

Total time taken to generate the page: 0.25903 seconds