Transparent Application Failover (TAF) is a client-side feature that allows for clients to reconnect to surviving nodes in the event…
To use real-time apply where before log shipping the LGWR process writes to a standbylog file simultaneously along with the…
I had installed Oracle Database 11g on Solaris 10 few days back. I thought of documenting the steps for easy…
select x.inst_id,x.indx+1,ksppinm,ksppity,ksppstvl,ksppstdf, decode(bitand(ksppiflg/256,1),1,’TRUE’,’FALSE’), decode(bitand(ksppiflg/65536,3),1,’IMMEDIATE’,2,’DEFERRED’,3,’IMMEDIATE’,’FALSE’), decode(bitand(ksppstvf,7),1,’MODIFIED’,4,’SYSTEM_MOD’,’FALSE’), decode(bitand(ksppstvf,2),2,’TRUE’,’FALSE’), ksppdesc from x$ksppi x, x$ksppcv y where (x.indx = y.indx) /*and (translate(ksppinm,’_’,’#’) not like…
A physical standby database is created from an existing other database. This other database will then be the primary database.…
Automatic Storage Management (ASM) in Oracle Database 10g Automatic Storage Management (ASM) is a new feature was introduced in Oracle…
ORA-19905: log_archive_format must contain %s, %t and %r During a go-live when a 10.2.0.4 database was being readied for a…
Here are some scripts related to Tables/Indexes . Tabs w/ Questionable Inds TABLES WITH QUESTIONABLE INDEX(ES) NOTES: Owner – Owner…
The following is a basic steps for an automatic start up and shutdown Oracle instances during UNIX system startup or…