Link to home
Start Free TrialLog in
Avatar of Palmer_Admin
Palmer_AdminFlag for United States of America

asked on

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

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;
ASKER CERTIFIED SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Palmer_Admin

ASKER

thank you. I just wanted to confirm
Feel free to post any errors to this thread and I'll respond. Good luck.