Database Backup and Recovery (MOSC)

MOSC Banner

Data Guard in 10g Linux environment has problème with deleting tablespaces. (Physical Standby)

edited May 13, 2009 4:49AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓
I am cleaning up a production environment and moving tables to a new tablespace. That works fine but then I issue the

"DROP TABLESPACE tablespace INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS"

and this is what happens.

After a delay the tablespace files are deleted on both machines. However on the standby where I run the df -k command in the linux prompt my free space is there. On the primary I run the df -k command and the free space is not there. It seems like there is an oracle process is causing a problem with the ext3 file system.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center