Sreenu Oracle DBA: 2018

Thursday, 4 October 2018

Applying Latest PSU On Grid+RDBMS Homes

Download Below Latest PSU and OPatch zip files from MOS

p6880880_121010_Linux-x86_64.zip---OPatch

p27468957_121020_Linux-x86_64.zip--PSU

Create directory to keep files

As a root user

cd /oracle/software

mkdir psu

mkdir gpsu

chown oracle:oinstall psu

chown grid:oinstall gpsu

cp p6880880_121010_Linux-x86_64.zip gpsu

cp p27468957_121020_Linux-x86_64.zip gpsu

cp p6880880_121010_Linux-x86_64.zip psu

cp p27468957_121020_Linux-x86_64.zip psu

Applying PSU on GRID Home

Change owner ship to grid user

As root user

cd /oracle/software/gpsu

chown grid:oinstall p6880880_121010_Linux-x86_64.zip

chown grid:oinstall p27468957_121020_Linux-x86_64.zip

As a grid user unzip OPatch on grid home

cd /u01/app/12.1.0.2/grid

unzip -o /oracle/software/gpsu/p6880880_121010_Linux-x86_64.zip

Once OPatch unzipped , Please check Opatch version using below command

. oraenv

+ASM

cd $ORACLE_HOME/OPatch

./opatch version

Now unzip PSU

As a grid user

cd /oracle/software/gpsu

unzip p27468957_121020_Linux-x86_64.zip

As a root user stop crs services

. oraenv

+ASM

crsctl stop crs(has --if Single Instance) -f

Now Apply PSU on Grid Home

As a root

. oraenv

+ASM

echo $ORACLE_SID

ASM

echo $ORACLE_HOME

/u01/app/12.1.0.2/grid

nohup $ORACLE_HOME/OPatch/opatchauto apply /oracle/software/gpsu/p27468957 -oh /u01/app/12.1.0.2/grid &

Once Patch applied successfully, Start crsctl services

. oraenv

+ASM

crsctl start crs

Applying PSU on RDBMS Home

Change owner ship to oracleuser

As root user

cd /oracle/software/psu

chown oracle:oinstall p6880880_121010_Linux-x86_64.zip

chown oracle:oinstall p27468957_121020_Linux-x86_64.zip

As a oracle user unzip OPatch on RDBMS home

cd /u01/app/oracle/product/12.1.0.2/dbhome_1

unzip -o /oracle/software/psu/p6880880_121010_Linux-x86_64.zip

Once OPatch unzipped , Please check Opatch version using below command

. oraenv

+DB1

cd $ORACLE_HOME/OPatch

./opatch version

Now unzip PSU

As a oracle user

cd /oracle/software/psu

unzip p27468957_121020_Linux-x86_64.zip

As a root user stop crs services

. oraenv

+ASM

crsctl stop crs(has --if Single Instance) -f

Now Apply PSU on RDBMS Home

As a root

. oraenv

+DB1

echo $ORACLE_SID

DB1

echo $ORACLE_HOME

/u01/app/oracle/product/12.1.0.2/dbhome_1

nohup $ORACLE_HOME/OPatch/opatchauto apply /oracle/software/psu/p27468957 -oh /u01/app/oracle/product/12.1.0.2/dbhome_1 &

Once Patch applied successfully, Start crsctl services

. oraenv

+ASM

crsctl start crs

Once RDBMS Patch Applied, source each RDBMS SID then apply Datapatch

$ORACLE_HOME=/OPatch/datapatch

Finally Check PSU applied status

set pages 4000 lines 4000

col description for a60

select patch_id,version,action,status,description from dba_registry_sqlpatch;

col verify_queryable_inventory for a30

select dbsm_sqlpatch.verify_veryable_inventory from dual;

************************************************** All The Best *********************************************

11.2.0.4.0 DB Binaries Installation on Linux Non-RAC/RAC-Enviroment

11.2.0.4.0 DB Binaries Installation on Linux RAC-Enviroment:

Copy the below required files to one of the RAC node

p13390677_112040_Linux_x86_64_1of7.zip
p13390677_112040_Linux_x86_64_2of7.zip

Copy PSU and OPatch to all nodes of the RAC

p26030799_112040_Linux_x86_64.zip--PSU Patch
p6880880_112000_Linux_x86_64.zip---OPatch

Clean the Software Directory

Remove all previous installation software from oracle/software and change the directory group, So our personal ID's can copy software directly(dba group)

