• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Restoring / recover to a readonly database

Guys

Just a quick couple of questions

I am looking to create a readonly version copy of my live oracle database at present I am copying over the backup of the database via a script then based on a CRON job a script is executed at 05:00 am in the morning to restore then recover this takes time
my question is
1. Can I just recover using the archive logs from my live environment saving me the time to restore
ie
sqlplus /nolog
conn / as sysdba
startup mount
recover database until cancel
auto

because it is readonly do I need to create redologs?? and a tempfile??

btw I'm using Linux as my os


Any Help will be appreciated

Regards

Darren
0
DarrenJackson
Asked:
DarrenJackson
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
0
 
DarrenJacksonAuthor Commented:
Thanks is there another way  does this not need to have oracle enterprise edition my live environment is enterprise but my read only version location is standard edition.

Thanks
0
 
slightwv (䄆 Netminder) Commented:
From a quick Google, it looks like you can create a standby database on Standard Edition.

I've never used a standby database so I cannot confirm if this is accurate:
https://forums.oracle.com/forums/thread.jspa?messageID=9166289

http://www.databasejournal.com/features/oracle/article.php/3682421/Manual-Standby-Database-under-Oracle-Standard-Edition.htm
0
 
DarrenJacksonAuthor Commented:
Great have created my standby

Thanks alot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now