Hi There,
we are restoring full backup of database to a new host.
before that we had also done the same thing and successfully restored the database.
i am following oracle documentaition.
the version is 11R2 on solaris 11
.
the issue is self explanatory give below:
1) restored the spfile from backup piece
2)restored the control file from backup piece
3)then started the database in mount status
)rman > catalog start with 'path_of_backup'
here in this 3rd steps it skipped the bkp piece and just cataloged the controlfile backup.
then we changed the backup location of backup piece and again tried to catalog it.
this time it cataloged the backup piece.
4) then we rename the datafile location with the help of the below command
RMAN> run
2> {
3> SET NEWNAME FOR DATAFILE 4 TO '/bkprestore/database/idealfnd_tbs_01.dbf';
4> SET NEWNAME FOR DATAFILE 5 TO '/bkprestore/database/idealfnd_tbs_02.dbf';
5> SET NEWNAME FOR DATAFILE 6 TO '/bkprestore/database/idealfnd_tbs_03.dbf';
6> SET NEWNAME FOR DATAFILE 7 TO '/bkprestore/database/idealfnd_tbs_04.dbf';
7> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
RMAN>
then we given the command RESTORE DATABASE;
{
RMAN> run
2> {
3> SET NEWNAME FOR DATAFILE 4 TO '/bkprestore/database/idealfnd_tbs_01.dbf';
4> SET NEWNAME FOR DATAFILE 5 TO '/bkprestore/database/idealfnd_tbs_02.dbf';
5> SET NEWNAME FOR DATAFILE 6 TO '/bkprestore/database/idealfnd_tbs_03.dbf';
6> SET NEWNAME FOR DATAFILE 7 TO '/bkprestore/database/idealfnd_tbs_04.dbf';
7> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
RMAN> restore database;
Starting restore at 24-DEC-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=583 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_01.dbf
channel ORA_DISK_1: reading from backup piece /netbackup_72/RMANBKP_IFNDPROD_FULL/DAILY1_bk_4922_1_865312301.bkp
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /orainstall/restore_72/DAILY1_bk_4922_1_865312301.bkp
ORA-19504: failed to create file "/db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_01.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00006 to /db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_03.dbf
channel ORA_DISK_1: reading from backup piece /netbackup_72/RMANBKP_IFNDPROD_FULL/DAILY1_bk_4923_1_865312346.bkp
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /orainstall/restore_72/DAILY1_bk_4923_1_865312346.bkp
ORA-19504: failed to create file "/db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_03.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00007 to /db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_04.dbf
channel ORA_DISK_1: reading from backup piece /netbackup_72/RMANBKP_IFNDPROD_FULL/DAILY1_bk_4924_1_865312353.bkp
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /orainstall/restore_72/DAILY1_bk_4924_1_865312353.bkp
ORA-19504: failed to create file "/db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_04.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /db01_credence/IDEALFND/IDEALFND_DATA/system01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_02.dbf
channel ORA_DISK_1: reading from backup piece /netbackup_72/RMANBKP_IFNDPROD_FULL/DAILY1_bk_4925_1_865312356.bkp
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /orainstall/restore_72/DAILY1_bk_4925_1_865312356.bkp
ORA-19504: failed to create file "/db01_credence/IDEALFND/IDEALFND_DATA/system01.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /db01_credence/IDEALFND/IDEALFND_DATA/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /db01_credence/IDEALFND/IDEALFND_DATA/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /netbackup_72/RMANBKP_IFNDPROD_FULL/DAILY1_bk_4926_1_865312402.bkp
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /orainstall/restore_72/DAILY1_bk_4926_1_865312402.bkp
ORA-19504: failed to create file "/db01_credence/IDEALFND/IDEALFND_DATA/sysaux01.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/24/2014 16:58:17
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
}
So there are two issue in the output.
{
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /db01_credence/IDEALFND/IDEALFND_DATA/idealfnd_tbs_01.dbf
channel ORA_DISK_1: reading from backup piece /netbackup_72/RMANBKP_IFNDPROD_FULL/DAILY1_bk_4922_1_865312301.bkp
}
1 )in the second line above its restoring to the old location of old server although we had given the set new name command to change the location
2) in the second line above its reading from the old backup location although we have updated the rman repository to make the rman to know that the backup pieces are now at different location by using "CATALOG START WITH".
so what is the issue here.