RMAN List Backup Summary command

one of the useful RMAN commands is:

RMAN> list backup summary;

list_summary_columns.jpg

list_summary2

so what are these columns represent ?

* LV column lists the following:

0 = incremental level 0 backup

1 = incremental level 1 backup

A = archivelogs

f = full – backup database command

* S is the status:

A = available

U = unavailable

As mentioned above F can represent either “FULL” backup or “Control File” Backup. If your RMAN configuration for controlfile auto-backup is set to “ON” , the control file backup will be taken automatically each time RMAN backup runs as shown in the above picture.

The RMAN configuration is:

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

 

 

 

 

 

 

 

 

 

 

ArcGIS 10.6.1 error after Oracle 18c upgrade

In ESRI ArcGIS Geodatabase environment its very important to maintain your product life-cycle support. ArcGIS 10.6.1 is compatible with Oracle 18c ….however when you upgrade both environments (ArcSDE & Oracle)  and attempt to connect through ArcGIS Desktop , the following error will be thrown:

 

DBMS error[Unkown errorNo extended error]

arcgis_error

This is a known bug by ESRI, the solution is to apply the following patch on your ArcGIS Desktop software:

https://support.esri.com/en/download/7675

 

 

Oracle oraversion

Since Oracle 18c after you successfully apply the patches on the database binaries you will notice that when you invoke sqlplus after that…the version is immediately changed/reflected:

In 19c, after patching the database binaries sqlplus is referencing 19.4 version number

Picture1

This is due to changes being reflected in a file called “oraversion” under $ORACLE_HOME/bin directory

Picture2

For example:

$ORACLE_HOME/bin/oraversion -baseVersion

Picture3

$ORACLE_HOME/bin/oraversion -compositeVersion

Picture4