As a root on each node

cd /oracle/software
rm -fr database grid psu gpsu
chgrp dba /oracle/software
chmod 775 /oracle/software

Unzip the Database files

As oracle

unzip p13390677_112040_Linux_x86_64_1of7.zip

unzip p13390677_112040_Linux_x86_64_2of7.zip

Create RDBMS response file

As oracle

cd /oracle/software

grep -i ^[A-Z] database /response/db_install.rsp | sort > dbInstall.rsp

Modify the following variables as per RAC environment you are patching

DECLINE_SECURITY_UPDATES=true

INVENTORY_LOCATION=/u01/app/oraInventory

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

oracle.install.db.CLUSTER_NODES=Testdb1,Testdb2

oracle.install.db.DBA_GROUP=oinstall

oracle.install.db.EEOptionsSelection=true

oracle.install.db.InstallEdition=EE

oracle.install.db.OPER_GROUP=dba

oracle.install.option=INSTALL_DB_SWONLY

oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolal:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0

Deploy Software

As oracle

cd /oracle/software/database

./runInstaller -silent -response /oracle/software/dbInstall.rsp

Copy init.ora and tnsnames.ora files to new RDBMS Home

For each node:

. oraenv

cp -p $ORACLE_HOME/network/admin/tnsnames.ora /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin

For each database:

. oraenv

cp - p $ORACLE_HOME/dbs/init${ORACLE_SID}.ora ${ORACLE_HOME}/dbs/prapw${ORACLE_SID} \ /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs

Upgrade opatch on each node:

Run the following on each node

As oracle

cd ./u01/app/oracle/product/11.2.0.4/dbhome_1

unzip -o /oracle/software/p6880880_112000_Linux_x86_64.zip

Create OCM responce file

As oracle

The following command has 2 prompts:

1. Email address/User Name: Leave Blank

2. Do you wish to remain uninformed of security issues(Yes,No)N:Answer "Y"

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp

Example Output:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp

Email address/User Name: Leave Blank

Do you wish to remain uninformed of security issues(Yes,No)N:Y

The OCM configuration response file (/var/tmp/ocm.rsp) was successfully created

Apply the latest PSU on each node

As oracle

RDBMS patch will be used:

cd /oracle/software

mkdir psu

cd psu

unzip ../p26030799_112040_Linux_x86_64.zip

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

${ORACLE_HOME}/OPatch/opatch apply /oracle/software/psu/p26030799 -oh ${ORACLE_HOME} -ocmrf /var/tmp/ocm.rsp

Verify the output mentions copying the PSU to all RAC nodes.

Example:

All nodes have been patched. you may start oracle instances on the local system and nodes...

Composite patch 26030799 successfully applied

OPatch session completed successfully with warnings.

Log file location:

/u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2018-05-28_18-56-09PM_1.log

Verify Installation:

As oracle

Verify software installed on all nodes

for node in ${nodes} ; do

ssh -q ${node} tail /u01/app/oraInventory/ContentsXML/inventory.xml

done

Verify PSU applied on all nodes.

for node in ${nodes} ; do

ssh -q ${node} ls /u01/app/oracle/product/11.2.0.4/dbhome_1/psu

done

=============================================================================================================

11.2.0.4.0 DB Binaries Installation on Linux Non-RAC-Enviroment:

Copy the below required files

p13390677_112040_Linux_x86_64_1of7.zip
p13390677_112040_Linux_x86_64_2of7.zip

Copy PSU and OPatch

p26030799_112040_Linux_x86_64.zip--PSU Patch
p6880880_112000_Linux_x86_64.zip---OPatch

Clean the Software Directory

Remove all previous installation software from oracle/software and change the directory group, So our personal ID's can copy software directly(dba group)

As a root

cd /oracle/software
rm -fr database grid psu gpsu
chgrp dba /oracle/software
chmod 775 /oracle/software

Unzip the Database files

As oracle

unzip p13390677_112040_Linux_x86_64_1of7.zip

unzip p13390677_112040_Linux_x86_64_2of7.zip

Create RDBMS response file

As oracle

cd /oracle/software

grep -i ^[A-Z] database /response/db_install.rsp | sort > dbInstall.rsp

Modify the following variables as per environment you are patching

DECLINE_SECURITY_UPDATES=true

INVENTORY_LOCATION=/u01/app/oraInventory

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

oracle.install.db.DBA_GROUP=oinstall

oracle.install.db.EEOptionsSelection=true

