Administrator user xp

To show
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\SpecialAccounts\UserList
dword Administrator 1

Flashback

Flashback

Default locations (spfile&alert.log)

spfile

$ORACLE_HOME/dbs
%ORACLE_HOME%\database

spfileSID.ora
spfile.ora
initSID.ora

alert log

%ORACLE_HOME%\rdbms\trace\alert_sid.log
or

%ORACLE_HOME%\rdbms\log\alert_sid.log

Recovery 9i

http://download.oracle.com/docs/cd/B10500_01/server.920/a96566/rcmrecov.htm#1006485

lob performance

http://www.ixora.com.au/tips/event_10359.htm
http://download.oracle.com/docs/cd/A91202_01/901_doc/appdev.901/a88879/adl09be3.htm#121892

lob nologging

alter table test_lob modify lob (sql_text) (nocache nologging);

Lost of system datafile

Instance crashes with error: ORA-01243: system tablespace file suffered media failure

Restore to different location:
rman
startup mount;
run
{
set newname for datafile 'f:\test_system.dbf' to 'c:\project\orcl\test_system.dbf';
restore datafile 11;
switch datafile 11;
recover datafile 11;
}