Unable to drop standby RAC database
edited Oct 10, 2013 7:29AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 5 commentsAnswered
Hi all,
i am unable to remove the standby database files from the ASM storage. The Standby database is down, broker config files are removed and dg_broker_start is set to false in the primary.
Irrespective of the file(s) I try to remove, it always returns below error.
ASMCMD> ls
Current.3306.824722449
ASMCMD> rm *
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DATA/STOSB/CONTROLFILE/Current.3306.824722449' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
please help
i am unable to remove the standby database files from the ASM storage. The Standby database is down, broker config files are removed and dg_broker_start is set to false in the primary.
Irrespective of the file(s) I try to remove, it always returns below error.
ASMCMD> ls
Current.3306.824722449
ASMCMD> rm *
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DATA/STOSB/CONTROLFILE/Current.3306.824722449' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
please help
0