relocate undo tablespaces oracle

#undo tablespace

SQL>create undo tablespace undotbs2 datafile '/new_location/newundo02.dbf' size 2000m;

#Set new tablespace as undo tablespace
SQL> alter system set undo_tablespace= undotbs2 ;

#Drop old undotbs tablespace
SQL> drop tablespace undotbs including contents;

relocate tempfile oracle

EXAMPLE:

sql>alter database tempfile 'D:\APP\PRAMOTE.L\ORADATA\DW\TEMP01.DBF' offline;

copy tempfile to new location

sql>alter database rename file 'D:\APP\PRAMOTE.L\ORADATA\DW\TEMP01.DBF' to 'E:\oradata\dw\temp01.dbf';

sql>alter database tempfile 'E:\oradata\dw\temp01.dbf' online;

Remove GlobalProtect

Error msg

"An instance of GlobalProtect is already present on the system. Uninstall the current version before attempting to install the new version of GlobalProtect"

- Remove the registry items within the following registry path (Windows OS):
      HKEY_LOCAL_MACHINE\Software\Palo Alto Networks\GlobalProtect\PanGPS

- Run the following command as an administrator from the windows cmd line:
       sc delete PanGPS

- Reboot the machine

JAVA 7u45 EMC , NETAPP , Brocade

firefox

about:config
set
security.tls.version.min to 0

Java 7 u45

comment line:

jdk.certpath.disabledAlgorithms=MD2, DSA, RSA keySize < 2048

in

C:\Program Files (x86)\Java\jre7\lib\security\java.security file

Ubuntu 14.0.4.1 “intel_rapl: no valid rapl domains” message upon boot

add blacklist intel_rapl in file

/etc/modprobe.d/blacklist.conf

enable webtool Brocade DS300, JAVA 1.7

comment line:

jdk.certpath.disabledAlgorithms=MD2, DSA, RSA keySize < 2048

in

C:\Program Files (x86)\Java\jre7\lib\security\java.security file

Clear SBT_TAPE oracle

Configure Oracle Virtual TAPE DEVICE driver
==================================

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/Path_to_backup)';


Exaple:
=======
- RMAN configure with SBT_TAPE devices

RMAN configuration parameters for database with db_unique_name MEIS are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/products/11.2.0.2.0/db_1/dbs/snapcf_MEIS.f'; # default


- Configure SBT_TAPE DEVICE and Config CHANNEL to Virtual Disk (load oracle tape device drivers)

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/Path_to_backup)';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

- SHOW Backup and Copy Image

LIST BACKUP;
LIST COPY;

- Crosscheck Backup set for marking backup set to 'EXPIRED'

CROSSCHECK BACKUP;

- Delete expired backupset

DELETE EXPIRED BACKUP;


- Show Configuration

RMAN configuration parameters for database with db_unique_name NIDAREG are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/u03)";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default


- Clear SBT_TAPE CHANNEL and DEVICE

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
CONFIGURE DEVICE TYPE 'SBT_TAPE' CLEAR;


- Crosscheck Backup

CROSSCHECK BACKUP;
DELETE EXPIRED BACKUP;

-Set Device
-Clear Chanel----> Device