Home » RDBMS Server » Server Administration » creating schema
creating schema [message #204485] Mon, 20 November 2006 23:32 Go to next message
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.

Re: creating schema [message #204487 is a reply to message #204485] Mon, 20 November 2006 23:38 Go to previous messageGo to next message
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

Re: creating schema [message #205023 is a reply to message #204485] Thu, 23 November 2006 01:39 Go to previous messageGo to next message
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
Re: creating schema [message #205024 is a reply to message #204487] Thu, 23 November 2006 01:43 Go to previous message
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:
  


Current Time: Sat Dec 03 20:02:40 CST 2016

Total time taken to generate the page: 0.10196 seconds