Can't read RMAN files when restoring an instance from scratch
Date: Wed, 22 Jun 2011 13:16:57 -0700 (PDT)
Message-ID: <e7006619-48fe-4073-af12-d659f4859568_at_z7g2000prh.googlegroups.com>
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_at_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\ Received on Wed Jun 22 2011 - 15:16:57 CDT