oracle.install.db.InstallEdition=EE

oracle.install.db.OPER_GROUP=dba

oracle.install.option=INSTALL_DB_SWONLY

oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolal:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0

Deploy Software

As oracle

cd /oracle/software/database

./runInstaller -silent -response /oracle/software/dbInstall.rsp

Copy init.ora and tnsnames.ora files to new RDBMS Home

For each node:

. oraenv

cp -p $ORACLE_HOME/network/admin/tnsnames.ora /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin

For each database:

. oraenv

cp - p $ORACLE_HOME/dbs/init${ORACLE_SID}.ora ${ORACLE_HOME}/dbs/prapw${ORACLE_SID} \ /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs

Upgrade opatch :

Run the following on each node

As oracle

cd ./u01/app/oracle/product/11.2.0.4/dbhome_1

unzip -o /oracle/software/p6880880_112000_Linux_x86_64.zip

Create OCM responce file

As oracle

The following command has 2 prompts:

1. Email address/User Name: Leave Blank

2. Do you wish to remain uninformed of security issues(Yes,No)N:Answer "Y"

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp

Example Output:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp

Email address/User Name: Leave Blank

Do you wish to remain uninformed of security issues(Yes,No)N:Y

The OCM configuration response file (/var/tmp/ocm.rsp) was successfully created

Apply the latest PSU

As oracle

RDBMS patch will be used:

cd /oracle/software

mkdir psu

cd psu

unzip ../p26030799_112040_Linux_x86_64.zip

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

${ORACLE_HOME}/OPatch/opatch apply /oracle/software/psu/p26030799 -oh ${ORACLE_HOME} -ocmrf /var/tmp/ocm.rsp

Verify the output mentions copying the PSU to all RAC nodes.

Example:

All nodes have been patched. you may start oracle instances on the local system and nodes...

Composite patch 26030799 successfully applied

OPatch session completed successfully with warnings.

Log file location:

/u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2018-05-28_18-56-09PM_1.log

Verify Installation:

As oracle

Verify software installed on all nodes

for node in ${nodes} ; do

ssh -q ${node} tail /u01/app/oraInventory/ContentsXML/inventory.xml

done

Verify PSU applied .

for node in ${nodes} ; do

ssh -q ${node} ls /u01/app/oracle/product/11.2.0.4/dbhome_1/psu

done

************************************************** All The Best *********************************************

Wednesday, 3 October 2018

Restoring Database Using Restore Point-Single Instance(Non-Rac)

SQL>Select name,open_mode,database_role,current_scn,flashback_on from v$database;

NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FLASHBACK_ON
======= ========== ============= =========== ==================
TESTDB1 READ WRITE PRIMARY 3283000481 RESTORE POINT ONLY

SQL> select * from v$restore_point;

SCN NAME DATABASE_INCARNATION# GUA STORAGE_SIZE TIME
========== ===== ===================== === ============ ===============================
3281420775 RPOINTB 2 YES 4294967296 24-APR-17 11.25.07.000000000 AM

SQL>Shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.
Total system Global Area 8589934 bytes
Fixed size 592 2944952 bytes
variable size 6794772552 bytes
Database Buffers 1778384896 bytes
Redo Buffers 13832192 bytes
Database mounted.

SQL> Select name,open_mode,database_role,current_scn,flashback_on from v$database;

NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FLASHBACK_ON
======= ========== ============= =========== ==================
TESTDB1 MOUNTED PRIMARY 3283000481 RESTORE POINT ONLY

SQL> select * from v$restore_point;

SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME
========== ===================== === ============ ===============================
3281420775 2 YES 4294967296 24-APR-17 11.25.07.000000000 AM

SQL> flashback database to restore point RPOINTB;

Flashback complete.

SQL> alter database open resetlogs;

Database altered.

SQL>Select name,open_mode,database_role,current_scn,flashback_on from v$database;

NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FLASHBACK_ON
======= ========== ============= =========== ==================
TESTDB1 READ WRITE PRIMARY 3281425954 RESTORE POINT ONLY

Wednesday, 26 September 2018

How to handle Oracle File_Recovery_Area(FRA)

Sometimes the Flash Recovery Area (FRA) is full and the Oracle DBA wants to know what is it’s usage, size and the list of occupants (archives, RMAN backups pieces or image copies, flashback logs).

Check and confirm FRA location with below parameter

SQL>Select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
------ --------- -------------
ORADB1 READ WRITE PRIMARY

