31 rows selected.
SQL> SELECT NAME,
(SPACE_LIMIT / 1024 / 1024 / 1024) SPACE_LIMIT_GB,
((SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE) / 1024 / 1024 / 1024) AS SPACE_AVAILABLE_GB,
ROUND((SPACE_USED - SPACE_RECLAIMABLE) / SPACE_LIMIT * 100, 1) AS PERCENT_FULL
FROM V$RECOVERY_FILE_DEST;
2 3 4 5
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT_GB SPACE_AVAILABLE_GB PERCENT_FULL
-------------- ------------------ ------------
+RECO
200 200 0
SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 200G
SQL>
SQL>
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 300G SCOPE=BOTH;
System altered.
SQL> commit;
Commit complete.
SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 300G
SQL> SELECT NAME,
(SPACE_LIMIT / 1024 / 1024 / 1024) SPACE_LIMIT_GB,
((SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE) / 1024 / 1024 / 1024) AS SPACE_AVAILABLE_GB,
ROUND((SPACE_USED - SPACE_RECLAIMABLE) / SPACE_LIMIT * 100, 1) AS PERCENT_FULL
FROM V$RECOVERY_FILE_DEST; 2 3 4 5
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT_GB SPACE_AVAILABLE_GB PERCENT_FULL
-------------- ------------------ ------------
+RECO
300 300 0
SQL> alter system switch logfile;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +RECO
Oldest online log sequence 129336
Next log sequence to archive 129339
Current log sequence 129339
SQL> column name format a15
select * from v$recovery_file_dest;SQL>
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
--------------- ----------- ---------- ----------------- ---------------
+RECO 3.2212E+11 0 0 0
[oracle@servername:INSTANCE] /u01/app/oracle/diag/rdbms/modoprod_iad1qp/INSTANCE/trace
$ tail -20f alert_INSTANCE.log
Current log# 2 seq# 129338 mem# 1: +DATA/modoprod_iad1qp/onlinelog/redolog202.dbf
Thread 1 advanced to log sequence 129339 (LGWR switch)
Current log# 3 seq# 129339 mem# 0: +DATA/modoprod_iad1qp/onlinelog/redolog301.dbf
Current log# 3 seq# 129339 mem# 1: +DATA/modoprod_iad1qp/onlinelog/redolog302.dbf
Fri May 21 13:48:22 2021
Archived Log entry 444165 added for thread 1 sequence 129338 ID 0x752f5768 dest 1:
Fri May 21 13:51:27 2021
Thread 1 cannot allocate new log, sequence 129340
Checkpoint not complete
Current log# 3 seq# 129339 mem# 0: +DATA/modoprod_iad1qp/onlinelog/redolog301.dbf
Current log# 3 seq# 129339 mem# 1: +DATA/modoprod_iad1qp/onlinelog/redolog302.dbf
Thread 1 cannot allocate new log, sequence 129340
Private strand flush not complete
Current log# 3 seq# 129339 mem# 0: +DATA/modoprod_iad1qp/onlinelog/redolog301.dbf
Current log# 3 seq# 129339 mem# 1: +DATA/modoprod_iad1qp/onlinelog/redolog302.dbf
Thread 1 advanced to log sequence 129340 (LGWR switch)
Current log# 4 seq# 129340 mem# 0: +DATA/modoprod_iad1qp/onlinelog/redolog401.dbf
Current log# 4 seq# 129340 mem# 1: +DATA/modoprod_iad1qp/onlinelog/redolog402.dbf
Fri May 21 13:51:34 2021
Archived Log entry 444167 added for thread 1 sequence 129339 ID 0x752f5768 dest 1:
^C
[oracle@servername:INSTANCE] /u01/app/oracle/diag/rdbms/modoprod_iad1qp/INSTANCE/trace
$
TO KNOW SCN from ONLINE REDO Log
INSTANCE set lines 200
INSTANCE select group#, status, archived, thread#, sequence#, to_char(first_change#) from v$log;
GROUP# STATUS ARC THREAD# SEQUENCE# TO_CHAR(FIRST_CHANGE#)
---------- ---------------- --- ---------- ---------- ----------------------------------------
1 CURRENT NO 1 205 59316138231
2 INACTIVE NO 1 202 59315711627
3 INACTIVE NO 1 203 59315880135
4 INACTIVE NO 1 204 59315892717
INSTANCE
#######################CURRENT DB SCN and ONLINE REDO LOG SCN DIFFERENCE##############33
INSTANCE select to_char(current_scn),to_char(sysdate,'ddmmyyyy hh24:mi:ss') ddate from v$database;
TO_CHAR(CURRENT_SCN) DDATE
---------------------------------------- -----------------
59316265472 21052021 15:08:00
INSTANCE select group#, status, archived, thread#, sequence#, to_char(first_change#) from v$log;
GROUP# STATUS ARC THREAD# SEQUENCE# TO_CHAR(FIRST_CHANGE#)
---------- ---------------- --- ---------- ---------- ----------------------------------------
1 CURRENT NO 1 205 59316138231
2 INACTIVE NO 1 202 59315711627
3 INACTIVE NO 1 203 59315880135
4 INACTIVE NO 1 204 59315892717
INSTANCE
