We target is preventing clients from connectingto the wrong Database when failover occurs.we use database services to prevent clients from connecting to the wrong database in the Data Guard configurationwe can arrange client tnsnames.ora so Clients connect to database services instead of database instancesDatabase services register with listenerswe creating services for the data guard configuration … Continue reading Automating Client Failover in a Data Guard Configuration
Month: June 2010
Recover OCR Using Physical Backups
The OCR content is critical to Oracle Clusterware.OCR is automatically backed up physically:Every four hours: CRS keeps the last three copies.At the end of every day: CRS keeps the last two copies.At the end of every week: CRS keeps the last two copies$ cd $ORACLE_BASE/Crs/cdata/test$ ls -ltcheck Ocr automatic backup locationocrconfig -showbackupstop oracleclusterware on all … Continue reading Recover OCR Using Physical Backups
Oracle reserved Words (oracle tarafından ayrılmış kelimeler)
IT SELECT ALL EXISTS NOCOMPRESS SESSIONALTER FILE NOT SETAND FLOAT NOTFOUND SHAREANY FOR NOWAIT SIZEARRAYLEN FROM NULL SMALLINTAS GRANT NUMBER SQLBUFASC GROUP OF SUCCESSFULAUDIT HAVING OFFLINE SYNONYMBETWEEN IDENTIFIED ON SYSDATEBY IMMEDIATE ONLINE TABLECHAR IN OPTION THENCHECK INCREMENT OR TOCLUSTER INDEX ORDER TRIGGERCOLUMN INITIAL PCTFREE UIDCOMMENT INSERT PRIOR UNIONCOMPRESS INTEGER PRIVILEGES UNIQUECONNECT INTERSECT PUBLIC UPDATECREATE INTO … Continue reading Oracle reserved Words (oracle tarafından ayrılmış kelimeler)