Solaris

The Solaris Operating System, usually known simply as Solaris, is a Unix-based operating system introduced by Sun Microsystems. The Solaris OS is now owned by Oracle.

oracle datafile *dbf

👤 Login to reply

    #1  
Old 12-14-2005
tt155 tt155 is offline
Registered User
 
Join Date: Apr 2005
Last Activity: 5 September 2006, 11:42 AM EDT
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
oracle datafile *dbf

Hi ,,,,

I have move an oracle db from old server to a new server ( solaris 5.9 is the operating system ) my problem is that to new server the datafile ( *.dbf ) are in a different path .....
example

old : /export/home/data/blobs ...........
new /oracle/data/blobs.......

how i can change into it into the oracle schema ?

which are all the path of the datafile that I must change?

Tnks in advance !!!!!!!!!!!!!
Sponsored Links
    #2  
Old 12-14-2005
tmarikle tmarikle is offline Forum Advisor  
Registered User
 
Join Date: Jan 2005
Last Activity: 27 September 2011, 12:36 PM EDT
Posts: 683
Thanks: 0
Thanked 4 Times in 4 Posts
Quote:
Originally Posted by tt155
I have move an oracle db from old server to a new server ( solaris 5.9 is the operating system ) my problem is that to new server the datafile ( *.dbf ) are in a different path .....
example

old : /export/home/data/blobs ...........
new /oracle/data/blobs.......

how i can change into it into the oracle schema ?

which are all the path of the datafile that I must change?
Since you have moved the Oracle database, you certainly can't start it since the data files are not where the control files says that they are. Hopefully you haven't clobbered your old database server so you can run the commands necessary (makes you life much easier).

A little background: Oracle requires that online redo logs and datafiles to be located where the control file indicates. Your control file (and its backups) cannot be edited with a text editor so Oracle has provided you a method for creating an SQL script that can be edited. Your task will be to rebuild the controlfile using the modified SQL script on your new server.

This FAQ shows you the steps required for performing this operation. Follow them carefully because you can render the copied database irrevocably damaged. Also, it is imperative that your database was shut down when you copied the data files. You will not succeed in recreating the controlfile unless the database was copied in a consistent state. Oracle performs checkpoints at regular intervals and keeps an internal number for managing data consistency. If Oracle's SCN does not agree with the physical data files, your database will not restart.

Good luck.
Sponsored Links
    #3  
Old 12-17-2005
tt155 tt155 is offline
Registered User
 
Join Date: Apr 2005
Last Activity: 5 September 2006, 11:42 AM EDT
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Hi !!!! tnks for your support !!!!!!!!!!!!!

I resolved it with the alter command !!!!
but now i have another big problem , the same db i have to install to aix server ,
i installed aix-oracle but now i have to export db from sun-oracle and import to aix-oracle , first questions is : it's possible move an db sun-oracle to db axi-oracle ? my problem is that when i do the import file i recive the error message of the init size ( on the target system ) of the USER01 datafile , before creating i have controlled it on the sun-oracle , after i created it with the same specification , this step i have done for all datafile , i tryed too with RMAN utility nothing .....
Plse help me , i am deprived of hope


Grazie .................
    #4  
Old 12-17-2005
tmarikle tmarikle is offline Forum Advisor  
Registered User
 
Join Date: Jan 2005
Last Activity: 27 September 2011, 12:36 PM EDT
Posts: 683
Thanks: 0
Thanked 4 Times in 4 Posts
Qustion: Can you copy your data files from Solaris to AIX?
Answer: No, you can not migrate an Oracle database this way.

What is the error message that you get when running the import?
Sponsored Links
👤 Login to reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
sorting the datafile in an order given in second datafile CAch Shell Programming and Scripting 2 09-07-2011 07:42 AM
How do we know which processis creating a datafile ukatru UNIX for Advanced & Expert Users 7 09-08-2008 06:24 PM
Combine a datafile with Master datafile, emergent! onthetopo Shell Programming and Scripting 6 05-12-2007 06:36 AM
Append filename to datafile Satyagiri UNIX for Dummies Questions & Answers 3 10-12-2006 09:19 AM
replace one section in a datafile Paprika Shell Programming and Scripting 4 06-17-2005 08:48 AM



All times are GMT -4. The time now is 07:14 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password





Not a Forum Member?
Forgot Password?