cancel
Showing results for 
Search instead for 
Did you mean: 

Refreshing a database

SOLVED
Go to solution
carl airiel
Advisor

Refreshing a database

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
18 REPLIES
Luk Vandenbussche
Honored Contributor
Solution

Re: Refreshing a database

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
Yogeeraj_1
Honored Contributor

Re: Refreshing a database

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
carl airiel
Advisor

Re: Refreshing a database

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
Yogeeraj_1
Honored Contributor

Re: Refreshing a database

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Victor Fridyev
Honored Contributor

Re: Refreshing a database

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
Entities are not to be multiplied beyond necessity - RTFM
Yogeeraj_1
Honored Contributor

Re: Refreshing a database

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
carl airiel
Advisor

Re: Refreshing a database

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
Yogeeraj_1
Honored Contributor

Re: Refreshing a database

hi,

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

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Arunvijai_4
Honored Contributor

Re: Refreshing a database

Hi Allan,

Yes, it is available from 8.x

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
carl airiel
Advisor

Re: Refreshing a database

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

Regards,
Allan
Arunvijai_4
Honored Contributor

Re: Refreshing a database

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

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
carl airiel
Advisor

Re: Refreshing a database

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

thanks
Arunvijai_4
Honored Contributor

Re: Refreshing a database

Hi Allan,

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

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Yogeeraj_1
Honored Contributor

Re: Refreshing a database

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Simon Wickham_6
Regular Advisor

Re: Refreshing a database

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

Regards,
Simon
carl airiel
Advisor

Re: Refreshing a database

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
Indira Aramandla
Honored Contributor

Re: Refreshing a database

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
Never give up, Keep Trying
Frank de Vries
Respected Contributor

Re: Refreshing a database

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.


Look before you leap