RTO, RPO and RLO are very important expressions for information technology companies. You can find descriptions of these expressions. Recovery Point Objective (RPO) RPO is used to determine the maximum amount of time between the last available backup and potential failure point. Recovery point objective (RPO) helps in determining the amount of data that the…
How to Create Virtual IP Address on Oracle Linux System
You can create virtual IP addresses on Oracle Linux, Redhat and Centos Operating Systems with below operations. Virtual IP address can be temporary or static according to your wishes. You have to have a ethernet adaptor interface for example eth0. You can use ifconfig eth0:0 <IP address> syntax to create temporary virtual IP. Create Temporary Virtual…
How to Move Datafiles to New Disk in MsSQL Server 2008
If database data disk space is full or you have another problem about of disk, you can move datafiles to new disk in MsSQL Server 2008 database. Show Current Paths and Names use master go select name,physical_name from sys.master.files where database_id = DB_ID(‘DATABASENAME’) dbf1 D:\OLDLOCATION\disk_1.mdf dbf1_log D:\OLDLOCATION\disk1_log.ldf go Shutdown Database use master go alter database…
How to Migrate Controlfile From File System to ASM Disk in Oracle 11g
You can migrate controlfile from file system to asm disk. You have to stop database and you can do that. Stop Database SQL> shutdown immediate; SQL> startup nomount; Migrate Controlfile RMAN> restore controlfile to ‘+DATA’ from ‘/tmp/controlfile_currentlocation.ctl’; RMAN> restore controlfile to ‘+FRA’ from ‘/tmp/controlfile_currentlocation.ctl’;
SQL Server Reporting Service Start Error 1053 The Service Did Not Respond
Error Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion. Solution
How to Delete psql Command Prompt History in PostgreSQL
When you use psql command prompt, system automaticly saves your prompts. If you use password when user creates operation, this situation can occur security risk. Therefore, you can delete this prompts with editing psql_history file like below. Find And Delete psql Prompts [root@pg ~]# locate .psql_history /var/lib/pgsql/.psql_history [root@pg ~]# vi /var/lib/pgsql/.psql_history
How to Change SSH Port When Selinux is Enable on Oracle Linux 7
SSH service runs on 22 port number. You can change this port number for security. If you use Oracle Linux 7, Centos 7 or Red Hat Linux 7 versions, you can change port number with below operations. If selinux is enabled, you have to add new port number to selinux configuration because of the fact…
Oracle Cluster Service Control Commands CRSCTL
crsctl is Oracle Clusterware management command. You can check, start, stop clusterware with crsctl. crsctl command directory is $GRID_HOME/bin. You can do below operations with crsctl Starting and stopping Oracle Clusterware resources Enabling and disabling Oracle Clusterware daemons Checking the health of the cluster Managing resources that represent third-party applications Integrating Intelligent Platform Management Interface…
Linux Logical Volume Manager Configuration And Extend Disk Operation
Logical Volume Manager is a disk partitioning solution on linux systems. This architecture provides advantages. You can extend disk size easily with lvm without losing exist data. But, If you use fdisk that is classical method for partition, you can not resize this partitions without losing data. You can follow below steps to configure lvm….
Fstab Cannot Writable
If you mount disk with wrong uuid or wrong text in fstab file, you get an error when system restart. Your system can not open. If you want to change fstab, you can not change this file because of read only. You can change this status with “mount -o remount,rw /” command. This command provides…