Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Control File Multiplexing Using Pfile --oracle

-
Control file is head of the every oracle database. If control files lost or corrupt for any kind of physical damage of storage then the database must be shutdown. So every database mast have more than one control files needed on different physical storage. Control files can be multiplexed up to eight times. There are different ways to multiplexing the control file.

Step-1: Shutdown the database as normal
SQL> shutdown normal;

Step-2: Using OS command copy the existing control file to a new name and location
$ cp /u01/app/oracle/oradata/orcl/control01.ctl  /u01/app/oracle/oradata/orcl/control02.ctl

Step-3: Add the new control file name to PFILE
CONTROL_FILES = (/u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/oradata/orcl/control02.ctl)

Step-4: Start the database
SQL> startup;

Comments

Post a Comment

Popular posts from this blog

Pgbadger Feature In Postgresql

-
1. pgBadger reports everything about your SQL queries            Overall statistics            The most frequent waiting queries.            Queries that waited the most.            Queries generating the most temporary files.            Queries generating the largest temporary files.            The slowest queries.            Queries that took up the most time.            The most frequent queries.            The most frequent errors.            Histogram of query times.            Histogram of sessions times.            Users involved in top queries.            Applications involved in to...
Read more

ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info ->>'PRODUCTS' ->>'produc... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

-
postgres=# select * from sales; id | sales_info ----+---------------------------------------------------------------------------------- 1 | { "customer": "NIJAM", "PRODUCTS": {"product_name": "choclate","total_item": 6}} 2 | { "customer": "ABU", "PRODUCTS": {"product_name": "badam","total_item": 5}} 3 | { "customer": "UMAR", "PRODUCTS": {"product_name": "mobile","total_item": 1}} (3 rows) postgres=# SELECT sales_info ->>'customer' as customer_name,sales_info ->>'PRODUCTS' ->>'product_name' as name_of_product from sales where sales_info ->>'customer'='UMAR'; ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info -...
Read more

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

-
set 1 1.What is RMAN? Recovery Manager (RMAN) is a utility that can manage your entire Oracle backup and recovery activities. 2.What is the difference between using recovery catalog and control file?  When new incarnation happens, the old backup information in control file will be lost. It will be preserved in recovery catalog. In recovery catalog we can store scripts.  Recovery catalog is central and can have information of many databases. 3.Can we use same target database as catalog?      No, The recovery catalog should not reside in the target database (database should be backed up), because the database can’t be    recovered in the mounted state. 4.How do you know that how much RMAN task has been completed?    By querying v$rman_status or v$session_longops 5.From where list & report commands will get input? Both the commands command quering v$ and recovery catalog views. V$BACKUP_FILES or many of the recovery catalog views such as RC_...
Read more

7 Steps to configure BDR replication in postgresql

-
Image
 The  BDR  (Bi-Directional Replication) project adds multi-master replication to PostgreSQL 9.4.  Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.   Here We are using  postgres version 9.4.12 and bdr version 1.0.2. for configuring  multi master replication . Simply Following 7 steps you can configure the multi master replication in postgresql. To download the bdr in below link. .   https://github.com/2ndQuadrant/bdr/archive/bdr-pg/REL9_4_12-1.tar.gz $ tar -xzvf REL9_4_12-1.tar.gz $ wget https://github.com/2ndQuadrant/bdr/archive/bdr-plugin/1.0.2.tar.gz $ tar -xzvf 1.0.2.tar.gz 1. To install BDR. $ cd ~/bdr-bdr-pg-REL9_4_12-1 $ ./configure --prefix=/usr/lib/postgresql/9.4 --enable-debug --with-openssl $ make -j4 -s install-world $ cd ~/bdr-bdr-plugin-1.0.2 $ PATH=/usr/lib/p...
Read more

How to Use netstat (network statistics) command In Linux

-
netstat  ( network statistics ) is a command line tool for monitoring network connections both incoming and outgoing as well as viewing routing tables, interface statistics etc.  netstat  is available on all Unix-like Operating Systems and also available on  Windows OS  as well. It is very useful in terms of network troubleshooting and performance measurement.  netstat  is one of the most basic network service debugging tools, telling you what ports are open and whether any programs are listening on ports. This tool is very important and much useful for Linux network administrators as well as system administrators to monitor and troubleshoot their network related problems and determine network traffic performance. This article shows usages of  netstat  command with their examples which may be useful in daily operation. You might also be interested in following article How to work Linux Find Command 1. Listing all the LISTENING Po...
Read more