SQL> Show parameter db_recovery_file_dest;

NAME TYPE VALUE
-------------------------- ----------- ------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 120G

Check FRA usage like Total, used and free space with below select statement

SQL> Select space_limit/1024/1024/1024 TOTAL_GB,space_used/1024/1024/1024 USED_GB from v$recovery_file_dest;

TOTAL_GB USED_GB
-------- -------
120 88.8515625

Check the fra usage in percentage with below select statement

SQL> Select x.*,round(100 * (x.SPACE_USED/x.SPACE_LIMIT), 3) fra_pct_used from v$recovery_file_dest x;

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID FRA_PCT_USED
----- ----------- ---------- ----------------- --------------- ---------- ----------
+FRA 1.2885E+11 9.5404E+10 9.5404E+10 285 0 74.043

Check the list of occupants (archives, RMAN backups pieces or image copies, flashback logs).

Select * from v$recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE 0 0 0 0
REDO LOG 0 0 0 0
ARCHIVED LOG 73.53 73.53 282 0
BACKUP PIECE .51 .51 3 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 0 0 0 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0

8 rows selected.

or

SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE 0 0 0 0
REDO LOG 0 0 0 0
ARCHIVED LOG 73.53 73.53 282 0
BACKUP PIECE .51 .51 3 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 0 0 0 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0

8 rows selected.

Check Size, usage, Reclaimable space used
SQL>SELECT ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB, ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,ROUND((A.SPACE_RECLAIMABLE/1024/1024/1024), 2) AS FLASH_RECLAIMABLE_GB,SUM(B.PERCENT_SPACE_USED) AS PERCENT_OF_SPACE_USED
FROM V$RECOVERY_FILE_DEST A, V$FLASH_RECOVERY_AREA_USAGE B GROUP BY SPACE_LIMIT, SPACE_USED , SPACE_RECLAIMABLE ;

FLASH_IN_GB FLASH_USED_IN_GB FLASH_RECLAIMABLE_GB PERCENT_OF_SPACE_USED
----------- ---------------- -------------------- ---------------------
120 88.85 88.85 74.04

As per above output FRA usage 74.04%

We have thre scenarios to fix FRA issue.

1. We can increase FRA space if we have sufficient free disk space :

Check FRA disk free space with below select statement

SQL> select NAME,TOTAL_MB/1024,FREE_MB/1024 from v$asm_diskgroup;

NAME TOTAL_MB/1024 FREE_MB/1024
------------------------------ ------------- ------------
DATA 1000 303.550781
FRA 200 109.339844
REDO 60 47.4726563

or

