Solved

Restoring / recover to a readonly database

Posted on 2013-02-06
4
247 Views
Last Modified: 2013-02-14
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
Comment
Question by:DarrenJackson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38859226
0
 

Author Comment

by:DarrenJackson
ID: 38859304
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
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 38859333
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
 

Author Closing Comment

by:DarrenJackson
ID: 38888071
Great have created my standby

Thanks alot
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question