ACFS Oracle ASM Cluster File System is cluster file system service used for High availability services.
Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS for goldengate relate files.
In this article, we will show how to create a ACFS file system in oracle RAC using command line.
ORACLE GRID VERSION – 18.104.22.168
NODES – NODE3 , NODE4
OS – Linux OEL
1.Create an ASM DISKGROUP( ON NODE 3)
sqlplus / as sysasm
SQL> CREATE DISKGROUP ACFSPOC EXTERNAL REDUNDANCY
… Read more
Plugging an Unplugged Pluggable Database
Unplugging the PDB
To unplug a PDB, you first close it and then generate an XML manifest file. The XML file contains information about the names and the full paths of the tablespaces, datafiles of the unplugged PDB. The information will be used by the plugging operation.
We are going to unplug the PDB to plug them with No copy methods.
[oracle@localhost pdb3]$ . oraenv
ORACLE_SID = [cdb1] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@localhost pdb3]$ sqlplus / as sysdba
SQL> show con_name
… Read more
1. Check all services are up and running from 11gR2 GRID_HOME
2. Perform backup of OCR, voting disk and Database.
3. Create new directory for installing 12C software on both RAC nodes.
4. Run “runcluvfy.sh” to verify errors.
5. Install and upgrade GRID from 11gR2 to 12cR1
6. Verify upgrade version
1. Backup the database before the upgrade
2. Database upgrade Pre-check
Creating Stage for 12c database software
Creating directory for 12c oracle home
Check the pre upgrade status.
3.Unzip 12c database software in stage
4Install the 22.214.171.124 using the … Read more
Real Application Testing – step by step
Source Oracle: 11204 (single instance)
Target Oracle: 12102 (2 nodes RAC cluster+pluggable db)
Need to decide/find the times, when would like to capture the load, it’s recommended to start small; 15 mins, 30 mins or max 1 hr
We did for couple of hours, not recommended, but not a bad idea, but should start small first and then proceed, if reports look good (6-11, 9-11, 14-16, 19-22)
Let’s assume our company peak time is 10 am – 11 am… Read more