• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for April 2019

How to Move/Restore Oracle Database to New Host and File System using RMAN

by admin

You may need to restore a database to a new server due to the following reasons: confirming your disaster recovery strategy cloning a database to a new server for UAT or or PRE-PRODUCTION moving the database to a new server This post will work for all file systems – ASM, OCFS, raw, cooked etc. The […]

Filed Under: oracle, RMAN

Oracle Interview Questions : Recovery catalog for RMAN backup

by admin

Why use a recovery catalog? The RMAN catalog has several benefits. It makes restore if all the target database is lost, including the controlfile. As that controlfile contains all backup information, the catalog would then be used to identify a controlfile backup. If an RMAN catalog is not used, the controlfile autobackup should be configured […]

Filed Under: Interview Questions, oracle, RMAN

How to Configure rsyslog Server to Accept Logs via SSL/TLS

by admin

Purpose of this post is to explain how to configure rsyslog server to transmit logs via SSL/TLS. Logs which were transmitted from client to rsyslog server will be encrypted over n/w so that we have additional level security. Procedure Summary As we need to establish trust between client/server we would need to generate the CA […]

Filed Under: CentOS/RHEL 6, Linux, OEL 6

How to duplicate a Oracle Database to a previous Incarnation

by admin

NOTE: In 11.2, there is a new option to duplicate syntax, INCARNATION, which allows you to duplicate the database to a previous incarnation using the RMAN duplicate command. For example: run { allocate auxiliary channel ch1 type ‘SBT_TAPE’ parms’ENV=(NB_ORA_CLIENT=xxx.com,NB_ORA_SERV=xxx.com)’; allocate auxiliary channel ch2 type ‘SBT_TAPE’ parms’ENV=(NB_ORA_CLIENT=xxx.com,NB_ORA_SERV=xxx.com)’; allocate auxiliary channel ch3 type ‘SBT_TAPE’ parms’ENV=(NB_ORA_CLIENT=xxx.com,NB_ORA_SERV=xxx.com)’; duplicate database […]

Filed Under: oracle, Oracle 10g, Oracle 11g

How to Enable Remote Desktop to Share the Current Desktop Session in CentOS/RHEL 7

by admin

Steps to enable remote desktop access in CentOS/RHEL 7. This can either be done via the following: In the GUI 1. From an active desktop session, do the following: Ciick on Applications -> System Tools -> Settings -> Sharing -> Screen Sharing and turn it on. Using Command Line 1. Install vino-server package, vino is […]

Filed Under: CentOS/RHEL 7, Linux

Running RMAN DUPLICATE / RESTORE on a different version than source database version.

by admin

The Problem 1. RMAN DUPLICATE fails as below: input datafile copy recid=22 stamp=717598749 filename=/temp_datavol/clone_files/DUPTEST1/datafile/largetbl.298.684694005 datafile 24 switched to datafile copy input datafile copy recid=23 stamp=717598749 filename=/temp_datavol/clone_files/DUPTEST1/datafile/audittbl.449.690377511 datafile 25 switched to datafile copy input datafile copy recid=24 stamp=717598750 filename=/temp_datavol/clone_files/DUPTEST1/datafile/largetbl.988.713432115 contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script Segmentation fault The […]

Filed Under: oracle, RMAN

Oracle RMAN: Monitoring Recovery Manager Jobs

by admin

Sometimes it is useful to identify what a server session performing a backup or copy operation is doing. You have access to several views that can assist in monitoring the progress of or obtaining information about RMAN jobs: View Description V$PROCESS Identifies currently active processes. V$SESSION Identifies currently active sessions. Use this view to determine […]

Filed Under: oracle, RMAN

How to Delete the Files Which are Older Than n Days WITHOUT Using find Command

by admin

Question: How to delete the files which are older than n days WITHOUT use find command? For some reason, the find command is not used to check which files are older than n days, as a substitute, ‘tmpwatch‘ can be used The syntax is: # tmpwatch [time in hours] [directory] For example, to delete files […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Fedora, Linux

How to determine file and free space fragmentation of OCFS2

by admin

Below is a list of steps to determine the extent fragmentation of disk space on OCFS2. Steps should work on an offlined o2image and provide an indication for fragmentation-related performance problems. Checking the fragments in OCFS2 volume 1.Use debugfs.ocfs2 to display on-disk OCFS2 filesystem structures on /dev/$your_ocfs2_volume, see the following example: # debugfs.ocfs2 /dev/sdb debugfs.ocfs2 […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Linux

Connection using SSH to a Host Not in DNS/hosts Stalls for Some Time at Connection Initiation

by admin

ssh, scp or sftp to a node that doesn’t appear in DNS or /etc/hosts file is slow to make an initial connection. After the connection is established, the speed is as expected. There are two cases to consider, see below. Note that in most environments this issue will not occur since IPs will be in […]

Filed Under: CentOS/RHEL 5, CentOS/RHEL 6, CentOS/RHEL 7, Linux

Next Page »

Primary Sidebar

Recent Posts

  • ncat Command Examples in Linux
  • ncat: command not found
  • nautilus Command Examples in Linux
  • namei: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright