restoring a backupset to a new machine [message #128021] |
Thu, 14 July 2005 12:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pblue
Messages: 3 Registered: July 2005 Location: Berlin
|
Junior Member |
|
|
Hi!
I have a compressed backupset (oracle 10g, full database backup with controlfiles) and I want to restore it on a different machine with an a fresh oracle installation (same version).
How do I proceed?!
Thanks a lot.
pb
|
|
|
|
Re: restoring a backupset to a new machine [message #128031 is a reply to message #128021] |
Thu, 14 July 2005 13:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pblue
Messages: 3 Registered: July 2005 Location: Berlin
|
Junior Member |
|
|
The problem I have is that on the machine I want to restore the database to is only a fresh oracle installation.
If I create a new instance on it and connect to it with rman, I cannot catalog the backup and restore it. rman complains that the DBID from the source of the backupset is different to the target db DBID.
Sorry, if this is sort of strange question, I am new to the subject.
Thanks,
pb
|
|
|
Re: restoring a backupset to a new machine [message #128033 is a reply to message #128031] |
Thu, 14 July 2005 14:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank Naude
Messages: 4579 Registered: April 1998
|
Senior Member |
|
|
You need to set the DBID in your script. This example is from the RMAN Manual:
Quote: | rman TARGET / CATALOG rman/rman@catdb
RMAN> STARTUP FORCE NOMOUNT;
RMAN> SET DBID = 862893450; # needed to distinguish target from others with same DB_NAME
RMAN> RESTORE CONTROLFILE; # assuming catalog has automatic channel allocation information
RMAN> ALTER DATABASE MOUNT;
|
Best regards.
Frank
|
|
|
Re: restoring a backupset to a new machine [message #128182 is a reply to message #128033] |
Fri, 15 July 2005 10:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
pblue
Messages: 3 Registered: July 2005 Location: Berlin
|
Junior Member |
|
|
Thanks!
I could catalog the backup now, and the dbid is also correct. Unfortunately I cannot restore the backup because of this:
---
RMAN> restore database;
Starting restore at 15-JUL-05
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/15/2005 08:29:18
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
---
I already set the NLS_LANG env variables to match the values in the V$NLS_PARAMETERS table of the source database, but it didn't help.
Has anyone any ideas?
Thanks a lot.
pb
|
|
|