one of the useful RMAN commands is:
RMAN> list backup summary;
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;
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]
This is a known bug by ESRI, the solution is to apply the following patch on your ArcGIS Desktop software:
if you place perl libraries in non-default location, you could face error similar to the below:
Can’t locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 1.
BEGIN failed–compilation aborted at Makefile.PL line 1.
So, the solution is basically setting the environment variable:
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
This is due to changes being reflected in a file called “oraversion” under $ORACLE_HOME/bin directory