In order to restrict the connections to the database
we can add some parameters in the sqlnet.ora file under ORACLE_HOME form where
listener is running. This would make sure that sessions to the database are
coming only from specific list of hosts, and any session from all other hosts
is not allowed to connect to the database. Following are the parameters we can
use for such restriction.
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Wednesday, November 27, 2019
Saturday, November 16, 2019
Archivelog Deletion Policy for RMAN
RMAN archive deletion
policy is used to set when we want archived logs to be deleted when DELETE
ARCHIVELOG command is executed from the RMAN prompt, or if we are using Fast
Recovery Area for archived logs, and are not deleting archived logs manually and
relying on automatic feature of Oracle for deletion of archived logs (archive
deletion would happen automatically if space crunch is observed by Oracle under
fast recovery area).