OraFAQ Forum: Backup & Recovery » ora-00245:control file backup failed;Target is likely on local file system

Home » RDBMS Server » Backup & Recovery » ora-00245:control file backup failed;Target is likely on local file system (Oracle 11.2.0.3 solaris 10)

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

ora-00245:control file backup failed;Target is likely on local file system [message #621755]

Mon, 18 August 2014 00:29

janakors
Messages: 232
Registered: September 2009

Senior Member

hi,
i am trying to to take a physical backup(LEVEL 0) and it fails with ORA-00245 error. i have read the fol document [/code]http://docs.oracle.com/cd/B28359_01/rac.111/b28254/rman.htm#i455026[/code] and it says The snapshot control file is a copy of a database control file created in an operating system-specific location by Recovery Manager. i have also check fol

SHOW SNAPSHOT CONTROLFILE NAME;

and it gave me /uo1/app/oracle/product/11.2.0/dbhome
_1/dbs/snapcf_xxx.f

can any one help what can be the solution

Regards,

[Updated on: Mon, 18 August 2014 00:31]

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621757 is a reply to message #621755]

Mon, 18 August 2014 00:35

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste all what you did and got.
Before, Please read How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621758 is a reply to message #621757]

Mon, 18 August 2014 00:48

janakors
Messages: 232
Registered: September 2009

Senior Member

i only did fol:

RMAN> SHOW SNAPSHOT CONTROLFILE NAME;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name MYDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/uo1/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_MYDB.f'; # defualt
RMAN>

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621761 is a reply to message #621758]

Mon, 18 August 2014 01:47

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK, so you have no error, what is the problem?

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621763 is a reply to message #621761]

Mon, 18 August 2014 01:57

janakors
Messages: 232
Registered: September 2009

Senior Member

sir i am getting ORA-00245 while taking physical backup (Level 0) that is the problem.

after googling it some says that the snapshot should on shared disk, any help?? ( i have Oracle RAC of 2 nodes)

Regards

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621765 is a reply to message #621763]

Mon, 18 August 2014 02:19

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Configure your snapshot location to a file on your shared device.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621854 is a reply to message #621765]

Tue, 19 August 2014 02:53

janakors
Messages: 232
Registered: September 2009

Senior Member

hi, i did fol

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/+SG1/snapcf_MYDB.f';
RMAN> SHOW SNAPSHOT CONTROLFILE NAME;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name MYDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/+SG1/snapcf_MYDB.f';

but then i run level 0 backup and ended with fol error

ORA-01580: error creating control backup file /+SG1/snapcf_MYDB.f

Regards

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621855 is a reply to message #621854]

Tue, 19 August 2014 03:06

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

A pte beginning with "/+" is not a legal name.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621858 is a reply to message #621855]

Tue, 19 August 2014 03:56

janakors
Messages: 232
Registered: September 2009

Senior Member

i m trying to do as as u (Johm Watson)said

RMAN> CONFIGURE SNAPSHOT CONTROLFILE TO /SG1/snapcf_MYDB;
RMAN-01009:syntax error: found "to": expecting one of:"name"

dont know much about RMAN commnad line

please guide

Regards

[Updated on: Tue, 19 August 2014 04:08]

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621860 is a reply to message #621858]

Tue, 19 August 2014 04:07

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

' are missing around the name.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621861 is a reply to message #621860]

Tue, 19 August 2014 04:10

janakors
Messages: 232
Registered: September 2009

Senior Member

after correcting as Michel Cadot said but till same problem

RMAN> CONFIGURE SNAPSHOT CONTROLFILE TO '/SG1/snapcf_MYDB';
RMAN-01009:syntax error: found "to": expecting one of:"name"

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621867 is a reply to message #621861]

Tue, 19 August 2014 04:32

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

NAME keyword is missing before TO.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621967 is a reply to message #621867]

Wed, 20 August 2014 03:56

janakors
Messages: 232
Registered: September 2009

Senior Member

Oh sorry i got it thanks. let me see now the lvl 0 backup goes and will post in case.

Regards

[Updated on: Wed, 20 August 2014 03:57]

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #621985 is a reply to message #621967]

Wed, 20 August 2014 05:18

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Oh sorry i got it thanks.

So post the final correct syntax then if anyone has the same problem he/she can also have the solution.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622136 is a reply to message #621985]

Thu, 21 August 2014 05:42

janakors
Messages: 232
Registered: September 2009

Senior Member

the correct syntax is

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/SG1/snapcf_MYDB';

but after doing above i ngot the same error while taking lvl 0 backup

ORA-01580: error creating control backup file /+SG1/snapcf_MYDB.f

any help i am fed up with this issue

Regards

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622137 is a reply to message #622136]

Thu, 21 August 2014 05:52

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

I've already told you that /+ is not a legal path. Do you want to use a clustered file system (which would begin with /) or an ASM diskgroup (which would begin with +)?

I have to say that I find it terrifying that a RAC DBA is not aware of this. What about backup and restore in general? What you do if, for example, you lost an undo tablespace and a copy of the controlfile? How would you minimize downtime and data loss?

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622171 is a reply to message #622137]

Fri, 22 August 2014 02:37

janakors
Messages: 232
Registered: September 2009

Senior Member

yes sir it is an ASM diskgroup i am using but issue still there.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622173 is a reply to message #622171]

Fri, 22 August 2014 02:39

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry but what don't you understand in John's posts?
It seems to me it is clear what you have to do to fix your issue.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622176 is a reply to message #622173]

Fri, 22 August 2014 03:11

janakors
Messages: 232
Registered: September 2009

Senior Member

Quote:

r an ASM diskgroup (which would begin with +)?

well i have to say that i am making u all very clear and i said this thrice in posts that i am putting this snapshot of control on ASM diskgroup so i use '/+SG1... so why u people are not getting me...he said use + if it is ASM diskgroup i said yes i ma using it but when i take the level 0 backup so it terminate with that error (posted above twice)...so what i am not understanding...i ask simple and straight forward question...that if u can help me with that ORA-01580....any doubts in understanding me so please let me know

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622177 is a reply to message #622176]

Fri, 22 August 2014 03:57

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Quote:

he said use +

No. I said
Quote:

begin with +

By the way, there is something wring with your keyboard: it inserts multiple "..." characters.

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622178 is a reply to message #622177]

Fri, 22 August 2014 04:22

janakors
Messages: 232
Registered: September 2009

Senior Member

any thing u can help with. i know what u said so can u help with the issue or not

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622179 is a reply to message #622178]

Fri, 22 August 2014 04:38

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

I give up: clearly, I cannot help.
Perhaps u should give up, too. Who is this guy "u", anyway?

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622184 is a reply to message #622179]

Fri, 22 August 2014 06:28

janakors
Messages: 232
Registered: September 2009

Senior Member

'u' is respectable orafaq.com for me. any way thank u for your time

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622981 is a reply to message #622184]

Wed, 03 September 2014 00:40

janakors
Messages: 232
Registered: September 2009

Senior Member

problem solved and correct syntax is

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+SG1/snapcf_MYDB.f'

+SG1 must not start with '/'

Report message to a moderator

Re: ora-00245:control file backup failed;Target is likely on local file system [message #622991 is a reply to message #621758]

Wed, 03 September 2014 03:05

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/uo1/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_MYDB.f'; # defualt

You're not copy and pasting your sessions.

[Edit: formatting]

[Updated on: Wed, 03 September 2014 03:06]

Report message to a moderator

Previous Topic:	archivelog deletetion
Next Topic:	Flashback DB question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 01:57:22 CST 2025