oracle datafile *dbf Post: 92752

Sponsored Content

Operating Systems Solaris oracle datafile *dbf Post 92752 by tmarikle on Wednesday 14th of December 2005 12:44:54 PM

12-14-2005

Registered User

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.

tmarikle

View Public Profile for tmarikle

Find all posts by tmarikle

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

ascii to dbf HELP!

Hi, Does anyone know of an ascii to dbf converter for sco unix? Or any flavor of unix for that matter. Thanks! Georgio

2. Shell Programming and Scripting

Combine a datafile with Master datafile, emergent!

Hi guys, my supervisor has asked me to solve the problem in 7 days, I've taken 3 days to think about it but couldn't figure out any idea. Please give me some thoughts with the following problem, I have index.database that has only index date: 1994 1995 1996 1997 1998 1999 I have...

3. Shell Programming and Scripting

how to read dbf file in shell script and to convert dbf file usinf shell script

Hi all, I am new to shell scripting. I have dbf file and I need to convert it into csv file. OR, can i read the fields from a .dbf file and OR seprate the records in dbf file and put into .csv or txt. Actually in the .dbf files I am getting , the numbers of fields may vary in very record and...

4. Shell Programming and Scripting

spilit the list of files in set ls -1 *.dbf

Dear All, Please help in this subject.. my requirement is list the files in directory and out of that list make the different set and each should set contains 10 files and assign to variable and start zipping in background. pick the second set files and same to be repeat the commands parallel. i...

5. Shell Programming and Scripting

sorting the datafile in an order given in second datafile

Hi, I have two files: first input file is having 7-8 columns, and second data file is like I want to arrange my datafile1 in the order given in second data file, by comparing the seconddatafile with the second column of first file and print the entire line....also if any...

6. Shell Programming and Scripting

Want to do this: cp 1.dbf 2.dbf

This is not a valid command, but you get the idea: "cp *1.dbf *2.dbf" I need to change the 1 to 2 on many file names. Using csh. Any ideas? MM

7. UNIX for Dummies Questions & Answers

ArcGIS shapefile *.dbf file to ascii text

Okay, I search around and couldn't find what I needed, so here goes: I have a series of ArcGIS point shapefiles. If I open them in Excel I can save as an Excel or text file and get a 2 column list: POINTID | GRID_CODE 1 | 2.34234 2 | 4.3425 3 | 6.32456 etc... The problem is that I...

8. UNIX for Advanced & Expert Users

Script to automate add/resize datafile in Oracle ASM Storage

Hi all, Could anyone please share ideas or logic on how to automate add/resize datafile in Oracle ASM Storage for Oracle RAC/Single Node databases when any tablespace space alert is trigerred by OEM? Thanks for your help and time on it! Thanks&regards, a1_win Please DON'T use CODE tags...

LEARN ABOUT LINUX

install-solaris

install-solaris(1M)													       install-solaris(1M)

NAME

       install-solaris - install the Solaris operating system

SYNOPSIS

       install-solaris

       install-solaris	invokes  the  Solaris  Install	program. Depending on graphical capability and available memory at the time of invocation,
       install-solaris invokes either a text-based installer or a graphical installer.

       The following minimum requirements for physical memory dictate which features are available during installation:

       For SPARC machines:

       128 MB

	   Minimum physical memory for all installation types

       128 MB

	   Minimum physical memory required for windowing system

       384 MB

	   Minimum physical memory required for graphical-based installation

       For x86 machines:

       256 MB

	   Minimum physical memory for all installation types

       256 MB

	   Minimum physical memory required for windowing system

       512 MB

	   Minimum physical memory required for graphical-based installation

       In some cases, even if the minimum physical memory is present, available virtual memory after system startup can limit the number  of  fea-
       tures available.

       install-solaris	exists	only  on  the Solaris installation media (CD or DVD) and should be invoked only from there. Refer to the  for more
       details.

       install-solaris allows installation of the operating system onto any standalone system. install-solaris loads the software available on the
       installation media. Refer to the  for disk space requirements.

       Refer to the  for more information on the various menus and selections.

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcdrom  (Solaris instal-  |
       |			     |lation media)		   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Evolving			   |
       +-----------------------------+-----------------------------+

       pkginfo(1), install(1M), pkgadd(1M), attributes(5)

       It is advisable to exit install-solaris by means of the exit options in the install-solaris menus.

								    23 Sep 2005 					       install-solaris(1M)