Database Backup and Recovery (MOSC)

MOSC Banner

Backup restore to Dev environment

edited Nov 29, 2011 7:55PM in Database Backup and Recovery (MOSC) 6 comments
I need to restore my production database from tape backup to the Development database. My developdatabase has less SGA / PGA size than production. ( 4 GB vs 36 GB) and it is in NOARCHIVELOG mode.

How can I restore to Development database ? I use following script to restore from tape. Can I mention in the script with less memory parameters and no archive log mode?

CONNECT TARGET SYS/PWD@PROD
CONNECT AUXILIARY sys/PWD@DEVP
run
{
SQL 'STARTUP NOMOUNT';
set until time "to_date('11/23/11 10:00:00','mm/dd/yy hh24:mi:ss')";
SET ARCHIVELOG DESTINATION TO 'E:\ORADATA\...........' ------------------------optional if the archlog destination is structurally different

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center