Home » RDBMS Server » Backup & Recovery » Error in creating snapshot controlfile (oracle 9.2.0 , solaris 8)
Error in creating snapshot controlfile [message #293649] Mon, 14 January 2008 06:48 Go to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
hi all,

I want to reset the old configuration parameters of my target database.
Both of my target and catalog databases resides on separate servers.
But I am getting this error.
Can any body plz tell me how to get out of it.


RMAN> reset database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of reset command at 01/14/2008 11:54:15
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/14/2008 11:54:15
ORA-01580: error creating control backup file /ora0/rman/backup/test/snapcf_test.f
ORA-27040: skgfrcre: create error, unable to create file
SVR4 Error: 2: No such file or directory







Thank u.
Re: Error in creating snapshot controlfile [message #293675 is a reply to message #293649] Mon, 14 January 2008 09:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>SVR4 Error: 2: No such file or directory
wrong path for controlfile creation.
post here RMAN>SHOW ALL; output.
Re: Error in creating snapshot controlfile [message #294227 is a reply to message #293649] Wed, 16 January 2008 22:04 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
thanks,

I got the solution.
Re: Error in creating snapshot controlfile [message #294268 is a reply to message #294227] Thu, 17 January 2008 00:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I got the solution

And which one it is? What was the root of the problem?

Regards
Michel
Previous Topic: oracle hp-ux data to windows based oracle
Next Topic: Is sqlnet.ora is needed for connecting to target?
Goto Forum:
  


Current Time: Sun Dec 04 06:54:16 CST 2016

Total time taken to generate the page: 0.07491 seconds