Can't read RMAN files when restoring an instance from scratch

[Big George]

I need to test my RMAN backups in a different server and create
database from scratch.

Thanks to John Hurley, I could mount the instance in target server and
be ready to restore database.

My rman FuLL and Incremental backups are in: \\192.168.1.149\G$
\XXXSRV4-ARCLOGS\MTDPROD\RMAN\

Instance: MTDPROD

I created a copy of the spfile from source server and startup my
instance with a startup pfile= type thing.

sqlplus based ...
create pfile='/somewhere/init_mtdprod_copy.ora' from spfile;

rman based ...
copy current controlfile to '/somewhere/MTDPROD_CTRLFILE_COPY.CTL';

And then in target server:

C:\>oradim -new -sid MTDPROD -intpwd mtdprod
Instance created

-- I created the relevant folder hierarchy under <ORACLE_BASE>
directory
-- Then, I created the relevant directories for Oracle Database, as
follows:
-- a. Create BDUMP, CDUMP, and UDUMP directories under '<ORACLE_ BASE>
\admin' directory,
-- b. Create <DATABASE_NAME> directory under '<ORACLE_BASE>\oradata'
directory; in my case MTDPROD

C:\> set oracle_sid=MTDPROD

C:\> rman

RMAN> connect target sys
connected to target database (not started)

RMAN> set dbid=2169285856

RMAN > STARTUP force nomount PFILE=C:\oracle\product
\10.2.0\db_1\database\init_mtdprod_copy.ora

RMAN> restore controlfile from 'C:\oracle\product\10.2.0\db_1\database
\MTDPROD_CTRLFILE_COPY.CTL';

RMAN> alter database mount;

-- Everything worked very well.

-- Now my problem is trying to restore and recover database.

RMAN> restore database;

-- Get errors: ora-19870 ora-19505 ora-27041
Messages:

Starting restore at 22-JUN-11
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to D:\BD_MTDPROD\UNDO\UNDOTBS01.DBF
restoring datafile 00006 to D:\BD_MTDPROD\DATAFILES_IDX\INDXNET.ORA
restoring datafile 00011 to D:\BD_MTDPROD\DATAFILES_DATA\MSE2.ORA
restoring datafile 00012 to D:\BD_MTDPROD\DATAFILES_DATA
\EXPEDIENTES3.ORA
restoring datafile 00013 to D:\BD_MTDPROD\DATAFILES_DATA
\MSE_BLOB_IDX.ORA
restoring datafile 00015 to D:\BD_MTDPROD\DATAFILES_DATA
\EXPEDIENTES4.ORA
restoring datafile 00016 to D:\BD_MTDPROD\DATAFILES_DATA
\RESOLUCIONES.ORA
restoring datafile 00017 to D:\BD_MTDPROD\DATAFILES_DATA\MSE_AUD.ORA
channel ORA_DISK_1: reading from backup piece \\192.168.1.149\G$
\XXXSRV4-ARCLOGS
\MTDPROD\RMAN\INCR_MTDPROD_20110622_482_1.BAK
ORA-19870: error reading backup piece \\192.168.1.149\G$\XXXSRV4-
ARCLOGS\MTDPROD
\RMAN\INCR_MTDPROD_20110622_482_1.BAK
ORA-19505: failed to identify file "\\192.168.1.149\G$\XXXSRV4-ARCLOGS
\MTDPROD\R
MAN\INCR_MTDPROD_20110622_482_1.BAK"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to D:\BD_MTDPROD\DATAFILES_DATA
\EXPEDIENTES1.ORA
restoring datafile 00008 to D:\BD_MTDPROD\DATAFILES_DATA
\MSEGURIDAD.ORA
restoring datafile 00014 to D:\BD_MTDPROD\DATAFILES_DATA\MSE3.ORA
channel ORA_DISK_1: reading from backup piece \\192.168.1.149\G$
\XXXSRV4-ARCLOGS
\MTDPROD\RMAN\INCR_MTDPROD_20110622_483_1.BAK
ORA-19870: error reading backup piece \\192.168.1.149\G$\XXXSRV4-
ARCLOGS\MTDPROD
\RMAN\INCR_MTDPROD_20110622_483_1.BAK
ORA-19505: failed to identify file "\\192.168.1.149\G$\XXXSRV4-ARCLOGS
\MTDPROD\R
MAN\INCR_MTDPROD_20110622_483_1.BAK"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\BD_MTDPROD\CONTROLFILES\SYSTEM01.DBF
restoring datafile 00003 to D:\BD_MTDPROD\CONTROLFILES\SYSAUX01.DBF
restoring datafile 00004 to D:\BD_MTDPROD\CONTROLFILES\USERS01.DBF
restoring datafile 00007 to D:\BD_MTDPROD\DATAFILES_DATA\MSE.ORA
restoring datafile 00009 to D:\BD_MTDPROD\DATAFILES_DATA\MTD.ORA
restoring datafile 00010 to D:\BD_MTDPROD\DATAFILES_DATA
\EXPEDIENTES2.ORA
restoring datafile 00018 to D:\BD_MTDPROD\DATAFILES_DATA
\RESOLUCIONES_BLOB.ORA
channel ORA_DISK_1: reading from backup piece \\192.168.1.149\G$
\XXXSRV4-ARCLOGS
\MTDPROD\RMAN\INCR_MTDPROD_20110622_484_1.BAK
ORA-19870: error reading backup piece \\192.168.1.149\G$\XXXSRV4-
ARCLOGS\MTDPROD
\RMAN\INCR_MTDPROD_20110622_484_1.BAK
ORA-19505: failed to identify file "\\192.168.1.149\G$\XXXSRV4-ARCLOGS
\MTDPROD\R
MAN\INCR_MTDPROD_20110622_484_1.BAK"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
failover to previous backup

RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of restore command at 06/22/2011 12:33:16
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore

I tried to reset incarnation:

reset database to incarnation 1;
or
reset database to incarnation 2;

But no success.

It could be possible something with catalog.

My RMAN bat for Incremental backups run with nocatalog:
rman nocatalog target sys/documentito@mtdprod @D:\BD_MTDPROD
\backincr.sql log=D:\BD_MTDPROD\backincr.log

When restoring database and if I tried to catalog backups, would I
alter something in \\192.168.1.149\G$\XXXSRV4-ARCLOGS\MTDPROD\RMAN\

[S. Anthony Sequeira]

On 22/06/11 21:16, Big George wrote:
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 5) Access is denied.

Check this out.

--
S. Anthony Sequeira
+44 7542 455 233
++
index, n.:
Alphabetical list of words of no possible interest where an
alphabetical list of subjects with references ought to be.
++

[Mladen Gogala]

On Wed, 22 Jun 2011 13:16:57 -0700, Big George wrote:

> O/S-Error: (OS 5) Access is denied.

Now, there is a real mystery here.

--
http://mgogala.byethost5.com

[Big George]

Thank you. Problem was that OracleService<SID> was running with local
account, and that local account doesn't have permission to my remote
server where RMAN files are.
Solved assigning (in Windows Services) another windows account to run
OracleService<SID>. That another windows account does have permission
to remote server.