Restore backup from another (non-default) location [message #426895] |
Tue, 20 October 2009 04:45  |
chetanaZ
Messages: 132 Registered: October 2009 Location: UK
|
Senior Member |
|
|
Hi,
I have RMAN backup on one host and I want to restore it one another host by copying at OS level
One assumption is that the path of the backup on the new host must be same as path of backup on original host
In linux we can simulate this using symbol link
Is there a way to simulate this in windows environment?
Is there a way to restore the backup from the location (meaning at different path than it was on original host)?
E.g. like restore of controlfile backup using 'set controlfile autobackup format' or 'restore controlfile from'
The following quote in Oracle documentation states about the possibility but not clear enough if we are not using CATLAOG
Restoring the Database to a New Host
Quote:
You cannot use RMAN to restore disk backups or image copies created on one host to a new host. Nevertheless, you can transfer the files with an operating system utility. If the files are in the same location in the new host, then you do not need to recatalog them. If you transfer the files to new location, then use the CATALOG command to update the RMAN repository with the new filenames and use the CHANGE ... UNCATALOG command to uncatalog the old filename
Thanks and Regards,
Chetana
|
|
|
|
Re: Restore backup from another (non-default) location [message #426904 is a reply to message #426895] |
Tue, 20 October 2009 05:20   |
chetanaZ
Messages: 132 Registered: October 2009 Location: UK
|
Senior Member |
|
|
Hi Michel,
Thanks for the quick reply
I want to know how to recover backup 'from' nondefault location
while backup taken on host1 it was at /u05/backup_loc1
This backup was copied to /u06/backup_loc2 on host2
Now I want to restore it from /u06/backup_loc2 (where as the controfile still thinks it will find backup in /u05/backup_loc1 only
How to do this?
If my understanding is clear the link you sent clears 2 things
1) How to restore archivelogs from nondefault location (but not states about backups at nondefault location)
2) Restoring 'to' nondefault location (we are looking 'from' location)
Thanks and Regards,
Chetana
|
|
|
|
Re: Restore backup from another (non-default) location [message #426908 is a reply to message #426895] |
Tue, 20 October 2009 05:39   |
chetanaZ
Messages: 132 Registered: October 2009 Location: UK
|
Senior Member |
|
|
Thanks Michel,
So in my case after I copy the backup to /u06/backup_loc2, I will follow the steps :
startup nomount
restore controlfile from '..';
CATALOG backuppiece '/u06/backup_loc2/backuppiece1.bcp'
CATALOG backuppiece '/u06/backup_loc2/backuppiece2.bcp'
CATALOG backuppiece '/u06/backup_loc2/backuppiece3.bcp'
...
mount database;
restore database;
recover database;
I am not using recovery catalog in that case can I use above method?
I assume this can be used in 9i.
Thanks and Regards,
Chetana
|
|
|
|
|
|
Re: Restore backup from another (non-default) location [message #427012 is a reply to message #426895] |
Tue, 20 October 2009 10:16   |
chetanaZ
Messages: 132 Registered: October 2009 Location: UK
|
Senior Member |
|
|
Hi Ebrian,
Thanks for the followup
Just discovered the same an hour back as described following
seems there is command 'mklink' on windows to create such symbolic link
Not sure if I will be able to try
I will post results in case I am able to create one
Thanks and Regards,
Chetana
RMAN> CATALOG backuppiece 'F:\one\two\db02\db02_20091020_6635_1.BAK';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "backuppiece": expecting one of: "archivelog, backup, controlfilecopy, clone, datafilecopy"
RMAN-01007: at line 1 column 9 file: standard input
RMAN> catalog backuppiece 'F:\one\two\db02\db02_20091020_6635_1.BAK';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "backuppiece": expecting one of: "archivelog, backup, controlfilecopy, clone, datafilecopy"
RMAN-01007: at line 1 column 9 file: standard input
RMAN> catalog backup 'F:\one\two\db02\db02_20091020_6635_1.BAK';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "single-quoted-string": expecting one of: "controlfile"
RMAN-01007: at line 1 column 16 file: standard input
RMAN>
|
|
|
|