OraFAQ Forum: Backup & Recovery » Snapshot Controlfile Configuration

Home » RDBMS Server » Backup & Recovery » Snapshot Controlfile Configuration (Oracle 10g R2 + Windows 2003 R2)

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

Snapshot Controlfile Configuration [message #312567]

Wed, 09 April 2008 05:17

babuknb
Messages: 1736
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

Report message to a moderator

Re: Snapshot Controlfile Configuration [message #312569 is a reply to message #312567]

Wed, 09 April 2008 05:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Try:

CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;

Report message to a moderator

Re: Snapshot Controlfile Configuration [message #312585 is a reply to message #312569]

Wed, 09 April 2008 06:25

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thank you. Now it's working.

Babu

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 07:14:32 CST 2024