Home Man
Search
Today's Posts
Register

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

Tags
solaris

👤 Login to reply

 
Thread Tools Search this Thread
# 1  
Old 12-14-2005
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 !!!!!!!!!!!!!
# 2  
Old 12-14-2005
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.
# 3  
Old 12-17-2005
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
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?
👤 Login to reply

« Previous Thread | Next Thread »
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
Script to automate add/resize datafile in Oracle ASM Storage a1_win UNIX for Advanced & Expert Users 0 02-07-2018 07:45 AM
Read in numbers from a datafile lost.identity Shell Programming and Scripting 3 02-20-2013 12:46 PM
Validating a datafile with the datatypes bikky6 Shell Programming and Scripting 3 08-16-2012 07:39 AM
Help with datafile parsing and creating spreadsheet inditopgun Shell Programming and Scripting 6 05-03-2012 01:48 AM
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
selective positions from a datafile ganapati Shell Programming and Scripting 10 09-19-2006 09:09 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 12:43 AM.

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