Moving database files
Move control files Find current location Currently used control files can be found in view v$controlfile. To check, execute following...
Category: Administration
Object compilation
Check for uncompiled or wrongly compiled objects Execute this SQL command: COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status...
Add new redolog group
Check for existing redolog groups On UNIX filesystem redologs are stored in folder /oracle/<SID>/origlog<X> and mirrored in folder /oracle/<SID>/mirrlog<X> You...