OraFAQ Forum: Backup & Recovery » Can anyone help how to solve the following error in RMAN?

Home » RDBMS Server » Backup & Recovery » Can anyone help how to solve the following error in RMAN? (Rman 10.2.0.4 Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can anyone help how to solve the following error in RMAN? [message #323197]

Tue, 27 May 2008 12:41

tuan713
Messages: 4
Registered: March 2006

Junior Member

can anyone help how to solve the following error in RMAN?

when I do show all in rman:
RMAN> show all;

I get:

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE AUXNAME FOR DATAFILE '/opt/oracle/oradata/VIT10/system01.dbf' TO '/opt/oracle/oradata/STAGE/system01.dbf';

But I want to put this system01.dbf file to same directory naming but on different host,

I tried :

RMAN> CONFIGURE AUXNAME FOR DATAFILE '/opt/oracle/oradata/VIT10/system01.dbf' TO '/opt/oracle/oradata/VIT10/system01.dbf';

RMAN-00571: =====================================================
RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS=============
RMAN-00571: =====================================================
RMAN-03002: failure of configure command at 05/27/2008 09:17:53
ORA-19584: file /opt/oracle/oradata/VIT10/system01.dbf already in use

can anyone help out with either correct syntax or show me a different way of cloning database but on different server with the same directory?

Thanks in Advance,

Report message to a moderator

Re: Can anyone help how to solve the following error in RMAN? [message #323200 is a reply to message #323197]

Tue, 27 May 2008 12:51

tuan713
Messages: 4
Registered: March 2006

Junior Member

is there a way to remove the configure auxname for DATAFILE line when execute the show all command in rman?

Does anyone know how to remove the line below in blue?

when I do show all in rman:
RMAN> show all;

I get:

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE AUXNAME FOR DATAFILE '/opt/oracle/oradata/VIT10/system01.dbf' TO '/opt/oracle/oradata/STAGE/system01.dbf';

Report message to a moderator

Re: Can anyone help how to solve the following error in RMAN? [message #323207 is a reply to message #323200]

Tue, 27 May 2008 14:16

ebrian
Messages: 2794
Registered: April 2006

Senior Member

CONFIGURE AUXNAME FOR DATAFILE '/opt/oracle/oradata/VIT10/system01.dbf' CLEAR;

[Updated on: Tue, 27 May 2008 14:16]

Report message to a moderator

Re: Can anyone help how to solve the following error in RMAN? [message #323211 is a reply to message #323207]

Tue, 27 May 2008 15:05

tuan713
Messages: 4
Registered: March 2006

Junior Member

Thanks a bunch! Worked like a charm.

Report message to a moderator

Previous Topic:	Cannot open the database
Next Topic:	Problem in Creating Recovery Catalog

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 09:09:40 CST 2024