OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » creating schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating schema [message #204485]

Mon, 20 November 2006 23:32

msurendra_rao
Messages: 5
Registered: November 2006

Junior Member

hi

I have formated my hardisk i need to install new oracle8i software.using export utillity i took .dmp file of users ,
so after installing the oracle 8i after formating harddisk is it i need to get back my all the data back is it enough that i will create a new empty database and then create users and then import the .dmp file which i did earlier or i need to take the .dmp of database of the old user.

Report message to a moderator

Re: creating schema [message #204487 is a reply to message #204485]

Mon, 20 November 2006 23:38

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi ,

You want to format ur harddisk. for that

1. Take bkp of ur database using Export commmand ( if database size is small).
Import Mode Is -- Full, Users, according ur needs.

2. Format ur harddisk.

3. Again Install Oracle 8i software and database created with software installation.

4. Just Import ur .dmp file.

Note : You have to two option if you want to some user in ur previous database then you have to create users otherwise no need.

You have to create tablespace. if already not exists. ( some like in ur previous database).

And if you install only software then you have to create database first and import ur operation.

hope this helps
Taj

Report message to a moderator

Re: creating schema [message #205023 is a reply to message #204485]

Thu, 23 November 2006 01:39

mitra.kausik
Messages: 21
Registered: June 2006

Junior Member

If u haven't formatted hard disk .. then i think use following mechanism

Take a backup of ur current db like

alter database backup controlfile to trace resetlogs;

Scoop out the relevant ddl to recreate controlfile and save it as .sql file

Copy all the db files into backup folder ( files should include redo,archive files if any,datafiles,init)

Load oracle8i s/w in ur formattted and then create an instance
Place all the files as per directory structure defined in controlfile(traced).

svrmgrl > connect internal

Run controlfile.sql ( the one which u traced).

Startup the db
alter database open resetlogs;

If any recovery is required use the following

SQL>Recover Database using backup controlfile;

Njoy
Kausik

Recover the

Report message to a moderator

Re: creating schema [message #205024 is a reply to message #204487]

Thu, 23 November 2006 01:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,Take bkp of ur database using Export commmand ( if database size is small).
Import Mode Is -- Full, Users, according ur needs.
It should be "EXPORT"

PS> sorry for new post bcoz i cann't edit my post.
don't know why?

Taj

[Updated on: Thu, 23 November 2006 01:43]

Report message to a moderator

Previous Topic:	MAXEXTENTS UNLIMITED IN TEMP SEGMENT
Next Topic:	confused

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:41:38 CDT 2024