Rolling Forward a Physical Standby Database Using the RECOVER FROM SERVICE Command A standby database is a transactionally consistent copy of the production database. It enables production Oracle databases to survive disasters and data corruption. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch a standby […]
Oracle 12c Data Pump New Features
This post provides an Overview of all Data Pump related New Features of the Oracle Database 12.2 Release. Oracle Data Pump Parallel Import of Metadata The PARALLEL parameter for Oracle Data Pump, which was previously applied only to data, has been extended to include metadata import operations. The performance of Oracle Data Pump import jobs […]
How to Create backupdba, dgdba and kmdba groups after the 12c, 18c and 19c binary installation
Users in the OSDBA group are granted the SYSDBA administrative privilege. Similarly, the OSOPER group is used to grant SYSOPER administrative privilege to users, the OSBACKUPDBA group is used to grant SYSBACKUP administrative privilege to users, the OSDGDBA group is used to grant SYSDG administrative privilege to users, and the OSKMDBA group is used to […]
How to Roll Forward Physical Standby Using RMAN Incremental Backup in Oracle 18c
For the purposes of this post, the following environment is used as an example to describe the procedure: Standby Name: SBY180 Primary Name: PRM180 Directory Name: /u01/app/oracle and all sub-directories Typically, when rolling forward a physical standby database using primary incremental backup, multiple steps are required: Identify the Start SCN on Standby for performing incremental […]
How to rename a datafile in the primary database and manually propagate the changes to the standby database
When you rename one or more datafiles in the primary database, the change is not propagated to the standby database, even if the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO. If you do not rename the corresponding datafile at the standby system, and then try to refresh the standby database control file, the standby database […]
How to use the ping command in Linux
Ping is a program that is used to test the reachability of a host. It also measures the time it takes to send the packet and receive one. It does this by sending a ICMP echo request packet and waiting for a reply. Pretty much all Linux flavours will come with Ping pre-installed. How to […]
How to change mac address on Linux temporarily
Whats a MAC address? A MAC address is a physical way of addressing your network card at a hardware level. How to find out your MAC address? Open up a terminal and run: $ ifconfig wlan0 | grep HWaddr Where I have wlan0 you would put your networking device. My output: wlan0 Link encap:Ethernet HWaddr […]
How to change the hostname on ubuntu server
Your hostname is a label that is assigned to your computer so that it can be identified. There are only a couple of steps: Step 1 Edit /etc/hosts: $ sudo vi /etc/hosts You dont have to use vi you can open it with any text editor. Here you should see your current hostname, change it […]
How to install Raspian on the raspberry pi
There are lots of different ways of installing Raspian to an sd card like win32diskimager and usb image writer but an even easier way is with dd. Things I am going to show you: How to locate your sd card in the command line. Where to download the image from. How to install the image […]
How to use apt-get on debian or ubuntu systems
The advanced package tool, also known as APT is a tool that is used for the easy installation, removal and upgrading of software on Debian/Ubuntu systems. Things that I will show you how to do: Search for packages using apt-get Update system package lists Upgrade software packages Install and remove specific software packages Check for […]