Database Administration (MOSC)

MOSC Banner

DiskGroup Sapce Filled -Archival Fails

edited Sep 9, 2010 8:56PM in Database Administration (MOSC) 5 commentsAnswered
  Dear Seniors

-------------------

Our Database is Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining optionson Sun solaris 10

My DiskGroup is running out of space and and and I have asm files my archivelogs ,datafiles are destined to DG1

My LOG_ARCHIVE_DEST_1 is set to +DG1/MYCOMP/ others destinations are enebled but inactive

SQL> select DEST_NAME,STATUS,BINDING,NAME_SPACE,TARGET,ARCHIVER,SCHEDULE,DESTINA TION from V$ARCHIVE_DEST ; DEST_NAME -------------------------------------------------------------------------------- STATUS BINDING NAME_SP TARGET ARCHIVER SCHEDULE --------- --------- ------- ------- ---------- -------- DESTINATION -------------------------------------------------------------------------------- LOG_ARCHIVE_DEST_1 VALID OPTIONAL SYSTEM PRIMARY ARCH ACTIVE +DG1/MYCOMP/ -------------------------------------------------------------------------

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center