Oracle 23c New Features for DBA'sAs we all know Active Dataguard is a licensed feature and whilst there is no parameter to control, indeed if just in case if you do not have a license and by chance your DBA has opened the standby database in readonly and started MRP then you are in troubles as it activates the Active […]
|
||||
|
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 […] 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 […] Quick Question: Is it possible to have Standby Database on different platforms? i.e Windows (Primary) –> Linux (Standby) Answer: Yes, From 11gr2 onwards. You can have different Operating Systems on primary and standby. Note: From 10g onwards, Different endian support i.e Linux 64bit(Primary) –> Linux 32bit (Standby) is possible but not different platforms. How […] As discussed, earlier, Another important nice feature in RMAN from 12c is using network based recovery or incremental backup strategy from the servics. This eliminates taking incremental backups or copy those backup to standby and saves lot of time. Lets check, On Primary, check the latest log Check on Primary SQL> archive log […] Step by Step standby creation using RMAN duplicate database This post is about to create a standby database in container enabled database (Just want to check any changes required from previous versions steps) All steps are similar like previous versions except we have to create directory structures for PDB databases otherwise RMAN script will fail […] Here is the step by step document for recovering the standby if archive is missing and not recoverable, using a feature called rollforward standby using incremental backup introduced in 10g. 1) After recovery in step above login to sqlplus and get the current scn from standby database; SQL> col CURRENT_SCN format 999999999999 SQL> select current_scn […] Yes, you heard it correct. The question is, Is it possibel to have the standby is in higher version than the production database of course with same OS, for example Production in 10g and the standby in 11g on both sides having RHEL? Answer: Yes, the standby should logical and the compatibility parameters on […] |
||||
Follow Me!!!