-
Restoring a database
I have a .dbf file. How can i load it and then restore the Schema of the dbase?
-
If this is the only thing that you have, maybe it's impossible to be done.
-
Why? What type of file is this?
-
Is this oracle database file?. To restore a complete oracle database you need a backup of all user and system tablespaces, control file and configuration files.
You can't simply attach a .dbf file to an instance.
-
Well, what kind of information may contain that file and how can i use it?
-
You can't read it because it is not a plain text. Without the complete set of files it is useless.
-
and what is the complete set of files. Any relevant reference?
-
There is no standard sets of files, the number of files depend on how database was created in the first place.
Anyways you need database files for at least
system tablespaces
user tablespaces
control files (or create control file script)
initSID.ora file
This site guides you step by step for revcovery
http://www.infomaxweb.com/Oracle8i/CompleteRecovery.htm
-
-
The basic recovery mechanism has not changed much from 8i to 9i, so you should still be able to use the instructions for 8i.
You can always go to otn.oracle.com and register to get all the oracle manuals.
-
now i want to connect with Oracle through a php script. What is the right configurations? I use Oracle 9i r2
-
Always start a new thread with a new topic.
Here is an example
http://elab-nt1.bus.umich.edu/howto_oracle_php.html
-
The link was right, but what about the settings?, in php.ini or whatever?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|