|
||||
|
Hello, I have been reading in other blog citing that what if lost of a data file scenario. Here are the questions. 1) if in case of system/user datafile lost of Pluggable database, what happens to CDB? ANS: Nothing happens to CDB, it will still running, similar case in non-cdb database if a user data […] Hello All, Here are the steps to implement the Standby in RAC and the following is the test environment Production RAC: Geek DBA12cprmy1 Geek DBA12cprmy2 Standby RAC:- Geek DBA12cdr1 Geek DBA12cdr2 1 . Add standby logs on Primary Database alter database add standby logfile thread 1 group 10 (‘+PRMY_DATA’) size 500M; alter database add […] Whilst, was working on a dataguard network performance issue thought should write something on this. The most important aspect of the dataguard is network transport, and if the undersized or improper configuration may lead to the redo transport issue and production may show you the log synch waits etc. The following parameters may be tuned […] Hello All, Long time !!! Its been very busy schedule and could not spend much on the blog at all. Anyways back now, and here this time with gpnp profile. Issue is , the node 2 not starting due to gpnp profile missing/mismatch. Following in the crs alert log in node 2 […] Again, OEL 7 (UEK) and 12c Grid Infrastructure issue. OEL UEK 7 does not shipped or support ACFS yet, but we tried and stumbled :(. Here is the log for root.sh failure. ACFS-9317: No ADVM/ACFS distribution media detected at location: ‘/u02/app/11.2.0.2/grid1/install/usm/EL5/x86_64/2.6.18-8/2.6.18-8.el5-x86_64/bin’ root@ol5-112-rac1 ~]# /u02/app/11.2.0.2/grid1/bin/acfsroot install ACFS-9320: Missing file: ‘advmutil’. ACFS-9320: Missing file: ‘advmutil.bin’. ACFS-9320: Missing […] While running dbca we are receiving the ora-12547 and we could not able to create database using DBCA anymore. After googling and metalink search found many notes which does not resolve the issue, the reasons can be multifold Environments- SID, PATH, LD_LIBRARY_PATH – Not resolved Permission on oracle executable to 6751 – Not resolved Package […] Well, this is fairly an old topic but explored lately by me. Very big post click on read more to scroll down to full page. Ah, I was trying to explore the upgrade from 11gr2 to 12c but not traditional way, and go these two excellent white papers. http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-transientlogicalrollingu-1-131927.pdf http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-upgrades-made-easy-131972.pdf The high level overview of […] In the Previous post we have converted the orcl database to server pool OLTP_SP which is running on three nodes rac01,rac03,rac04 and free server is available in rac02. Okay lets have some discussion before proceeding, 1. Does in pre 11g version , if a instance crashed does it failed over to any node? No. […] From 11g onwards, the database can be managed in two modes, Administer managed, i.e instance allocation/deletion service allocation/deletion and evictions will be managed by Administrator. Where in from the 11gr2 onwards the instance allocation to hosts will be based on the cardinality and services running is also based on their configuration with in the serverpools. […] Hello All, If you have not read server pool concept so far please read it from here. In this post we were going to see, 1. create the server pools OLTP_SP with 2 nodes minimum and maximum 2 nodes with importance 4 2. That leaves 2 node in free pool out of my 4 […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!