Sunday 21 March 2021

Rebuild Standby database using incremental backup in case if its lagging:

 


1- Take the current scn from the standby database:

SQL> select  

current_scn

from

v$database;

 

CURRENT_SCN

-----------

     255263


2- Take incremental from the target SCN 255263:

RMAN> backup incremental from scn 485263 database format '/u02/inc_backup_%U';


3- Move the backup pieces to standby server and register it:

RMAN> catalog start with '/u02/';


4- Rolling forward the generated backup:

recover database noredo;


Monday 15 March 2021

Enable and configure mailx in Linux

 To start sending mails from Linux machine we need to install mailx:

dnf install mailx 


Configure the sender information in /etc/mail.rc:

Add below at the end of /etc/mail.rc file:


set smtp=smtps://smtp.gmail.com:465

set smtp-auth=login

set smtp-auth-user=mygmailuser@gmail.COM

set smtp-auth-password=mypassword

set ssl-verify=ignore

set nss-config-dir=/etc/pki/nssdb/


Number of Visitors