Dua Ahad

March 19th, 2026, posted in Dua
Share

Share

Happy Birthday With A Cake

March 7th, 2026, posted in DAtEs iN a YeAR
Share
Share

RMAN-06059: Expected Archived Log Not Found, Loss Of Archived Log Compromises Recoverability

February 22nd, 2026, posted in Oracle Queries
Share
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
Starting backup at 18-NOV-21
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 11/18/2021 17:29:50
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u02/immam/db/apps_st/data/archive/1_500_1195296918.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
RMAN> crosscheck archivelog all;
RMAN> list expired archivelog all;
RMAN> delete expired archivelog all;
Share

ORACLE ERROR:ORA-28000: the account is locked

February 9th, 2026, posted in Oracle Queries
Share
SQL> alter user scott account unlock;
SQL> grant connect, resource to scott;
Share

For Oracle Database Configure Swap Area

January 25th, 2026, posted in Oracle, Oracle EBS Application
Share
If RAM = 1024MB to 2048Mb
then 1.5 times RAM
elseif RAM > 2048MB and 8192MB
then .75 times RAM
  • 1. IF RMAM is 2GB then it lies in 1st condition as per formula then swap area should be 2*1.5= 3 GB
  • 2. If RAM is 4 GB then it lies in 2nd condition as per formula then swap area should be  4 *1 = 4 GB.
  • 3. IF RMAN is 10 GB then it lies in 3rd condition as per formula then swap are should be 10*0.75=7.5 GB
Share