Home » RDBMS Server » Backup & Recovery » Restore backup from another (non-default) location (Oracle 9.2.0.6.0)  () 1 Vote
Restore backup from another (non-default) location [message #426895] Tue, 20 October 2009 04:45 Go to next message
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 #426899 is a reply to message #426895] Tue, 20 October 2009 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/osrecov.htm#sthref1330

Regards
Michel
Re: Restore backup from another (non-default) location [message #426904 is a reply to message #426895] Tue, 20 October 2009 05:20 Go to previous messageGo to next message
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 #426905 is a reply to message #426904] Tue, 20 October 2009 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh I misunderstood the question.
Yes you have to use CATALOG to catalog the new location of the backup.

Regards
Michel

[Updated on: Tue, 20 October 2009 05:25]

Report message to a moderator

Re: Restore backup from another (non-default) location [message #426908 is a reply to message #426895] Tue, 20 October 2009 05:39 Go to previous messageGo to next message
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 #426952 is a reply to message #426908] Tue, 20 October 2009 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I didn't do it previously but I'd say it is correct but test it on a test server for a small test database.

Regards
Michel
Re: Restore backup from another (non-default) location [message #426955 is a reply to message #426895] Tue, 20 October 2009 07:07 Go to previous messageGo to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Sure. I will try and will post the results

Thanks Michel

Regards,
Chetana
Re: Restore backup from another (non-default) location [message #427002 is a reply to message #426908] Tue, 20 October 2009 09:43 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
CATALOG of backuppieces is not available in 9i. You can only catalog CONTROLFILECOPY, DATAFILECOPY and ARCHIVELOGS in 9i.

You can perform certain network mappings on Windows to emulate symbolic links.
Re: Restore backup from another (non-default) location [message #427012 is a reply to message #426895] Tue, 20 October 2009 10:16 Go to previous messageGo to next message
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>
Re: Restore backup from another (non-default) location [message #427015 is a reply to message #427012] Tue, 20 October 2009 10:34 Go to previous message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, I didn't check your version before posting.

Regards
Michel
Previous Topic: Restore database Until Time: possibility
Next Topic: Incomplete Recover - Srt Until time - Date format
Goto Forum:
  


Current Time: Sun Sep 25 19:42:02 CDT 2016

Total time taken to generate the page: 0.12748 seconds