1- One of the obsolete integrated extract was causing Rman not to delete expired archive logs. orcl:/u02/DBA/scripts ->./delete_arch.sh The Oracle … More
Category: Dataguard
How to tell/find if the instance is Primary/Standby?
By querying v$database one can tell if the host is primary or standby For primary testdb> select database_role from v$database; … More
Script to delete arch logs from the Standby database host after applied
#!/usr/bin/ksh ################################################################################################################## # # This script is to delete the arch logs for the standby database after it has applied … More
