troubleshooting Question

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

Avatar of Palmer_Admin
Palmer_AdminFlag for United States of America asked on
Oracle Database
3 Comments1 Solution518 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros