Archive for the ‘TEChNoLoGY’ Category

RMAN SCRIPT TO MAKE BACKUP WITH DATES

April 12th, 2026, posted in Oracle
Share
Share

Checking Tablespace Utilization In Oracle

April 4th, 2026, posted in Oracle Queries
Share
SELECT TABLESPACE_NAME, USED_SPACE,TABLESPACE_SIZE,USED_PERCENT FROM DBA_TABLESPACE_USAGE_METRICS ORDER BY USED_PERCENT DESC;
Select f.tablespace_name , to_char(t.total_space,'9999,9999') "TOTAL(MB)" , to_char((t.total_space-f.free_space),'9999,9999')"USED(MB)", to_char(f.free_space,'999,999') "FREE(MB)", to_char((round(((t.total_space-f.free_space)/t.total_space)*100)),'999')||'%' PER_USED, to_char((round((f.free_space/t.total_space)*100)),'999')||'%'PER_FREE from (select tablespace_name , round (sum(blocks * ( select value/1024 from v$parameter where name='db_block_size')/1024)) free_space from dba_free_space group by tablespace_name)f , (select tablespace_name , round(sum(bytes/1048576)) total_space from dba_data_files group by tablespace_name ) t where f.tablespace_name=t.tablespace_name ;
select tablespace_name , file_name, autoextensible , bytes/1024/1024 "USED SPACE(MB)", maxbytes/1024/1024 " MAX SIZE(MB) " from dba_data_files order by tablespace_name,file_name ;
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