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;
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.