Uncategorized
OEM Reports are showing old data for tablespaces
After dropping tablespaces in RAC, the tablespace reports still showed that these tablespaces existed. So the steps I ran were: 1. Run in the OEM repository as sysman the following (to get the host, target name and type): select * from mgmt$db_tablespaces where tablespace_name like ‘%tablespace_I_deleted%’; 2. What came back was the database instance that […]
Check Oracle Version Installed
select to_char(ACTION_TIME,’DD-MON-YYYY’),ACTION,VERSION,ID,BUNDLE_SERIES,COMMENTS from DBA_REGISTRY_HISTORY;
Rename, Recreate or Move REDO Logs
Basic concept behind steps shown below: alter database add logfile. alter database switch logfile. Query v$log, and if it shows ‘notactive’, then: alter database delete logfile. (remove the file at os level). REPEAT.