Hello,
I have weird scenario wherein the command on my database "Alter system archive log current" just hangs forever.
However "Alter system switch logfile" gets completed without any problems. Nothing in alert log to point something unusual... The system has a relatively lower activity...
Please find the details below:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> select GROUP#,BYTES/1024/1024,THREAD#,SEQUENCE# from v$log;
GROUP# BYTES/1024/1024 THREAD# SEQUENCE#
---------- --------------- ---------- ----------
1 512 1 508
2 512 1 506
3 512 1 507
4 512 1 489
SQL> select GROUP#,STATUS,TYPE,MEMBER,IS_RECOVERY_DEST_FILE from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------------------------------------------ ---
1 ONLINE /oracle/P65/origlogA/log_g11m1.dbf NO
1 ONLINE /oracle/P65/mirrlogA/log_g11m2.dbf NO
2 ONLINE /oracle/P65/origlogB/log_g12m1.dbf NO
2 ONLINE /oracle/P65/mirrlogB/log_g12m2.dbf NO
3 ONLINE /oracle/P65/origlogA/log_g13m1.dbf NO
3 ONLINE /oracle/P65/mirrlogA/log_g13m2.dbf NO
4 ONLINE /oracle/P65/origlogB/log_g14m1.dbf NO
4 ONLINE /oracle/P65/mirrlogB/log_g14m2.dbf NO
8 rows selected.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/P65/oraarch/P65arch
Oldest online log sequence 489
Next log sequence to archive 489
Current log sequence 508
SQL> !df -kh /oracle/P65/oraarch
Filesystem Size Used Avail Use% Mounted on
segotx678:/vol/segot_sapp65_dsfs_2001_1/sapp65_dsfs_2001_q1004n
20G 4.3G 16G 22% /oracle/P65/oraarch
Any suggestions are most welcome. myoraclesupport doesnt help much.
Best Regards,
Nick