Wednesday 31 January 2018

RMAN : Clear archivelogs from flash_recovery_area

Manually delete the archive log in the flash_recovery_area and run the below commands.


$ rman target /
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...