How to recover (clone) DB from RAC+ASM
i need help how to clone (recover) our prod database to another server from disk (tape). Our prod database is in RAC with ASM and I need to clone it to different server without ASM and RAC. Everything is Win2003 Srv.
I do it this way:
1. On prod server i make backup running this script in RMAN
configure channel device type 'SBT_TAPE' parms'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=e:\backup)';
backup device type SBT_TAPE database tag zal20081129;
SQL 'alter system archive log current';
backup device type SBT_TAPE archivelog ALL tag zal20081129;
2. I prepared clon instance on another server (The same Oracle version) and start it to nomount mode.
3. I copied the backup from prod server to clon server to exactly the same path. (e:\backup)
4. On clon server i connect to RMAN
connect target /
set DBID 3079749916 - that is DBID from our prod DB
allocate CHANNEL CTAPE DEVICE TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=e:\backup)';
allocate channel CDISK DEVICE TYPE DISK;
restore controlfile from 'e:\backup\name_of_backup_file'; -this restore control file correctly
alter database mount;
Set newname for datafile 1 to 'e:\oradata\CLON\system.272.668509367';
Set newname for datafile 2 to 'e:\oradata\CLON\undotbs1.273.668509387';
Set newname for datafile 3 to 'e:\oradata\CLON\sysaux.263.668509393';
Set newname for datafile 4 to 'e:\oradata\CLON\ifsapp_archive_data.298.668509401';
Set newname for datafile 5 to 'e:\oradata\CLON\ifsapp_archive_index.258.668509401';
switch datafile all;
But i got this error
datafile 16 switched to datafile copy
input datafile copy recid=84 stamp=672939884 filename=E:\ORADATA\AGOST\IFSAPP_DATA.300.668510859
datafile 17 switched to datafile copy
input datafile copy recid=85 stamp=672939884 filename=E:\ORADATA\AGOST\IFSAPP_DATA.301.668510865
Starting recover at 08-DEC-08
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1
starting media recovery
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORADATA\AGOST\SYSTEM.272.668509367'
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of recover command at 12/08/2008 15:45:14
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 227 lowscn 800414116 found to restore
Shall i set any SET UNTIL clause???? or what is wrong. Why Oracle doesnt recover just to the point of the backup saved in e:\backup?
When restoring from a hot backup recovery is always needed meaning, logs generated until the end of the backup have to be available for recovery.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Thanks for you answer,
but I do have the archived logs in my backup. The whole backup has this structure:
1. 2qk18tcm_1_1 40GB = datafiles
2. 2rk193jm_1_1 15MB = controlfiles, spfile
3. 2sk193kn_1_1 5GB = archived logs
so the recovery process should use the archived logs. Even log from the backup shows, that the file is in the backup.
Part of the backup log:
input archive log thread=1 sequence=225 recid=422 stamp=672393041
input archive log thread=1 sequence=226 recid=424 stamp=672409469
input archive log thread=1 sequence=227 recid=426 stamp=672431129
input archive log thread=1 sequence=228 recid=427 stamp=672435840
input archive log thread=1 sequence=229 recid=430 stamp=672435856
So i dont know whats wrong?
Click Here to Expand Forum to Full Width