Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Restore off-line database
Susja
post May 19 2017, 07:25 PM
Post #1


Member
**

Group: Members
Posts: 13
Joined: 20-March 17
Member No.: 51,849



Hello
I have a laboratory device which is connected to PC running Windows 7 and use Oracle 11.2
We are doing daily backups but never had a chance to verify that it'll work if required I.e never tried to restore.
I have another PC also running Windows 7. This PC is off-line.
Here's my proposal:
1. I'll go to Oracle.com and download Oracle 11.2 database software
2. I will install Oracle on that PC
3. I'll take one of the daily backup and try to restore it on that PC
4. I expect to get same database I have on 'original' location.
Do you think it's feasible/implementable?
Thanks
Go to the top of the page
 
+Quote Post
burleson
post Today, 10:19 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,409
Joined: 26-January 04
Member No.: 13



Hi Susja,

Sorry about the delay in responding.

>> never had a chance to verify that it'll work if required I.e never tried to restore.

You should ALWAYS test a recovery before relying on it:

http://www.dba-oracle.com/t_oracle_system_testing_areas.htm

Take the time to ensure that you can recover!

****************************************************************

>> Do you think it's feasible/implementable?

This is a COLD backup, taken while the database is down.

Yes, this should work fine!

See here for details:

http://www.dba-oracle.com/t_windows_cold_backup_script.htm

Good Luck!






--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd May 2017 - 06:15 PM