| Recovery from a different location rather than from backup location [message #204342] |
Mon, 20 November 2006 04:08  |
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 #204374 is a reply to message #204364] |
Mon, 20 November 2006 06:56  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
