| closed backup restoration [message #249053] |
Tue, 03 July 2007 03:22  |
khawish
Messages: 12
Registered: May 2007
|
Junior Member |
|
|
Hi,
I want to restore the database from closed bkup. Do have a look at the following
steps , are they good enough to restore successfully.. at last i want to apply the
archives , wht will be the solution.
1. Install Oracle Software on new server.
2. Create database with exact name which you have backed up from some
other Server (Optional).
3. If you have created a new database with exact name then shutdown the database.
4. copy all datafiles,online redo logs, control files (which you have
backuped up from othere server) to the newly created server in ORADATA
folder, you can delete existing files in that location which correnponds
to the new database which you have created.
5. copy spfile (if you backed up from previous database) to
$ORACLE_HOME/database folder and change parameter control_files if
needed.
6. startup mount the database.
7. rename data , online logs if the location is not same as it was in
previous server.
8. Open the database.
9. If you have not created database (as described in step 2) then you
will have to create a service via oradim.
10. create/copy parameter file to the new machine/server.
11. copy all datafile to the new server in the location which you want.
12. startup mount
13. rename datafiles,online redo logs if location is not the same as it
was in previous server.
14. open the database.
And that's all.
oradim -new -sid sid -startmode auto -pfile file
****************
suppose i take a close bkup of the database after shifting the db to archivelog mode.
now i want to restore the dbase after one week (let saY).. so wht i want to know is
when and where to apply the archvies of the database.. to get the full image until
last entry.
*******************
|
|
|
|
|
|
| Re: closed backup restoration [message #249177 is a reply to message #249058] |
Tue, 03 July 2007 10:20  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | suppose i take a close bkup of the database after shifting the db to archivelog mode.
now i want to restore the dbase after one week (let saY).. so wht i want to know is
when and where to apply the archvies of the database.. to get the full image until
last entry.
|
You cant apply archiveslog on cold backup.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
