Check if SQL SERVER account is locked

SELECT LOGINPROPERTY('EWDocCon', 'IsLocked');

where EWDocCon is the user.

0=unlocked
1=locked

Read Audit file for SQL SERVER

select * from fn_get_audit_file('D:\SQL_AUDIT\Audit-20200424-144933_5CC133E8-7A26-4473-A638-ADBD88A6D173_0_132321940222150000.sqlaudit',
default,
default);


select [statement],[event_time] from fn_get_audit_file('D:\SQL_AUDIT\Audit-20200424-144933_5CC133E8-7A26-4473-A638-ADBD88A6D173_0_132321940222150000.sqlaudit',
default,
default);

EBS Cloning

If it was existing before and you just have to refresh.

1. run autoconfig on db tier

It is located on
login as oracle
cd $CONTEX_FILE

for me it was /dbapps/oracle/HRD2/db/tech_st/11.2.0/appsutil/scripts/HRD2_apollo


./adautocfg.sh

2. run autoconfig for appstier

apollo:/dbapps/applmgr>whoami
applmgr
 apollo:/dbapps/applmgr>cd $ADMIN_SCRIPTS_HOME
 apollo:/dbapps/applmgr/HRD2/inst/apps/HRD2_apollo/admin/scripts>./adautocfg.sh

How do I know which EBS am I using

connect as apps
select release_name from apps.fnd_product_groups;

RMAN BEST PRACTICAL PRACTICES

RMAN> configure archivelog deletion policy to backed up 2 times to device type disk;

What flavor of RedHat am I using

cat /etc/redhat-release

How to Test RMAN Tape Backup

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Mar 26 21:46:47 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN>
connected to target database: HYPP (DBID=2806684771)

RMAN>
connected to recovery catalog database

RMAN>
echo set on


RMAN> run {
2> allocate channel oem_sbt_backup type 'sbt_tape' format '%d_%U' parms "NBR_BACKUP_CHANNELS=4NB_ORA_CLASS=ora_octavo_hyppNB_ORA_CLIENT=octavo.ecp.privNB_ORA_SCHED=oracleNB_ORA_SERVER=flexo.ecp.priv";
3> backup as BACKUPSET current controlfile tag '03262020094644';
4> restore controlfile validate from tag '03262020094644';
5> release channel oem_sbt_backup;
6> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on oem_sbt_backup channel at 03/26/2020 21:47:19
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27209: syntax error in device PARMS - unknown keyword or missing =


RMAN> allocate channel for maintenance type 'sbt_tape'  parms "NBR_BACKUP_CHANNELS=4NB_ORA_CLASS=ora_octavo_hyppNB_ORA_CLIENT=octavo.ecp.privNB_ORA_SCHED=oracleNB_ORA_SERVER=flexo.ecp.priv";
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_1 channel at 03/26/2020 21:47:19
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27209: syntax error in device PARMS - unknown keyword or missing =


RMAN> delete noprompt backuppiece tag '03262020094644';
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1764 device type=DISK
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 03/26/2020 21:47:46
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27209: syntax error in device PARMS - unknown keyword or missing =


RMAN> exit;

Recovery Manager complete.


##################################

 run
{
allocate channel t1 device type sbt;
send 'NB_ORA_SERV=agathor,NB_ORA_CLIENT=hermes.ecp.priv';
set archivelog destination to '/dbapps/oracle';
restore archivelog from logseq=48626 until logseq=48627 thread 1;
}