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

Palmer_Admin
Palmer_Admin used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2009
Commented:
Looks good to me at a glance. The only reason you have to re-create the control file is to rename the instance, otherwise you could simply startup under the PROD $ORACLE_SID without resetlogs.

Author

Commented:
thank you. I just wanted to confirm
Top Expert 2009

Commented:
Feel free to post any errors to this thread and I'll respond. Good luck.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial