| Restore the data from datafile [message #60200] |
Fri, 23 January 2004 02:01  |
K. Prakash babu
Messages: 46
Registered: July 2001
|
Member |
|
|
Hi friends,
I have performed a cold backup and got the datafile 'df1.dbf' from database(X1).
How can i restore the data in a seperate database(X2) using 'df1.dbf'.
Please give me the solution... it is very urgent.
Thanks in Advance
-Prakash
|
|
|
|
|
|
| Re: Restore the data from datafile [message #60204 is a reply to message #60201] |
Fri, 23 January 2004 02:34  |
satish
Messages: 112
Registered: September 2000
|
Senior Member |
|
|
It is not like sql server, attaching/detaching datafiles.
you need to take cold backup of log files, control files, and datafiles.
then use the control file creation script and make appropriate changes in it, then run the server manager/sqlplus with this script.
sample control file script:
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "x2" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 170
LOGFILE
GROUP 1 'D:DBDATAREDO01.LOG' SIZE 100M,
GROUP 2 'D:DBDATAREDO02.LOG' SIZE 100M,
GROUP 3 'D:DBDATAREDO03.LOG' SIZE 100M
DATAFILE
'D:DBDATASYSTEM01.DBF',
'D:DBDATAUNDOTBS01.DBF',
'D:DBDATAINDX01.DBF',
'D:DBDATATOOLS01.DBF',
'D:DBDATAUSERS01.DBF'
CHARACTER SET WE8MSWIN1252
;
RECOVER DATABASE;
ALTER DATABASE OPEN;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
