We help IT Professionals succeed at work.
Get Started

How do I update DEV database with most recent copy of LIVE?

Palmer_Admin
Palmer_Admin asked
on
515 Views
Last Modified: 2013-12-18
Hi,
I am trying to update our DEV with sunday's copy of LIVE db.
I took a cold backup of live db with all the files.
I copied it over to test server. It is exact same file structure.
I have this sql statement but I am not sure that I need to ALTER before starting this sql statement.
Do I need to ALTER anything or I can just fire up this SQL statement?

here is the content of SQL statement:
STARTUP NOMOUNT
CREATE CONTROLFILE set DATABASE "DEV" RESETLOGS  noARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 4540
LOGFILE
  GROUP 1 (
    'D:\ORADATA\DEV\REDO011.LOG',
    'D:\ORADATA\DEV\REDO021.LOG',
    'D:\ORADATA\DEV\REDO031.LOG'
  ) SIZE 50M,
  GROUP 2 (
    'D:\ORADATA\DEV\REDO012.LOG',
    'D:\ORADATA\DEV\REDO022.LOG',
    'D:\ORADATA\DEV\REDO032.LOG'
  ) SIZE 50M,
  GROUP 3 (
    'D:\ORADATA\DEV\REDO013.LOG',
    'D:\ORADATA\DEV\REDO023.LOG',
    'D:\ORADATA\DEV\REDO033.LOG'
  ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  'D:\ORADATA\DEV\SYSTEM01.DBF',
  'D:\ORADATA\DEV\UNDOTBS01.DBF',
  'D:\ORADATA\DEV\SYSAUX01.DBF',
  'D:\ORADATA\DEV\USERS01.DBF',
  'D:\ORADATA\DEV\TABLES.DBF',
  'D:\ORADATA\DEV\INDEXES.DBF',
  'D:\ORADATA\DEV\APP_LOB.DBF',
  'D:\ORADATA\DEV\REPORTS.DBF',
  'D:\ORADATA\DEV\APP_ARCHIVE_DATA.DBF',
  'D:\ORADATA\DEV\APP_ARCHIVE_INDEX.DBF',
  'D:\ORADATA\DEV\MIG.DBF',
  'D:\ORADATA\DEV\IAL_DATA.DBF',
  'D:\ORADATA\DEV\IAL_INDEX.DBF'
CHARACTER SET WE8MSWIN1252
;
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORADATA\DEV\TEMP01.DBF'
     SIZE 1206M REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
alter database rename global_name to dev;
Comment
Watch Question
Top Expert 2009
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE