Skip to content
Ed Chen Logo

Ed Chen Logic

To Make My Logic More Logical
  • Privacy Policy
Ed Chen Logo

Ed Chen Logic

To Make My Logic More Logical
  • Privacy Policy

Building a Physical Standby Database (04/14) - Enable force logging and archivelog on primary database

  • by Ed Chen
  • November 16, 2012August 5, 2020
Building a Physical Standby Database (03/14) - Prepare pfile for both primary and standby databaseFor reflecting and tracking all the changes on the primary database… Read More »Building a Physical Standby Database (04/14) - Enable force logging and archivelog on primary database

Building a Physical Standby Database (03/14) - Prepare pfile for both primary and standby database

  • by Ed Chen
  • November 15, 2012August 5, 2020
Building a Physical Standby Database (02/14) - Prepare configuration files on both sidesNow, we are close to the core of a database. The pfile contains… Read More »Building a Physical Standby Database (03/14) - Prepare pfile for both primary and standby database

Building a Physical Standby Database (02/14) - Prepare configuration files on both sides

  • by Ed Chen
  • November 14, 2012January 11, 2021
Building a Physical Standby Database (01/14) - Install an empty database on standbyThere are four configuration files needs to be prepared on both sides, the… Read More »Building a Physical Standby Database (02/14) - Prepare configuration files on both sides

Building a Physical Standby Database (01/14) - Install an empty database on standby

  • by Ed Chen
  • November 13, 2012August 5, 2020
Go Back to Overview Page - Building a Physical Standby Database (00/14) - An OverviewAssuming the db_name is already there for the running primary database,… Read More »Building a Physical Standby Database (01/14) - Install an empty database on standby

Building a Physical Standby Database (00/14) - An Overview

  • by Ed Chen
  • November 12, 2012August 5, 2020
Building a standby database will adopt various Oracle database technologies, such as Oracle Net, RMAN backup and recovery, duplication, startup and shutdown, data guard and… Read More »Building a Physical Standby Database (00/14) - An Overview

How to Change the Apply Instance on a Standby RAC Database

  • by Ed Chen
  • November 11, 2012January 13, 2021
If you have not assign a preferred apply instance in the broker configuration in advance, the broker will choose one of running instances randomly to… Read More »How to Change the Apply Instance on a Standby RAC Database

How to Get the Execution Plan of a Specific Statement

  • by Ed Chen
  • November 10, 2012March 1, 2021
Sometime, there is no OEM around to check the explain plan of a specific statement. We need a bare way to do the job. Here… Read More »How to Get the Execution Plan of a Specific Statement

How to Clean ASM Candidate Disks

  • by Ed Chen
  • November 9, 2012February 24, 2021
OS administrator might claim the candidate disks prepared for you to install ASM are newly created and very clean. But if they are not, then,… Read More »How to Clean ASM Candidate Disks

How to Resolve ORA-12537:TNS:connection closed

  • by Ed Chen
  • November 8, 2012February 3, 2021
  • 4 Comments
ORA-12537 Overview There're several possible causes to raise ORA-12537: Incorrect File Permission White or Black List ORA-12537 Caused by Incorrect File Permission Incorrect file permission… Read More »How to Resolve ORA-12537:TNS:connection closed

How to Automatically Startup RAC Database after System Reboots

  • by Ed Chen
  • November 7, 2012July 9, 2019
After installing grid infrastructure, you will have Oracle Clusterware, also called Cluster Ready Service, CRS controls all Oracle cluster components as resources, and manages the… Read More »How to Automatically Startup RAC Database after System Reboots
  • « Previous
  • 1
  • …
  • 79
  • 80
  • 81
  • 82
  • 83
  • …
  • 85
  • Next »

Search This Website

Bookmark This Page

★By Pressing Ctrl + D

Recent Posts

  • How to Resolve RMAN-03009: failure of allocate command on channel
  • How to Resolve ORA-01624: log needed for crash recovery of instance
  • How to Modify VARCHAR2 into CLOB of a Column
  • How RMAN Duplex Backup Copies
  • How RMAN Set Backup Location

Categories

Recent Comments

  • Ed Chen on 3 Steps to Make Filezilla Preserve Timestamp
  • Ed Chen on How to Resolve ORA-01861: literal does not match format string
  • Barry Marshall on 3 Steps to Make Filezilla Preserve Timestamp
  • Ummati on How to Resolve ORA-01861: literal does not match format string
  • Ed Chen on How to Resolve ORA-12560 on Windows Server

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Neve | Powered by WordPress