topic Re: Refreshing a database in Operating System - HP-UX

Refreshing a database

carl airiel — Wed, 18 Jan 2006 04:53:34 GMT

I have a oracle 8.0.6 on a HP-UX 11.00. I have a oracle test db server on HP-UX 10.20. I wanted to refresh the db on the machine 10.20 with my data in HP-UX 11.00. My question is that, My oracle in HP-UX 11.00 is oracle 8.0.6, while my oracle on HP-uX 10.20 is oracle 8.0.3. Will I'll be having troubles with this?

Regards,
Allan

Re: Refreshing a database

Luk Vandenbussche — Wed, 18 Jan 2006 05:03:51 GMT

Hi,
I think this will work without any problem.
But check the oracle release notes to double check the differences between oracle 8.0.3 and oracle 8.0.6

Re: Refreshing a database

Yogeeraj_1 — Wed, 18 Jan 2006 05:04:08 GMT

hi allan,

There should not be any problems as long as you are using the right tools and "refreshing" non-system data.

what tools are you planning to use for this operation?

kind regards
yogeeraj

Re: Refreshing a database

carl airiel — Wed, 18 Jan 2006 05:10:21 GMT

I usual do a incomplete backup. I backup the physical files using omniback II. Restore the datafiles in other server, then do the incompelete backup.

Do you think I would be having troubles with this?This is the only tool that we've got. I can also use the export and import. But I prefer to using the 1st tool.

regards,
Allan

Re: Refreshing a database

Yogeeraj_1 — Wed, 18 Jan 2006 05:18:48 GMT

hi again allan,

if the database is not too big, my preferred method would be as follows: (descreasing preferrence)

1. SQL COPY
2. EXP/IMP
3. RMAN Duplicate database
4. Copy of datafiles

hope this helps!

kind regards
yogeeraj

Re: Refreshing a database

Victor Fridyev — Wed, 18 Jan 2006 05:22:09 GMT

Hi,

I don't think that you may copy db files between servers with different Oracle and OS versions.
The best way, IMHO, is to export the database on source machine and import it into an empty database on a target machine.

HTH

Re: Refreshing a database

Yogeeraj_1 — Wed, 18 Jan 2006 05:31:11 GMT

hi again,

see also the other thread:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=992564

if you need any further help, do let us know.

kind regards
yogeeraj

Re: Refreshing a database

carl airiel — Wed, 18 Jan 2006 05:31:32 GMT

Is SQL copy already available on oracle 8.0.3 and 8.0.3?Do you have any documentation on this? Is this hard to learn?

Regards,
Allan

Re: Refreshing a database

Yogeeraj_1 — Wed, 18 Jan 2006 05:36:49 GMT

hi,

see:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a82950/ch6.htm#1003261

regards
yogeeraj

Re: Refreshing a database

Arunvijai_4 — Wed, 18 Jan 2006 05:39:14 GMT

Hi Allan,

Yes, it is available from 8.x

-Arun

Re: Refreshing a database

carl airiel — Wed, 18 Jan 2006 05:44:52 GMT

Last thing. this database has it's application. Will it be affected after the refresh.
Thank you so much for the help.

Regards,
Allan

Re: Refreshing a database

Arunvijai_4 — Wed, 18 Jan 2006 05:47:18 GMT

As long as it is compatible and without any errors the refreshing done, it will work fine.

-Arun

Re: Refreshing a database

carl airiel — Wed, 18 Jan 2006 05:53:24 GMT

I just get confused with the terms. Is refreshig a database different from restoring a database. It what ways do they differ.

thanks

Re: Refreshing a database

Arunvijai_4 — Wed, 18 Jan 2006 06:02:51 GMT

Hi Allan,

Restoring a databse is completely building a DB from scratch where as refreshing will keep it updated.

-Arun

Re: Refreshing a database

Yogeeraj_1 — Wed, 18 Jan 2006 06:05:28 GMT

hi,

normally, refresh applies to materialized view or snapshots

If your case, a true refresh would be using database links and snapshots.

this might turn out to be quite complicated.

Depending on your requirements, you have to decide whether you just want a copy of the production database as at a certain point in time or a setup when you can regularly "refresh" so as to get a true picture of the production database.

you need to clarify your requirements.

kind regards
yogeeraj

Re: Refreshing a database

Simon Wickham_6 — Wed, 18 Jan 2006 13:25:35 GMT

To perform this safely I would use the IMP/EXP utlity as the data dictionaries will be diffrent.

Regards,
Simon

Re: Refreshing a database

carl airiel — Wed, 18 Jan 2006 21:46:08 GMT

During the create controfile command, am I allowed to change the location of the datafile, the name of the datafile?Does it going to affect my test db?Does my test server will run smoothly?

Regards,
Allan

Re: Refreshing a database

Indira Aramandla — Wed, 18 Jan 2006 22:29:02 GMT

Hi Carl,

In your create control file script you will have the dev database name and the datafile names and location will be the place where you copied them and the names that you gave them.

for example in PORD you had data file in location /ora01/oradata/abc/system_abd.dbf and you copied this file into dev server from the backup into /ora01/oradata/dbe/system_dbe.dbf then in you create control file script you will provide the dev datafile locaton and name which will be /ora01/oradata/dbe/system_dbe.dbf and you database name will be the dev database name. Once you created the control file successfully, and then opened the database it should function fine.

Also check the control file name and location is the smae in the init.ora file.

Indira A

Re: Refreshing a database

Frank de Vries — Thu, 19 Jan 2006 02:16:31 GMT

Hi Carl

Yes you can change the location of your
datafile(s) in the controlfile.

However you need to alter the location
in the datadictionary too with the
alter database rename datafile command
in svrmgrl in mount state.

Probably superfluous to mention that
you should ensure the datafiles also physically exists on this new location.