select db_unique_name, open_mode, log_mode, database_role from v$database; DB_UNIQUE_NAME OPEN_MODE LOG_MODE DATABASE_ROLE ———————— ——————————– ———————————— ———————————————— THEPRDS READ ONLY WITH APPLY ARCHIVELOG PHYSICAL STANDBY
— careful the drop “quieces” (temporarily halts transactions) and only warns you after you start the drop — DROP DBConsole $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop — CREATE DBConsole along with the repository $ORACLE_HOME/bin/emca -config dbcontrol db -repos create
SELECT s.inst_id, s.type, s.sid, s.serial#, p.spid, s.username, s.program FROM gv$session s, gv$process p where p.addr = s.paddr and p.inst_id = s.inst_id and s.type != ‘BACKGROUND’; — once you have the v$process.spid – you have the OS PID so – a command like this from the OS command line can also shed more light ps -ef …
Show Unix PID ( v$process.spid ) of an Oracle process Read More »
Ok, what is Oracle automatically controlling in your FRA – here is how to look at it. Note: if you put format commands in your rman backups – even if you write them to the FRA – Oracle will not likely see them as part of the FRA – yes the backups will be recognized …
Oracle Flash Recovery Area Manipulate and Report Read More »