manasPlease mark your questions as answered rather than having a heap of unanswered questions. Keep the forum clean.
Status Level: Newbie
Registered: Jan 24, 2012
Total Posts: 12
Total Questions: 4 (4 unresolved)
Log switch happen successfully. I check it using command "alter system switch logfile".So there is problem in entire dataguard configuration,
standby is in SYNC with primary : yes , I apply the log manually no data guard is running.
SQL> alter database commit to switchover to physical standby with session shutdown;Check if there is disk space available on the primary to create archivelogs. Check the primary alert log file.
alter database commit to switchover to physical standby with session shutdown
ERROR at line 1:
ORA-16014: log 1 sequence# 23 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/oracle/GWP/oraarch/GWP/redo01.log'
SELECT NAME, TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT, TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999') AS SPACE_AVAILABLE, ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;