Home » RDBMS Server » Backup & Recovery » New backup on networkdrive - cant read from new host (RDBMS10.2.0.4, Win2003 x86, RMAN)
New backup on networkdrive - cant read from new host [message #520929] Thu, 25 August 2011 08:23 Go to next message
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

Re: New backup on networkdrive - cant read from new host [message #520931 is a reply to message #520929] Thu, 25 August 2011 08:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle mostly does not support network drives on Windows.

Regards
Michel

[Updated on: Thu, 25 August 2011 08:35]

Report message to a moderator

Re: New backup on networkdrive - cant read from new host [message #520943 is a reply to message #520931] Thu, 25 August 2011 09:37 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Ok, I see.

Would it be possible to just move the backups to the test host and then tell RMAN where to look for them (the backup)? Instead of trying to use a network drive.


Regards
H
Re: New backup on networkdrive - cant read from new host [message #520948 is a reply to message #520943] Thu, 25 August 2011 10:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, just use COPY command to copy and CATALOG RMAN commands if you copy the backup in another place (path) than the original one.

Regards
Michel
Re: New backup on networkdrive - cant read from new host [message #520954 is a reply to message #520948] Thu, 25 August 2011 10:38 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Ok, thanks, I will try that.

Do I use:

connect target sys/password@pdm;
connect auxiliary /;



When doing the CATALOG command? As I would like this to work with the script.

Regards
H
Re: New backup on networkdrive - cant read from new host [message #520955 is a reply to message #520954] Thu, 25 August 2011 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do I use:

I depends on what you want to do.
You can simply copy the backup on test machine and restore it.

Regards
Michel
Re: New backup on networkdrive - cant read from new host [message #520956 is a reply to message #520955] Thu, 25 August 2011 10:44 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
I would like to use the script.

Regards
H
Re: New backup on networkdrive - cant read from new host [message #520960 is a reply to message #520956] Thu, 25 August 2011 11:22 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Well, I solved it.

It should say:


RUN
{ 
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '\\hostname\restore\restore\%U';
BACKUP DATABASE PLUS ARCHIVELOG;
}



And nothing else.

Then I can access my network backup using RMAN.

Regards
H
Re: New backup on networkdrive - cant read from new host [message #520962 is a reply to message #520956] Thu, 25 August 2011 11:24 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So wait for someone else.

Regards
Michel
Previous Topic: change archive log mode during DB running
Next Topic: ORA-01422: exact fetch returns more than requested number of
Goto Forum:
  


Current Time: Thu Mar 28 03:32:45 CDT 2024