Monday 28 June 2010

Mysql : Reset root password

service mysql stop
mysqld_safe --skip-grant-tables &
mysql -uroot mysql
UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;
mysql -uroot -pabcd mysql

Windows : Remove IE advanced security

* This is done by uninstalling the windows component Control Panel->Add or Remove Programs->Add/Remove Windows Components->Stuff

Monday 14 June 2010

RMAN : Simple restore of archive log to default location


$ORACLE_HOME/bin/rman nocatalog
connect target dba_cron/password

run {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
restore archivelog sequence 214629;
restore archivelog sequence 214630;
}