Target Database is Still Available You connect to the target database TEST and then unregister it: rman TARGET SYS/Passwd@TEST CATALOG rman/rman@catdbRMAN> UNREGISTER DATABASE NOPROMPT; Unregistering a Database That is Not Unique in Catalog or Target Database is Unvailable The following UNIX shell script unregisters database testdb from the recovery catalog. Because multiple databases called testdb are registered in the recovery…

Make DBA Life Easy Blog

20.10.2025

Standby Database: arch1_.dbf in $ORACLE_HOME/dbs/ folder – Make DBA Life Easy

There are a lof of arch1_.dbf files in $ORACLE_HOME/dbs/ folder, after standby database recovery area is full. We can just delete them , or leave standby database to clean up after standby database is in sync with primary database. If manually delete them, crosscheck then accordingly: RMAN > crosscheck archivelog all;

Make DBA Life Easy Blog

20.10.2025

Standby Database: *.bin files are observed in $ORACLE_BASE/audit/$ORACLE_SID/ – Make DBA Life Easy

Symptoms There are many *.bin files are observed in $ORACLE_BASE/audit/$ORACLE_SID. For example: $ ls -ltrtotal 666644-rw-------. 1 oracle oinstall 10240512 Sep 19 15:09 ora_audit_1212246579_3985105844.bin-rw-------. 1 oracle oinstall 10241536 Sep 20 06:52 ora_audit_1212303144_3688912851.bin-rw-------. 1 oracle oinstall 20480 Sep 20 12:02 ora_audit_1212321763_3431476539.bin-rw-------. 1 oracle oinstall 12288 Sep 20 12:35 ora_audit_1212323740_3065638769.bin-rw-------. 1 oracle oinstall 10241024 Sep 20 22:35…

Make DBA Life Easy Blog

21.10.2025

Both Success and Failure Logon are audited by unified audit policy ORA_LOGON_FAILURES – Make DBA Life Easy

After running the following statements to disable and enable audit policy ORA_LOGON_FAILURES. SQL> noaudit policy ORA_LOGON_FAILURES;SQL> audit policy ORA_LOGON_FAILURES; Cause The command of audit policy is lack of WHENEVER NOT SUCCESSFUL option, therefore audit policy of ORA_LOGON_FAILURES will audit both LOGON success and LOGON failure. Solution In order to set ORA_LOGON_FAILURES to audit LOGON failure…

home›Make DBA Life Easy Blog

Make DBA Life Easy Blog

Software

How to Unregister a Database from RMAN Repository – Make DBA Life Easy

Standby Database: arch1_.dbf in $ORACLE_HOME/dbs/ folder – Make DBA Life Easy

Standby Database: *.bin files are observed in $ORACLE_BASE/audit/$ORACLE_SID/ – Make DBA Life Easy

Both Success and Failure Logon are audited by unified audit policy ORA_LOGON_FAILURES – Make DBA Life Easy

home
›
Make DBA Life Easy Blog