Datapump backup in Windows and backup files deleted older than N days

set mydate=%date:/=%
set mytime=%time::=%
set dt=%mydate: =_%_%mytime:.=_%
D:\app11g\product\11.2.0\dbhome_1\BIN\expdp dbbkp/*** directory=dir1 dumpfile=utilitydb_%dt%.dmp schemas=webserv,bautility logfile=utilitydb_%dt%.log

 forfiles /P D:\database_backup\ /S /M *.dmp  /D -7 /C "cmd /c del @PATH"
forfiles /P D:\database_backup\ /S /M *.log  /D -7 /C "cmd /c del @PATH"


batch File Name: utilitydb.bat

Install Oracle Solaris 11.3 on Oracle VM VirtualBox

Step-1: Download and install Oracle VM VirtualBox

Step-2: Must have to enable hardware virtualization support in the BIOS. Oracle Solaris depends on those capabilities.


Step-3:

ASM meta data

SPOOL ASM1_GENERIC_ASM_METADATA.html
-- ASM VERSIONS 10.1, 10.2, 11.1, 11.2, 12.1 & 12.2
SET MARKUP HTML ON
SET ECHO ON

SET PAGESIZE 200

ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';

SELECT 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , SYSDATE " " FROM DUAL;
SELECT 'INSTANCE NAME: ==)> ' , INSTANCE_NAME " " FROM V$INSTANCE;

SELECT 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " FROM V$SESSION WHERE PROGRAM LIKE '%SMON%';

SELECT * FROM V$INSTANCE;

SELECT * FROM GV$INSTANCE;

SELECT * FROM V$ASM_DISKGROUP;

SELECT GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, MODE_STATUS, STATE, OS_MB, TOTAL_MB, FREE_MB, NAME, FAILGROUP, PATH
FROM V$ASM_DISK ORDER BY GROUP_NUMBER, FAILGROUP, DISK_NUMBER;

SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;

SELECT SUBSTR(D.NAME,1,16) AS ASMDISK, D.MOUNT_STATUS, D.STATE,
DG.NAME AS DISKGROUP FROM V$ASM_DISKGROUP DG, V$ASM_DISK D
WHERE DG.GROUP_NUMBER = D.GROUP_NUMBER;

SELECT * FROM V$ASM_CLIENT;

SELECT DG.NAME AS DISKGROUP, SUBSTR(C.INSTANCE_NAME,1,12) AS INSTANCE,
SUBSTR(C.DB_NAME,1,12) AS DBNAME, SUBSTR(C.SOFTWARE_VERSION,1,12) AS SOFTWARE,
SUBSTR(C.COMPATIBLE_VERSION,1,12) AS COMPATIBLE
FROM V$ASM_DISKGROUP DG, V$ASM_CLIENT C
WHERE DG.GROUP_NUMBER = C.GROUP_NUMBER;

SELECT * FROM V$ASM_ATTRIBUTE;

SELECT * FROM V$ASM_OPERATION;
SELECT * FROM GV$ASM_OPERATION;

SELECT * FROM V$VERSION;

SELECT * FROM V$ASM_ACFSSNAPSHOTS;
SELECT * FROM V$ASM_ACFSVOLUMES;
SELECT * FROM V$ASM_FILESYSTEM;
SELECT * FROM V$ASM_VOLUME;
SELECT * FROM V$ASM_VOLUME_STAT;

SELECT * FROM V$ASM_USER;
SELECT * FROM V$ASM_USERGROUP;
SELECT * FROM V$ASM_USERGROUP_MEMBER;

SELECT * FROM V$ASM_DISK_IOSTAT;
SELECT * FROM V$ASM_DISK_STAT;
SELECT * FROM V$ASM_DISKGROUP_STAT;

SELECT * FROM V$ASM_TEMPLATE;

SHOW PARAMETER

SHOW SGA

!echo "SELECT '" > /tmp/GPNPTOOL.SQL 2> /dev/null
! $ORACLE_HOME/bin/gpnptool get >> /tmp/GPNPTOOL.SQL 2>> /dev/null
!echo "' FROM DUAL;" >> /tmp/GPNPTOOL.SQL 2>> /dev/null
! cat /tmp/GPNPTOOL.SQL
SET ECHO OFF

--DISPLAYS INFORMATION ABOUT THE CONTENTS OF THE SPFILE.
SELECT * FROM V$SPPARAMETER ORDER BY 2;
SELECT * FROM GV$SPPARAMETER ORDER BY 3;

--DISPLAYS INFORMATION ABOUT THE INITIALIZATION PARAMETERS THAT ARE CURRENTLY IN EFFECT IN THE INSTANCE.
SELECT * FROM V$SYSTEM_PARAMETER ORDER BY 2;
SELECT * FROM GV$SYSTEM_PARAMETER ORDER BY 3;

-- 12C ACFS VIEWS

SELECT * FROM V$ASM_ACFS_ENCRYPTION_INFO;
SELECT * FROM V$ASM_ACFSREPL;
SELECT * FROM V$ASM_ACFSREPLTAG;
SELECT * FROM V$ASM_ACFS_SEC_ADMIN;
SELECT * FROM V$ASM_ACFS_SEC_CMDRULE;
SELECT * FROM V$ASM_ACFS_SEC_REALM;
SELECT * FROM V$ASM_ACFS_SEC_REALM_FILTER;
SELECT * FROM V$ASM_ACFS_SEC_REALM_GROUP;
SELECT * FROM V$ASM_ACFS_SEC_REALM_USER;
SELECT * FROM V$ASM_ACFS_SEC_RULE;
SELECT * FROM V$ASM_ACFS_SEC_RULESET;
SELECT * FROM V$ASM_ACFS_SEC_RULESET_RULE;
SELECT * FROM V$ASM_ACFS_SECURITY_INFO;
SELECT * FROM V$ASM_ACFSTAG;

-- 12C ASM AUDIT VIEWS

SELECT * FROM V$ASM_AUDIT_CLEAN_EVENTS;
SELECT * FROM V$ASM_AUDIT_CLEANUP_JOBS;
SELECT * FROM V$ASM_AUDIT_CONFIG_PARAMS;
SELECT * FROM V$ASM_AUDIT_LAST_ARCH_TS;

-- 12C ASM ESTIMATE VIEW

SELECT * FROM V$ASM_ESTIMATE;
SELECT * FROM GV$ASM_ESTIMATE;

SPOOL OFF

EXIT

Shutdown and Startup Script

=====Shutdown Script====
#!/bin/bash

export TMP=/tmp
export TMPDIR=$TMP
export PATH=/usr/sbin:/usr/local/bin:$PATH
export ORACLE_HOSTNAME=qpaydb.nblbd.com
export ORACLE_UNQNAME=remitdb
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4.0/dbhome_1

export ORACLE_SID=remitdb
ORAENV_ASK=NO
. oraenv
ORAENV_ASK=YES

# Stop Database
sqlplus / as sysdba << EOF
SHUTDOWN IMMEDIATE;
EXIT;
EOF

# Stop Listener
lsnrctl stop

# stop the Enterprise Manager db console
$ORACLE_HOME/bin/emctl stop dbconsole


=====Startup Script====
#!/bin/bash
export TMP=/tmp
export TMPDIR=$TMP
export PATH=/usr/sbin:/usr/local/bin:$PATH
export ORACLE_HOSTNAME=qpaydb.nblbd.com
export ORACLE_UNQNAME=remitdb
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4.0/dbhome_1

export ORACLE_SID=remitdb
ORAENV_ASK=NO
. oraenv
ORAENV_ASK=YES

# Start Listener
lsnrctl start

# Start Database
sqlplus / as sysdba << EOF
STARTUP;
EXIT;
EOF

# start the Enterprise Manager db console
$ORACLE_HOME/bin/emctl start dbconsole

Dump Backup Script

#!/bin/bash
vdate=nblt24ac_`date '+%d%m%Y%H%M'`
v1=01
v2=02
v3=03
v4=04
v5=05
v6=06
v7=07
v8=08
v9=09
v10=10
v11=11
v12=12
v13=13
v14=14
v15=15
v16=16
expdp t24backup/t24backup DIRECTORY=dir_n1 dumpfile=$vdate%U.dmp logfile=$vdate.log schemas=nblt24 parallel=16 compression=all EXCLUDE=STATISTICS CLUSTER=N metrics=y
gzip /db_dump/soft/$vdate$v1.dmp
gzip /db_dump/soft/$vdate$v2.dmp
gzip /db_dump/soft/$vdate$v3.dmp
gzip /db_dump/soft/$vdate$v4.dmp
gzip /db_dump/soft/$vdate$v5.dmp
gzip /db_dump/soft/$vdate$v6.dmp
gzip /db_dump/soft/$vdate$v7.dmp
gzip /db_dump/soft/$vdate$v8.dmp
gzip /db_dump/soft/$vdate$v9.dmp
gzip /db_dump/soft/$vdate$v10.dmp
gzip /db_dump/soft/$vdate$v11.dmp
gzip /db_dump/soft/$vdate$v12.dmp
gzip /db_dump/soft/$vdate$v13.dmp
gzip /db_dump/soft/$vdate$v14.dmp
gzip /db_dump/soft/$vdate$v15.dmp
gzip /db_dump/soft/$vdate$v16.dmp
#scp /db_dump/soft/$vdate* oracle@172.31.10.6:/dump_backup/