& DESC V$LOG
& DESC V$LOGFILE
[oracle@dbserver ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 -
Production on Sun Jan 28 00:06:45 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019,
Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise
Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
q CREATE NEW REDO LOG GROUP
v SQL> alter database add logfile group 4 '/u01/app/oracle/oradata/ORCL/redo04.log'
size 200m;
Database altered.
q ADD LOGFILE MEMBER TO GROUP
v SQL> alter database add logfile member
'/u01/app/oracle/oradata/ORCL/redo05.log' to group 4; '
Database altered.
q DROP LOGFILE GROUP
v SQL> alter database drop logfile group 4;
Database altered.
q DROP LOGFILE MEMBER
v SQL> alter database drop logfile member
'/u01/app/oracle/oradata/MAXCDB/redo04.log';
Database altered.
q REUSE DELETED LOGFILE MEMBER
v alter database add logfile member '/u01/app/oracle/oradata/MAXCDB/redo05.log' reuse to group 4;
q LOGFILE SWITCH
v SQL> alter system switch logfile;
Database altered.
& DESC V$ARCHIVED_LOG
[Archive destinations 1 to 10 are available for local or remote locations. Archive destinations 11 to 31 are available for remote locations only]
q SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10
q SET NEW LOG ARCHIVE DEST
SQL> alter system set log_archive_dest_1='location=/u01/prod/arch' scope=both;
r SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------
----------- ------------------------------------------------------
db_recovery_file_dest string
/u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 12732M
r SQL> select NAME, SPACE_LIMIT/1073741824 TOTGB, SPACE_USED/1073741824 USEGB, SPACE_RECLAIMABLE/1073741824 RECGB, NUMBER_OF_FILES from v$recovery_file_dest;
r SQL> select * from v$flash_recovery_area_usage;