Try connecting with oracle user , instead of root .

Hi Mukesh,

You can refer the below article.

http://dbaclass.com/article/full-database-export-import-using-datapump-utility/

Regards

Admin

Views got invalid, if the dependent objects are not present in the database. Please make sure the dependent objects of the view are present in the database.

Regards

Admin

Hi Rao,

Can you share the existing script you scheduled for the datapump.  We can modify that script to accommodate the alert part.

Regards

Admin

Dear Rao,

We can achieve this. However this is a not a recommended way to handle db locks.

Best way is write a script that will report blocking sessions. And when any alert comes , log in to database and analyze the blocking sessions and take actions.

There might be cases, where application would be causing blocking, and if you kill then it might impact the application. So in that case, follow up with application team to find root cause.

Regards

Admin

One way is –

1. Create a new table like .

create table DML_MONIT ( action_date , insert,update,delete) .

2. Create a triggers with condition, that when any insert,update,delete happens on ur original table, the new table DML_MONIT will be updated accordingly.

like, for each insert, DML_MONIT table column ACTION_DATE will be updated with sysdate and insert will be flagged as 1.

However trigger may impact the performance of the DML operation on the original table, If transactions are very high.

Regards

ADMIN

Dear ,

Ypu can check the same in dba_tab_modifications.

http://dbaclass.com/article/how-to-find-when-a-table-was-last-modified-in-oracle/

Regards

To configure Autostart of ACFS drivers during node reboot on Linux

++ Add an acfsload start command in /etc/rc.local.so they are automatically loaded during node bootup

save the content of the script as arch_bckup.sh and you can execute directly as sh arch_bckup.sh

else you can configure it in crontab with 1 hour interval.

Dear,

Use the below script, Do changes like RMAN_DIR,ORACLE_HOME,ORACLE_SID,ARCH_MP according to your environment.

————————————————————————-

#!/bin/bash
RMAN_DIR=/export/home/oracle/ARCH_BKP
PARALLELISM=2
MAXPIECESIZE=3g
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2_OM/dbhome_1
export ORACLE_SID=ORCLDB
export PATH=$ORACLE_HOME/bin:$PATH
ARCH_MP=/u04

archivebackup() {
rman log=$RMAN_DIR/RMANarch.log << EOF
connect target /
set echo on;
configure controlfile autobackup format for device type disk to ‘$RMAN_DIR/%F’;
configure maxsetsize to unlimited;
configure device type disk parallelism $PARALLELISM;
run
{
allocate channel c1 type disk format ‘${RMAN_DIR}/%I-%Y%M%D-%U’ maxpiecesize ${MAXPIECESIZE};
allocate channel c2 type disk format ‘${RMAN_DIR}/%I-%Y%M%D-%U’ maxpiecesize ${MAXPIECESIZE};
crosscheck archivelog all;
backup archivelog all FILESPERSET=4;
delete noprompt archivelog all completed before ‘SYSDATE-1/2’;
release channel c1 ;
release channel c2 ;
}
configure controlfile autobackup clear;
sql ‘alter system archive log current’;
exit
EOF
}

#### uncommented below 2 for solaris
arch_status=`df -k $ARCH_MP | awk ‘{print $5}’ | grep -v Capacity | cut -d ‘%’ -f1`
echo $arch_status

#### uncomment below 2 only if linux

#arch_status=`df -k $ARCH_MP | awk ‘{print $4}’ | grep -v Available | cut -d ‘%’ -f1`
#echo $arch_status

if [ $arch_status -gt 70 ]; then
archivebackup
fi

———————————————————————————

above script is for solaris, If linux, then check comment section in script, and do uncomment the linux part, and comment the solaris part.

#### uncomment below 2 for solaris
#arch_status=`df -k $ARCH_MP | awk ‘{print $5}’ | grep -v Capacity | cut -d ‘%’ -f1`
#echo $arch_status

#### uncommented below 2 for linux

arch_status=`df -k $ARCH_MP | awk ‘{print $4}’ | grep -v Available | cut -d ‘%’ -f1`
echo $arch_status

Regards

ADMIN