RESTORE Oracle 10 Database.

[EM1107]

Good day every one.

I have a question.

I am not familiar with Oracle but I was given two files.
one of the file is a .dmp file and the other one is .log file.

I was asked to restore these database.

First I have no existing database juse the New Server I build.

How do you restore a dmp and log file to a database that does not yet exist?

I have done that many times in SQL server but Oracle is totaly new to me.

Any help you have would be appreciated.

Thanks!

 

[SantaMufasa]

EM,

The .log file is simply a text file that tracks the progress and outcome of either an Oracle import or export. You can use a standard text editor (e.g., Windows: Notepad, Word, et cetera; Unix: vi, emacs, et cetera) to view the contents of the .log file.

The .dmp file you will use to load the data into your newly created database via an Oracle import ("imp") command.

We can certainly advise you on how to conduct the import, but it would help us help you if we can know more about the contents of the .dmp file. To do this, we'll presume that the .log file is an accurate representation of what happened during the export ("exp") that created the .dmp file.

Could you please provide answers to the following questions for us (some of the answers will appear in the .log file):[ul][li]What operating system are we talking about for the import?[/li][li]What is the size of the .dmp file?[/li][li](from the .log file) What are the names of the Oracle users that you are going to import?[/li][li]Approximately how many tables for each Oracle user will the import process?[/li][/ul]Looking forward to seeing your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[EM1107]

The operating system is Windows 2000 SP4.
The size of the database is about 4.5Gb
There is 3 users.
CCMADMIN
DOCSADM
WFADM

There is about 600 Tables.

 

[SantaMufasa]

Thanks, EM, that helps me formulate a practical resolution to your need.

First, using your choice of Oracle administrative software (e.g., SQL*Plus), create the three (empty) Oracle users: CCMADMIN, DOCSADM, WFADM, with the privileges and space quotas that abide by your organisation's standards.

You will also have much less trouble importing if you also create Oracle tablespaces whose names match the tablespace name from which those users' objects came from originally. Ensure that the Oracle users have space privileges on the tablespaces, for example:

ALTER USER CCMADMIN QUOTA UNLIMITED ON <tablespace name>;

Lastly, log into your Windows machine as a user that has full Oracle administrative privileges (i.e., is a member of the ORA_DBA group, e.g., the user that you used to install Oracle). Then, at a DOS prompt, issue the following Oracle import command, replacing all entries within "<" and ">" symbols (e.g. "<entry>") with appropriate values for your need. To avoid continuation symbols, place the import statement on a single command line. (My sample "imp" command appears on multiple lines simply from Tek-Tips' page-wrapping limitations, but you should code the "imp" command on a single command-prompt line.):

c:\<path> imp buffer=15000000 grants=n feedback=1000 fromuser=CCMADMIN touser=CCMADMIN file=<name of .dmp file> log=CCMADMIN_Imp.log  userid=<DBA user name>/<password>@<your Oracle instance's TNS alias>

The above command line should cause an import of the CCMADMIN user. You will want to do similarly for the other two users, as well.

Let us know if you have questions and also the outcome of your import.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]