[grid@e75lrl2036 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 1024000 310836 0 310836 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 204800 111964 0 111964 0 N FRA/
MOUNTED EXTERN N 512 512 4096 4194304 61440 48612 0 48612 0 N REDO/

As per above output we have free space approx 109GB, So we are good to increase FRA with below syntax

SQL> ALTER SYSTEM SET db_recovery_file_dest_size=140G scope=both;

System altered.

Now check FRA Usage after increasing.

SQL> Select space_limit/1024/1024/1024 TOTAL_GB,space_used/1024/1024/1024 USED_GB from v$recovery_file_dest;

TOTAL_GB USED_GB
---------- ----------
140 88.8515625

SQL> Select x.*,round(100 * (x.SPACE_USED/x.SPACE_LIMIT), 3) fra_pct_used from v$recovery_file_dest x;

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID FRA_PCT_USED
----- ----------- ---------- ----------------- --------------- ---------- ----------
+FRA 1.2885E+11 9.5404E+10 9.5404E+10 285 0 62.043

2. Change the FRA to a new location, new archives will be created to this new location:

SQL>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/backup/archive' scope =both;

System Altered.

Now check FRA location after changing

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /backup/archive
db_recovery_file_dest_size big integer 120G

3. Deleting Old archive logfiles to reclaim FRA space.

Check backup of database+archivelogs backup atleast for one week with below select statement, If all backups are successfull and valid backups then we can remove old archive logfiles to reclaim space.

SQL>
col output_bytes_display form a15
col input_bytes_display form a15
col STATUS form a25
col time_taken_display form a10
col INPUT_BYTES_PER_SEC_DISPLAY form a15
col OUTPUT_BYTES_PER_SEC_DISPLAY form a17
col input_rate_per_sec form a20
col output_rate_per_sec form a20
select session_key,
input_type,
status,
to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
to_char(end_time,'yyyy-mm-dd hh24:mi') end_time,
input_bytes_display,
output_bytes_display,
--INPUT_BYTES_PER_SEC_DISPLAY as input_rate_per_sec,
OUTPUT_BYTES_PER_SEC_DISPLAY as output_rate_per_sec,
time_taken_display
from v$rman_backup_job_details
order by session_key asc;

SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME INPUT_BYTES_DIS OUTPUT_BYTES_DI OUTPUT_RATE_PER_SEC TIME_TAKEN
----------- ------------- ------------------------- ---------------- ---------------- --------------- --------------- -------------------- ----------
9 ARCHIVELOG COMPLETED 2020-02-16 05:03 2020-02-16 05:05 322.98M 324.00M 2.63M 00:02:03
12 DB INCR COMPLETED 2020-02-16 05:44 2020-02-16 11:35 157.76G 88.56G 4.31M 05:50:37
14 ARCHIVELOG COMPLETED 2020-02-16 06:04 2020-02-16 06:05 1.27G 1.27G 14.18M 00:01:32
17 ARCHIVELOG COMPLETED 2020-02-16 07:03 2020-02-16 07:05 1.94G 1.94G 19.33M 00:01:43
84 ARCHIVELOG COMPLETED 2020-02-16 17:02 2020-02-16 17:04 2.41G 2.42G 24.25M 00:01:42
87 DB INCR COMPLETED 2020-02-16 17:12 2020-02-16 17:14 0.00K 0.00K 0.00K 00:02:05
144 ARCHIVELOG COMPLETED 2020-02-17 11:04 2020-02-17 11:06 4.81G 4.81G 34.43M 00:02:23
186 ARCHIVELOG COMPLETED 2020-02-17 12:03 2020-02-17 12:05 5.36G 5.37G 48.62M 00:01:53
244 ARCHIVELOG COMPLETED 2020-02-18 06:06 2020-02-18 06:40 11.90G 11.90G 5.97M 00:34:01
246 DB INCR COMPLETED 2020-02-18 06:15 0.00K 0.00K
249 ARCHIVELOG COMPLETED 2020-02-18 07:04 2020-02-18 07:15 11.91G 11.91G 17.40M 00:11:41
252 ARCHIVELOG COMPLETED 2020-02-18 08:03 2020-02-18 08:09 12.00G 12.00G 38.28M 00:05:21
343 ARCHIVELOG COMPLETED 2020-02-19 02:03 2020-02-19 02:54 21.56G 21.56G 7.20M 00:51:08
345 DB INCR COMPLETED 2020-02-19 02:40 2020-02-19 02:42 0.00K 0.00K 0.00K 00:02:06
432 ARCHIVELOG COMPLETED 2020-02-19 22:04 2020-02-19 22:09 8.58G 8.58G 26.88M 00:05:27
435 ARCHIVELOG COMPLETED 2020-02-19 23:05 2020-02-19 23:06 8.67G 8.68G 116.89M 00:01:16
441 ARCHIVELOG COMPLETED 2020-02-20 01:05 2020-02-20 01:09 9.16G 9.16G 39.92M 00:03:55
444 DB INCR COMPLETED 2020-02-20 02:02 2020-02-20 02:17 704.54G 6.25G 6.97M 00:15:18
446 ARCHIVELOG COMPLETED 2020-02-20 02:04 2020-02-20 02:12 9.26G 9.26G 20.57M 00:07:41
450 ARCHIVELOG COMPLETED 2020-02-20 02:20 2020-02-20 02:21 9.26G 9.26G 135.51M 00:01:10
531 ARCHIVELOG COMPLETED 2020-02-21 00:04 2020-02-21 00:05 19.00G 19.01G 173.78M 00:01:52
537 DB INCR COMPLETED 2020-02-21 02:01 2020-02-21 02:12 704.54G 5.64G 8.51M 00:11:19
539 ARCHIVELOG COMPLETED 2020-02-21 02:05 2020-02-21 02:07 19.31G 19.31G 125.16M 00:02:38
543 ARCHIVELOG COMPLETED 2020-02-21 02:16 2020-02-21 02:17 19.31G 19.31G 184.83M 00:01:47
3376 ARCHIVELOG COMPLETED 2020-02-22 01:04 2020-02-22 01:08 56.15G 56.16G 246.80M 00:03:53
3379 DB INCR COMPLETED 2020-02-22 02:01 2020-02-22 02:22 574.54G 352.57G 274.55M 00:21:55
3381 ARCHIVELOG COMPLETED 2020-02-22 02:03 2020-02-22 02:11 56.26G 56.26G 118.54M 00:08:06
3385 ARCHIVELOG COMPLETED 2020-02-22 02:24 2020-02-22 02:28 56.26G 56.26G 249.42M 00:03:51
4123 ARCHIVELOG COMPLETED 2020-02-23 23:04 2020-02-22 23:12 59.87G 59.88G 126.94M 00:08:03
4156 DB INCR COMPLETED 2020-02-23 00:04 2020-02-23 00:33 59.89G 59.89G 34.73M 00:29:26
4159 ARCHIVELOG COMPLETED 2020-02-23 01:04 2020-02-23 01:13 59.93G 59.94G 121.53M 00:08:25
4163 ARCHIVELOG COMPLETED 2020-02-23 23:04 2020-02-22 23:12 59.87G 59.88G 126.94M 00:08:03
4193 ARCHIVELOG COMPLETED 2020-02-24 02:58 2020-02-24 03:03 65.98G 65.98G 226.74M 00:04:58
4195 DB INCR COMPLETED 2020-02-24 03:02 2020-02-24 03:34 574.54G 4.95G 2.67M 00:31:41
4199 ARCHIVELOG COMPLETED 2020-02-24 03:36 2020-02-24 03:42 66.07G 66.07G 214.78M 00:05:15
4202 ARCHIVELOG COMPLETED 2020-02-24 04:08 2020-02-24 04:11 66.07G 66.08G 393.38M 00:02:52
4299 ARCHIVELOG COMPLETED 2020-02-25 01:04 2020-02-25 01:08 76.69G 76.69G 409.02M 00:03:12
4302 DB INCR COMPLETED 2020-02-25 02:02 2020-02-25 02:10 574.54G 5.95G 12.36M 00:08:13
4304 ARCHIVELOG COMPLETED 2020-02-25 02:04 2020-02-25 02:09 76.74G 76.74G 242.54M 00:05:24
4308 ARCHIVELOG COMPLETED 2020-02-25 02:11 2020-02-25 02:15 76.74G 76.74G 370.68M 00:03:32
4404 ARCHIVELOG COMPLETED 2020-02-26 01:06 2020-02-26 01:17 87.23G 87.24G 131.18M 00:11:21
4407 DB INCR COMPLETED 2020-02-26 02:01 2020-02-26 02:12 574.54G 5.93G 9.49M 00:10:40
4409 ARCHIVELOG COMPLETED 2020-02-26 02:05 2020-02-26 02:14 87.24G 87.24G 160.39M 00:09:17
4413 ARCHIVELOG COMPLETED 2020-02-26 02:15 2020-02-26 02:21 87.24G 87.25G 230.26M 00:06:28

As per above output backup is successfull, Connect rman prompt and remove old archive log files

RMAN>delete noprompt archivelog until time 'sysdate-7' backed up 1 times to device type disk;

or

Manually delete from ASM command prompt

Note:Not recomended approach since by deleting manually it won't release space we need to run (CROSSCHECK ARCHIVELOG ALL command from RMAN to release space)

ASMCMD> pwd
+FRA/INSISCLN/ARCHIVELOG
ASMCMD> ls
2020_02_19/
2020_02_20/
2020_02_21/
2020_02_22/
2020_02_23/
2020_02_24/
2020_02_25/
2020_02_26/
ASMCMD>cd 2020_02_19/
ASMCMD>rm *.arc
ASMCMD> ..
ASMCMD> ls
2020_02_20/
2020_02_21/
2020_02_22/
2020_02_23/
2020_02_24/
2020_02_25/
2020_02_26/

After removing old archive logfile with retention of 7 days check current FRA usage.

SQL> Select space_limit/1024/1024/1024 TOTAL_GB,space_used/1024/1024/1024 USED_GB from v$recovery_file_dest;

TOTAL_GB USED_GB
---------- ----------
120 73.8515625

Check the fra usage in percentage with below select statement

SQL> Select x.*,round(100 * (x.SPACE_USED/x.SPACE_LIMIT), 3) fra_pct_used from v$recovery_file_dest x;

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID FRA_PCT_USED
----- ----------- ---------- ----------------- --------------- ---------- ----------
+FRA 1.2885E+11 9.5404E+10 9.5404E+10 285 0 62.043