Infrastructure at your Service
The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in nomount mode. rman target / restore primary controlfile from ‘backup_location_directory/control_.bkp’; exit; By specifying “restore primary” , will modify the flag into the controlfile, and will mount a primary role instance instead of a standby one….
Oracle released a new way to search for database features, and it is …
The Italian Oracle User Group (ITOUG) is an independent group of Oracle enthusiasts and experts which work together as volunteers to promote technical knowledge sharing in Italy.
On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain how to recover a corrupted datafile, in order to be able to repair the Standby database, without to be necessary to restore entire database. Initial situation : DGMGRL> connect / Connected to “PROD_SITE2” Connected as SYSDG. DGMGRL> show configuration; Configuration – CONFIG1 Protection Mode: MaxPerformance Members: PROD_SITE2 -…
Oracle 19c, Oracle Cloud in numbers and pre-build environments on vagrant, docker and Oracle Linux Cloud Native environment, those were some of the topics at Open World Europe Conference in London. To see what’s behind with links to detailed sources, please read on.
I needed a special package on my OVM Server 3.4.6. The package is called fio and is needed to do some I/O performance tests. Unfortunately, OVM Server does not provide any package for compiling software and installing additional software to your OVM Server is also not supported. But there is a solution:
Introduction When you work on ODA you sometimes get struggled with local filesystem free space. ODA has terabytes of space on data disks, but local disks are still limited to a raid-1 array of 2x 480GB disks. And only few GB are dedicated to / and /u01 filesystems. You do not need hundreds of GB on these filesystems, but I think that you prefer to keep at least 20-30% of free space. And if you…
What is Oracle Text? Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications. Oracle text activation for a user create user ORATXT identified by oratxt ; grant ctxapp to ORATXT ; grant execute on ctxsys.ctx_cls to ORATXT ; grant execute on ctxsys.ctx_ddl to ORATXT ; grant execute on ctxsys.ctx_doc to ORATXT ; grant execute on ctxsys.ctx_output to ORATXT ; grant execute on ctxsys.ctx_query to…
Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I also have to install 3 Oracle Homes and one Cloud Control Agent 13c. An OMS13c server already exists including an Agent patched with the EM-AGENT Bundle Patch 13.2.0.0.181031 (28680866) : [email protected]:/home/oracle/ [agent13c] opatch lsinventory |…
Today I was onsite at my customer and he told me: I can no longer create databases on my ODA X7-2HA, every time I try to use odacli create-database it fails, please help. Ok, let’s check what happens, the customer shares the Oracle Homes, he wants to create a 11.2.0.4 database: [[email protected] ~]# odacli list-dbhomes ID Name DB Version Home Location Status —————————————- ——————– —————————————- ——————————————— ———- 157bfdf4-4430-4fb1-878e-2fb803ee54bd OraDB11204_home1 11.2.0.4.180417 (27441052, 27338049) /u01/app/oracle/product/11.2.0.4/dbhome_1 Configured 2aaba0e6-4482-4c9f-8d98-4a9d72fdb96e…
