Palmer_Admin
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.LO G',
'D:\ORADATA\DEV\REDO021.LO G',
'D:\ORADATA\DEV\REDO031.LO G'
) SIZE 50M,
GROUP 2 (
'D:\ORADATA\DEV\REDO012.LO G',
'D:\ORADATA\DEV\REDO022.LO G',
'D:\ORADATA\DEV\REDO032.LO G'
) SIZE 50M,
GROUP 3 (
'D:\ORADATA\DEV\REDO013.LO G',
'D:\ORADATA\DEV\REDO023.LO G',
'D:\ORADATA\DEV\REDO033.LO G'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'D:\ORADATA\DEV\SYSTEM01.D BF',
'D:\ORADATA\DEV\UNDOTBS01. DBF',
'D:\ORADATA\DEV\SYSAUX01.D BF',
'D:\ORADATA\DEV\USERS01.DB F',
'D:\ORADATA\DEV\TABLES.DBF ',
'D:\ORADATA\DEV\INDEXES.DB F',
'D:\ORADATA\DEV\APP_LOB.DB F',
'D:\ORADATA\DEV\REPORTS.DB F',
'D:\ORADATA\DEV\APP_ARCHIV E_DATA.DBF ',
'D:\ORADATA\DEV\APP_ARCHIV E_INDEX.DB F',
'D:\ORADATA\DEV\MIG.DBF',
'D:\ORADATA\DEV\IAL_DATA.D BF',
'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;
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.LO
'D:\ORADATA\DEV\REDO021.LO
'D:\ORADATA\DEV\REDO031.LO
) SIZE 50M,
GROUP 2 (
'D:\ORADATA\DEV\REDO012.LO
'D:\ORADATA\DEV\REDO022.LO
'D:\ORADATA\DEV\REDO032.LO
) SIZE 50M,
GROUP 3 (
'D:\ORADATA\DEV\REDO013.LO
'D:\ORADATA\DEV\REDO023.LO
'D:\ORADATA\DEV\REDO033.LO
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'D:\ORADATA\DEV\SYSTEM01.D
'D:\ORADATA\DEV\UNDOTBS01.
'D:\ORADATA\DEV\SYSAUX01.D
'D:\ORADATA\DEV\USERS01.DB
'D:\ORADATA\DEV\TABLES.DBF
'D:\ORADATA\DEV\INDEXES.DB
'D:\ORADATA\DEV\APP_LOB.DB
'D:\ORADATA\DEV\REPORTS.DB
'D:\ORADATA\DEV\APP_ARCHIV
'D:\ORADATA\DEV\APP_ARCHIV
'D:\ORADATA\DEV\MIG.DBF',
'D:\ORADATA\DEV\IAL_DATA.D
'D:\ORADATA\DEV\IAL_INDEX.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Feel free to post any errors to this thread and I'll respond. Good luck.
ASKER