Home » RDBMS Server » Backup & Recovery » Snapshot Controlfile Configuration (Oracle 10g R2 + Windows 2003 R2)
Snapshot Controlfile Configuration [message #312567] Wed, 09 April 2008 05:17 Go to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Hi,

I need to remove snapshot controlfile location. When i clear snapshot controlfile. I am getting the below error message.

Please let me know. How to solve this issue.

RMAN> show all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 04/09/2008 15:39:12
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 04/09/2008 15:39:12
ORA-01580: error creating control backup file G:\DBBACKUP\EDKDB\SNAPSHOT_CONTROLFILE\CONTROL.CTL
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

RMAN> CONFIGURE SNAPSHOT CONTROLFILE CLEAR;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "clear": expecting one of: "name"
RMAN-01007: at line 1 column 32 file: standard input

RMAN> CONFIGURE SNAPSHOT CONTROLFILE LOCATION CLEAR;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "name"
RMAN-01008: the bad identifier was: LOCATION
RMAN-01007: at line 1 column 32 file: standard input

RMAN> CONFIGURE SNAPSHOT CONTROLFILE  'G:\DBBACKUP\EDKDB\SNAPSHOT_CONTROLFILE\CONTROL.CTL' CLEAR;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "name"
RMAN-01007: at line 1 column 33 file: standard input


Regards

Babu
Re: Snapshot Controlfile Configuration [message #312569 is a reply to message #312567] Wed, 09 April 2008 05:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Try:
CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;
Re: Snapshot Controlfile Configuration [message #312585 is a reply to message #312569] Wed, 09 April 2008 06:25 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thank you. Now it's working.

Babu

Previous Topic: Shutdown [PROCESS] due to a foreground archival
Next Topic: backup failing giving error, ORA-19502, ORA-27063, Outer dbms_backup_restore.restoreCancel()
Goto Forum:
  


Current Time: Sat Dec 10 16:34:21 CST 2016

Total time taken to generate the page: 0.11221 seconds