Recently i was working on moving some data file on the primary server and i have set the standby_file_management=’MANUAL’. and  then I saw the following error on my standby server. ALTER DATABASE RECOVER managed standby database disconnect from sessionAttempt to…

Frist Create file vi rman_script.sh then add the following lines in rman_script.sh file #!/bin/bash####################################################################  this script will delete the archive and obsolete file on standby server  ############################################################################# ORACLE_HOME=/u01/app/oracle/product/11.2/db_1;export ORACLE_HOME;ORACLE_SID=ORCL;export ORACLE_SID; rman msglog ” now.log ” <<EOFconnect target /;CONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE…

Count All the Rows in all tables in a schema  you can do it various options Option 1.  you can write a sql to get the out output an the then run the output to get the count for all…

We always to test the database for various reasons we will need to create a tables  with a lot of data in it.We can use below script that will allow us to create a table and populate the table with…

SCRIPT TO CREATE TOAD USER : I really had to struggle a lot to get this script.Creating these objects as toad user will allow u to gathers stats for disk ,data file and table spaces growth and trending. This scipt…

SQL> alter database add standby logfile ‘/u02/oracle/oradata/stdby01.log’ size 512M; Database altered. SQL> alter database add standby logfile ‘/u02/oracle/oradata/stdby02.log’ size 512M; Database altered. SQL> alter database drop standby logfile ‘/u02/oracle/oradata/stdby01.log’; Database altered. SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG; GROUP#    THREAD#  SEQUENCE# ARC…