New backup on networkdrive - cant read from new host [message #520929] |
Thu, 25 August 2011 08:23 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Hi!
I take a backup on PROD and want to use that backup on test to duplicate the PROD db.
I ran this first on PROD:
connect catalog rman11cv/password@metarep
connect target /
RUN
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'G:\restore\%U';
BACKUP DATABASE PLUS ARCHIVELOG;
}
I runs fine.
I map the network drive on my TEST machine. I run the script:
connect target sys/password@pdm;
connect auxiliary /;
run {
allocate auxiliary channel 'ch1' type disk;
SET NEWNAME FOR DATAFILE 1 TO 'D:\oracle\oradata\database\data\SYSTEM01.DBF';
SET NEWNAME FOR DATAFILE 2 TO 'D:\oracle\oradata\database\data\UNDOTBS01.DBF';
SET NEWNAME FOR DATAFILE 3 TO 'D:\oracle\oradata\database\data\CWMLITE01.DBF';
SET NEWNAME FOR DATAFILE 4 TO 'D:\oracle\oradata\database\data\DRSYS01.DBF';
SET NEWNAME FOR DATAFILE 5 TO 'D:\oracle\oradata\database\data\EXAMPLE01.DBF';
SET NEWNAME FOR DATAFILE 6 TO 'D:\oracle\oradata\database\data\INDX01.DBF';
SET NEWNAME FOR DATAFILE 7 TO 'D:\oracle\oradata\database\data\ODM01.DBF';
SET NEWNAME FOR DATAFILE 8 TO 'D:\oracle\oradata\database\data\TOOLS01.DBF';
SET NEWNAME FOR DATAFILE 9 TO 'D:\oracle\oradata\database\data\USERS01.DBF';
SET NEWNAME FOR DATAFILE 10 TO 'D:\oracle\oradata\database\data\XDB01.DBF';
SET NEWNAME FOR DATAFILE 11 TO 'D:\oracle\oradata\database\data\ARCHIVEDATA_01.DBF';
SET NEWNAME FOR DATAFILE 12 TO 'D:\oracle\oradata\database\data\DATA_01.DBF';
SET NEWNAME FOR DATAFILE 13 TO 'D:\oracle\oradata\database\data\DATA_01.DBF';
SET NEWNAME FOR DATAFILE 14 TO 'D:\oracle\oradata\database\data\DATA_01.DBF';
SET NEWNAME FOR DATAFILE 15 TO 'D:\oracle\oradata\database\data\INDX_01.DBF';
SET NEWNAME FOR DATAFILE 16 TO 'D:\oracle\oradata\database\data\LDATA_01.DBF';
SET NEWNAME FOR DATAFILE 17 TO 'D:\oracle\oradata\database\data\LINDX_01.DBF';
SET NEWNAME FOR DATAFILE 18 TO 'D:\oracle\oradata\database\data\OTHERINDX_01.DBF';
SET NEWNAME FOR DATAFILE 19 TO 'D:\oracle\oradata\database\data\CINDX_01.DBF';
SET NEWNAME FOR DATAFILE 20 TO 'D:\oracle\oradata\database\data\CHINDX_01.DBF';
SET NEWNAME FOR DATAFILE 21 TO 'D:\oracle\oradata\database\data\SYSAUX01.DBF';
SET NEWNAME FOR DATAFILE 22 TO 'd:\oracle\ORADATA\database\DATA\LAD_02.DBF';
SET NEWNAME FOR TEMPFILE 1 TO 'D:\oracle\oradata\database\data\TEMP01.DBF';
set archivelog destination to 'D:\oracle\oradata\database\arch';
SET UNTIL logseq 11109 THREAD 1;
#set until time "to_date('Aug 30 2010 09:59:16','Mon DD YYYY HH24:MI:SS')";
#set until time "to_date('Oct 11 2010 09:19:24','Mon DD YYYY HH24:MI:SS')";
#set until time "to_date('Feb 08 2011 12:12:12','Mon DD YYYY HH24:MI:SS')";
#set until time "to_date('Mar 24 2011 09:08:43','Mon DD YYYY HH24:MI:SS')";
#set until time "to_date('Apr 04 2011 08:58:11','Mon DD YYYY HH24:MI:SS')";
#set until time "to_date('Jun 13 2011 08:59:48','Mon DD YYYY HH24:MI:SS')";
duplicate target database to database
logfile
group 1('c:\oracle\oradata\database\redo\REDO01A.RDO','d:\oracle\oradata\database\redo\REDO01B.RDO') SIZE 100M,
group 2('c:\oracle\oradata\database\redo\REDO02A.RDO','d:\oracle\oradata\database\redo\REDO02B.RDO') SIZE 100M,
group 3('c:\oracle\oradata\database\redo\REDO03A.RDO','d:\oracle\oradata\database\redo\REDO03B.RDO') SIZE 100M;
}
Its trying to read from the right backupset.
But Im not sure it can see it:
channel ch1: reading from backup piece G:\RESTORE\N3MKSOMQ_1_1
ORA-19870: error reading backup piece G:\RESTORE\N3MKSOMQ_1_1
ORA-19505: failed to identify file "G:\RESTORE\N3MKSOMQ_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup
Net view of the PROD host gives this:
D:\oracle\admin\duplicate\PDMTEST>net view myprod
Shared resources at myprod
Share name Type Used as Comment
--------------------------------------------------------
restore Disk G:
The command completed successfully.
Any ideas?
Regards
H
[Updated on: Thu, 25 August 2011 08:27] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|