Monthly Archives: June 2010

Automating Client Failover in a Data Guard Configuration

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 … Continue reading

| Tagged , | Leave a comment

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 … Continue reading

| Tagged | Leave a comment

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 … Continue reading

| Tagged , , | 2 Comments