You've got to have a dream. When you lose your dreams, you die.
2010-03-31
Connection lost contact between Primary and Standby
ORA - 03135 : connection lost contact while shipping from Primary Server to Standby server [ID 739522.1]
2010-03-25
See procedure/packege code in PL/SQL Developer
In PL/SQL Developer : "Source of ... is not available"
Solution : If you've PL/SQL developer, check tools>preferences>options>use DBA views if available.
Solution : If you've PL/SQL developer, check tools>preferences>options>use DBA views if available.
2010-03-23
Recover dropped oracle procedure
--- recover the dropped/changed procedure PROCEDURE_SALES
select text from dba_source as of timestamp systimestamp - interval '15' minute where name='PROCEDURE_SALES' and type = 'PACKAGE BODY' order by line asc;
Slow Oracle Net Connections
From note [ID 1076022.1] : Troubleshooting Slow Oracle Net Connections
Solutions here included purge of the old audit files, disabling auditing, etc
Solutions here included purge of the old audit files, disabling auditing, etc
2010-03-22
URSS
A Russian tourist arrives at London's Heathrow airport.
As he fills out the entry form, the immigration officer asks him:
-Occupation?
The Russian promptly replies:
-No, no, just visiting!
As he fills out the entry form, the immigration officer asks him:
-Occupation?
The Russian promptly replies:
-No, no, just visiting!
The perfect rman script backup
The perfect rman script backup:
run
{
allocate channel t1 type disk;
BACKUP AS COMPRESSED BACKUPSET check logical INCREMENTAL LEVEL 0 DATABASE filesperset 1 plus archivelog format '/mnt/u05/backuptest/backup_%d_set%s_piece%p_copy%c_%T_%U' TAG = DB_BACK_FULL_DAILY ;
backup current controlfile format '/mnt/u05/backuptest/backup_controlfile_%d_DBID%I_%T_%U.ctl' TAG=CTL_BACK_FULL_DAILY;
backup spfile format '/mnt/u05/backuptest/backup_parameter_%d_DBID%I_%T_%U.ctl' TAG=PARAM_BACK_FULL_DAILY ;
delete obsolete;
release channel t1;
}
run
{
allocate channel t1 type disk;
BACKUP AS COMPRESSED BACKUPSET check logical INCREMENTAL LEVEL 0 DATABASE filesperset 1 plus archivelog format '/mnt/u05/backuptest/backup_%d_set%s_piece%p_copy%c_%T_%U' TAG = DB_BACK_FULL_DAILY ;
backup current controlfile format '/mnt/u05/backuptest/backup_controlfile_%d_DBID%I_%T_%U.ctl' TAG=CTL_BACK_FULL_DAILY;
backup spfile format '/mnt/u05/backuptest/backup_parameter_%d_DBID%I_%T_%U.ctl' TAG=PARAM_BACK_FULL_DAILY ;
delete obsolete;
release channel t1;
}
2010-03-11
2010-03-09
banc DE
Un african, tocmai recunoscut ca azilant, se plimba mândru pe strazile noului sau oras.
El se adreseaza primului întâlnit, spunându-i: "Multumesc draga germanule, va multumesc ca m-ati primit în tara voastra minunata, ca mi-ati oferit ajutor, adapost si asigurare medicala.
2010-03-05
How to fix Nologging Changes
Rolling a Standby Forward using an RMAN Incremental Backup To Fix The Nologging Changes [ID 958181.1]
2010-03-04
Daca nu iti pasa de nimic vei trai mai mult
Paradoxul anti-agging : http://www.cristianmargarit.ro/2010/03/sanatate/paradoxul-anti-aging
Stresul: inamicul public numarul 1 : http://www.itex.ro/blog/consultanta-gratuita/inamicul-public-numarul-1-stresul/
Stresul: inamicul public numarul 1 : http://www.itex.ro/blog/consultanta-gratuita/inamicul-public-numarul-1-stresul/