dbTalk Databases Forums  

RMAN ADDING TO CATALOG FAILURE

comp.databases.oracle.server comp.databases.oracle.server


Discuss RMAN ADDING TO CATALOG FAILURE in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chris b
 
Posts: n/a

Default RMAN ADDING TO CATALOG FAILURE - 05-30-2007 , 05:15 AM






My general goal is to duplicate a 10.2.0.3 DATABASE on server a to
server b

I am using a catalog on another server / I have executed a backup on
server a & presented it to server b on a different drive, I have then
tried to add backupset into the catalog ( command & errors included
below )


I am a local administrator on server b

I have ensured that path & filename are correct

Any ideas??

regards
Chris B

RMAN> CATALOG backuppiece 'I:\oracle\ora10g\flash_recovery_area\LVYESMI
\AUTO
UP\2007_05_21\CJB.BKP';

ORA-19870: error reading backup piece I:\ORACLE\ORA10G
\FLASH_RECOVERY_AREA\L
MI\AUTOBACKUP\2007_05_21\CJB
ORA-19505: failed to identify file "I:\ORACLE\ORA10G
\FLASH_RECOVERY_AREA\LVY
\AUTOBACKUP\2007_05_21\CJB"
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-00571:
================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
================================================== =========
RMAN-03002: failure of catalog command at 05/30/2007 11:05:15
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: ---------------
------------------------------------------------
RMAN-06214: Backup Piece I:\ORACLE\ORA10G\FLASH_RECOVERY_AREA
\LVYESMI\AUT
KUP\2007_05_21\CJB.BKP

RMAN>


Reply With Quote
  #2  
Old   
sybrandb
 
Posts: n/a

Default Re: RMAN ADDING TO CATALOG FAILURE - 05-30-2007 , 05:26 AM






On May 30, 12:15 pm, chris b <chris.br... (AT) providenthims (DOT) co.uk> wrote:
Quote:
My general goal is to duplicate a 10.2.0.3 DATABASE on server a to
server b

I am using a catalog on another server / I have executed a backup on
server a & presented it to server b on a different drive, I have then
tried to add backupset into the catalog ( command & errors included
below )

I am a local administrator on server b

I have ensured that path & filename are correct

Any ideas??

regards
Chris B

RMAN> CATALOG backuppiece 'I:\oracle\ora10g\flash_recovery_area\LVYESMI
\AUTO
UP\2007_05_21\CJB.BKP';

ORA-19870: error reading backup piece I:\ORACLE\ORA10G
\FLASH_RECOVERY_AREA\L
MI\AUTOBACKUP\2007_05_21\CJB
ORA-19505: failed to identify file "I:\ORACLE\ORA10G
\FLASH_RECOVERY_AREA\LVY
\AUTOBACKUP\2007_05_21\CJB"
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-00571:
================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
================================================== =========
RMAN-03002: failure of catalog command at 05/30/2007 11:05:15
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: ---------------
------------------------------------------------
RMAN-06214: Backup Piece I:\ORACLE\ORA10G\FLASH_RECOVERY_AREA
\LVYESMI\AUT
KUP\2007_05_21\CJB.BKP

RMAN
RMAN doesn't work with network and/or UNC drives, unless you change
some setting in the registry allowing you to connect as domain
administrator. This seems to pose a security risk.

--
Sybrand Bakker
Senior Oracle DBA



Reply With Quote
  #3  
Old   
gazzag
 
Posts: n/a

Default Re: RMAN ADDING TO CATALOG FAILURE - 05-30-2007 , 07:35 AM



On 30 May, 11:15, chris b <chris.br... (AT) providenthims (DOT) co.uk> wrote:
Quote:
My general goal is to duplicate a 10.2.0.3 DATABASE on server a to
server b

I am using a catalog on another server / I have executed a backup on
server a & presented it to server b on a different drive, I have then
tried to add backupset into the catalog ( command & errors included
below )

I am a local administrator on server b

[deletia]

Oracle recommends copying the backup pieces to a staging area on
server A, e.g. I:\Oracle\stage.

Then create an identical staging are on server B.

Quote:
From server B, issue commands similar to the following:
set ORACLE_SID=<database_instance_on_host_B>
rman target sys/<password>@<database on host A> auxiliary /
RMAN> DUPLICATE TARGET DATABASE

HTH

-g



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.