Skip to main content

How to Delete Archive log in Oracle 12c

How to Delete Archive log in Oracle 12c

Oracle Database lets you save filled groups of redo log files in offline ,This process is only possible if the database is running in ARCHIVELOG mode..
[[email protected] / ] $ rman  target /
ARCHIVE REDO LOG
RMAN> crosscheck archivelog all;
Use the following command to  delete all archivelog 
RMAN>delete archivelog;
Use the following command to delete expired archivelog 
 
RMAN>delete noprompt expired archivelog all;

BACKUPSET
RMAN>crosscheck backup;
Use the following command to delete all backupset
RMAN>delete backup;

Popular posts from this blog

How to disable Apache Commons Logging statement in Our Java Application

In recent times, One of the java project applications is started printing apache-commons logs in the application logs. Turns out due to the changes in the migration process. The log4j.xml from the apache-commons is taken into account in the classpath due to that the application logs keep piling up and at some point of time the servers end up with no storage spaces, To disable the Apache commons logs from the Apache commons-logging module. Add the following parameter in the Java args during the server startup. -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.NoOpLog
Read more

How to configure Custom Keystore & SSL in Oracle Weblogic 12c with WLST

In this post, we are going to see how to configure Custom keystore and SSL in Weblogic 12c through WLST. Before configuring ensure that your Weblogic server is up and running. Use the below script and run the script through WLST to configure Keystore and SSL ===== SCRIPT STARTS ============ // connect to Weblogic server. alter the ip-address and port as per your server configurations connect('admin', '[email protected]', t3://ip-address:port) edit() startEdit() // We are going to update the Keystore and SSL in AdminServer. Alter as per your needs cd('/Servers/' + 'AdminServer') cmo.setKeyStores('CustomIdentityAndCustomTrust') cmo.setCustomIdentityKeyStoreFileName('/path/to/keystore/jks/file') cmo.setCustomIdentityKeyStorePassPhrase('passphrase') cmo.setCustomIdentityKeyStoreType('JKS') cmo.setCustomTrustKeyStoreFileName('/path/to/keystore/jks/file') cmo.setCustomTrustKeyStorePassPhrase('pa
Read more

Uses of RLWRAP in SQL*Plus and How to Install RLWRAP in Centos 7

Everybody who works in Oracle Database knows how it's powerful but it also has its limitations.By installing the readline wrapper utility (rlwrap) we can able to use the "up arrow" and "down arrow" keys to display the command line history for all SQL*Plus commands and also it has the ability to edit the SQL*Plus commands. To install the rlwrap in the Centos Environment. Install rlwrap as a root user. Use the below commands to install rlwrap   wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm   rpm -Uvh epel-release-latest-7.noarch   yum install rlwrap HOW TO USE IT FOR SQL*Plus   rlwrap sqlplus / as sysdba Also, we can use rlwrap for other commands too
Read more