Home » RDBMS Server » Backup & Recovery » Recovery from a different location rather than from backup location
Recovery from a different location rather than from backup location [message #204342] Mon, 20 November 2006 04:08 Go to next message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Hi All,

I am facing a problem while restoring a database from a location where I copied all my backup files.

For Ex:

1). I backed up to a location: C:\Temp\
2). Copied the backed up files from C:\Temp\ to D:\Test\ and trying to restore the files.

It was failing to perform restore.


Please help me.



Regards,
Kamalakar.
Re: Recovery from a different location rather than from backup location [message #204364 is a reply to message #204342] Mon, 20 November 2006 06:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
It was failing to perform restore.

Out of the possible 100,000 reasons to fail, which one are you talking about?
Always post your version,code,exact error message.
Re: Recovery from a different location rather than from backup location [message #204374 is a reply to message #204364] Mon, 20 November 2006 06:56 Go to previous messageGo to next message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Hi Mahesh,

I have tried restoring with RMAN.

I have donethe following:

RMAN> backup database plus archivelog;


Starting backup at 20-NOV-06
using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
Finished backup at 20-NOV-06

Starting backup at 20-NOV-06
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF
input datafile fno=00002 name=C:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF
input datafile fno=00005 name=C:\ORACLE\ORADATA\TEST1\EXAMPLE01.DBF
input datafile fno=00010 name=C:\ORACLE\ORADATA\TEST1\XDB01.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\TEST1\INDX01.DBF
input datafile fno=00009 name=C:\ORACLE\ORADATA\TEST1\USERS01.DBF
input datafile fno=00003 name=C:\ORACLE\ORADATA\TEST1\CWMLITE01.DBF
input datafile fno=00004 name=C:\ORACLE\ORADATA\TEST1\DRSYS01.DBF
input datafile fno=00007 name=C:\ORACLE\ORADATA\TEST1\ODM01.DBF
input datafile fno=00008 name=C:\ORACLE\ORADATA\TEST1\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 20-NOV-06
channel ORA_DISK_1: finished piece 1 at 20-NOV-06
piece handle=E:\TEMPDEST\STD_04I2SU33_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:46
Finished backup at 20-NOV-06

Starting backup at 20-NOV-06
using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
Finished backup at 20-NOV-06

Starting Control File and SPFILE Autobackup at 20-NOV-06
piece handle=E:\TEMPDEST\CTL_C-984051631-20061120-02 comment=NONE
Finished Control File and SPFILE Autobackup at 20-NOV-06

RMAN> restore database;

Starting restore at 20-NOV-06

using channel ORA_DISK_1
skipping datafile 1; already restored to file C:\ORACLE\ORADATA\TEST1\SYSTEM01.D
BF
skipping datafile 2; already restored to file C:\ORACLE\ORADATA\TEST1\UNDOTBS01.
DBF
skipping datafile 3; already restored to file C:\ORACLE\ORADATA\TEST1\CWMLITE01.
DBF
skipping datafile 4; already restored to file C:\ORACLE\ORADATA\TEST1\DRSYS01.DB
F
skipping datafile 5; already restored to file C:\ORACLE\ORADATA\TEST1\EXAMPLE01.
DBF
skipping datafile 6; already restored to file C:\ORACLE\ORADATA\TEST1\INDX01.DBF

skipping datafile 7; already restored to file C:\ORACLE\ORADATA\TEST1\ODM01.DBF
skipping datafile 8; already restored to file C:\ORACLE\ORADATA\TEST1\TOOLS01.DB
F
skipping datafile 9; already restored to file C:\ORACLE\ORADATA\TEST1\USERS01.DB
F
skipping datafile 10; already restored to file C:\ORACLE\ORADATA\TEST1\XDB01.DBF

restore not done; all files readonly, offline, or already restored
Finished restore at 20-NOV-06

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 730931140 bytes

Fixed Size 454596 bytes
Variable Size 285212672 bytes
Database Buffers 444596224 bytes
Redo Buffers 667648 bytes

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 730931140 bytes

Fixed Size 454596 bytes
Variable Size 285212672 bytes
Database Buffers 444596224 bytes
Redo Buffers 667648 bytes

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'E:\TempDest\CTL
_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'E:\TempDest\std_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\TEMPDEST\SNCFTEST1.ORA';

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'E:\TempDest3\std_%U';

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'E:\TempDest\std_%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'E:\TempDest3\std_%U';
new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'E:\TempDe
st3\CTL_%F';

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'E:\TempDest\CTL
_%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'E:\TempDest3\CT
L_%F';
new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\TempDest3\SNCFTEST1.ORA';

snapshot controlfile name set to: E:\TempDest3\SNCFTEST1.ORA
new RMAN configuration parameters are successfully stored

RMAN> restore database;

Starting restore at 20-NOV-06

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\ORADATA\TEST1\CWMLITE01.DBF
restoring datafile 00004 to C:\ORACLE\ORADATA\TEST1\DRSYS01.DBF
restoring datafile 00005 to C:\ORACLE\ORADATA\TEST1\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\ORADATA\TEST1\INDX01.DBF
restoring datafile 00007 to C:\ORACLE\ORADATA\TEST1\ODM01.DBF
restoring datafile 00008 to C:\ORACLE\ORADATA\TEST1\TOOLS01.DBF
restoring datafile 00009 to C:\ORACLE\ORADATA\TEST1\USERS01.DBF
restoring datafile 00010 to C:\ORACLE\ORADATA\TEST1\XDB01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/20/2006 18:20:19
ORA-19505: failed to identify file "E:\TEMPDEST\STD_04I2SU33_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.

RMAN>


Please check the error information.


Regards,
Kamalakar.
Re: Recovery from a different location rather than from backup location [message #204450 is a reply to message #204374] Mon, 20 November 2006 17:24 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Still no version specified as Mahesh requested, but from your CONFIGURE parameters it appears that you are NOT on 10g.

Prior to 10g, you cannot catalog backup sets or pieces. Therefore, you should copy the backup sets or pieces to the location set when the backup was conducted.
Previous Topic: Problems while Restoring Hot Backup
Next Topic: Doubt regarding Standby Database Creation
Goto Forum:
  


Current Time: Thu Dec 08 16:17:50 CST 2016

Total time taken to generate the page: 0.04811 seconds