DB refresh
I need to do a DB refresh in quality server.
PRD ONLINE backup should be restore to quality server with HP data protector and recover oracle RDBMS.
We have a quality server up and running, we don't need any kind of data from quality.
so, there is nothing to be exported from quality server.
we have stopped SAP & Oracle services in quality & deleted files with in directories of quality server:-
sapdata<n>,
sapbackup,
oraarch,
contorl files at 3 locations (MirrA, MirrB & Sapdata1),
[sapcheck, sapreorg, saptrace\background, saptrace\usertrace are intact]
We started restoring online backup with help of HP Data protector GUI to Qulaity server.
it got restored to oracle\PRD along with oracle\QUA.
after restoration; we have moved sapdata<n>, oraarch and sapbackup in to oracle\QUA.
Oraarch files were renamed accordingly; PRDARCHARCxxxxx.001 to QUAARCHARCxxxxxx.001
on source system, we have generated control file script with help of "alter database backup controlfile to trace"
we have edited the script for controlfile by considering from " Set #2. RESETLOGS case ".
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "QUA" RESETLOGS NOARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 9344
LOGFILE
GROUP 1 (
'D:\ORACLE\QUA\ORIGLOGA\LOG_G11M1.DBF',
'D:\ORACLE\QUA\MIRRLOGA\LOG_G11M2.DBF'
) SIZE 50M,
GROUP 2 (
'D:\ORACLE\QUA\ORIGLOGB\LOG_G12M1.DBF',
'D:\ORACLE\QUA\MIRRLOGB\LOG_G12M2.DBF'
) SIZE 50M,
GROUP 3 (
'D:\ORACLE\QUA\ORIGLOGA\LOG_G13M1.DBF',
'D:\ORACLE\QUA\MIRRLOGA\LOG_G13M2.DBF'
) SIZE 50M,
GROUP 4 (
'D:\ORACLE\QUA\ORIGLOGB\LOG_G14M1.DBF',
'D:\ORACLE\QUA\MIRRLOGB\LOG_G14M2.DBF'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'D:\ORACLE\QUA\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',
'D:\ORACLE\QUA\SAPDATA3\UNDO_1\UNDO.DATA1',
'D:\ORACLE\QUA\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',
'D:\ORACLE\QUA\SAPDATA1\SR3_1\SR3.DATA1',
'D:\ORACLE\QUA\SAPDATA<n-1>\SR3_<n-1>\SR3.DATA<n-1>',
'D:\ORACLE\QUA\SAPDATA<n>\SR3_<n>\SR3.DATA<n>'
CHARACTER SET UTF8
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\QUA\ORAARCH\QUAARCHARC00001_0723399286.001';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'D:\ORACLE\QUA\SAPDATA2\TEMP_1\TEMP.DATA1'
SIZE 8500M REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE 10000M;
-- End of tempfile additions.
--
Now the problem is that i'm not able to do recovery.
Oracle is getting mounted but not able to recover media.
we haven't tried open database. since, the recovery is not complete.
Request you to guide and correct me in case of any wrong in procedure.
i have attached my PRD backup log.
regards,
Harika