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)
ora-00245:control file backup failed;Target is likely on local file system [message #621755] Mon, 18 August 2014 00:29 Go to next message
janakors
Messages: 177
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
janakors
Messages: 177
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>
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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 Go to previous messageGo to next message
janakors
Messages: 177
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
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 Go to previous messageGo to next message
John Watson
Messages: 4569
Registered: January 2010
Location: Global Village
Senior Member
Configure your snapshot location to a file on your shared device.
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 Go to previous messageGo to next message
janakors
Messages: 177
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



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 Go to previous messageGo to next message
John Watson
Messages: 4569
Registered: January 2010
Location: Global Village
Senior Member
A pte beginning with "/+" is not a legal name.
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 Go to previous messageGo to next message
janakors
Messages: 177
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

' are missing around the name.

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 Go to previous messageGo to next message
janakors
Messages: 177
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"
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

NAME keyword is missing before TO.

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 Go to previous messageGo to next message
janakors
Messages: 177
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
janakors
Messages: 177
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
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 Go to previous messageGo to next message
John Watson
Messages: 4569
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?
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 Go to previous messageGo to next message
janakors
Messages: 177
Registered: September 2009
Senior Member
yes sir it is an ASM diskgroup i am using but issue still there.

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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
janakors
Messages: 177
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
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 Go to previous messageGo to next message
John Watson
Messages: 4569
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.
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 Go to previous messageGo to next message
janakors
Messages: 177
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
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 Go to previous messageGo to next message
John Watson
Messages: 4569
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?
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 Go to previous messageGo to next message
janakors
Messages: 177
Registered: September 2009
Senior Member
'u' is respectable orafaq.com for me. any way thank u for your time
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 Go to previous messageGo to next message
janakors
Messages: 177
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 '/'
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 Go to previous message
gazzag
Messages: 316
Registered: November 2010
Location: Bristol, 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:
  


Current Time: Sat Sep 20 23:38:00 CDT 2014

Total time taken to generate the page: 0.09509 seconds