> SELECT v$logfile.member, v$logfile.group#, v$log.status,v$log.
ARCHIVED, v$log.bytes/1024/1024 ,v$log.thread#
从RAC恢复到单实例数据库操作步骤(三)
2 FROM v$log, v$logfile
3 WHERE v$log.group# = v$logfile.group#
4 ORDER BY v$log.thread#,v$logfile.group#;
MEMBER GROUP# STATUS ARC V$LOG.BYTES/1024/1024 THREAD#
-------------------------------------------------- ---------- ---------------- --- --------------------- ----------
/u01/app/oradata/csora/redo1a 1 CURRENT NO 50 1
/u01/app/oradata/csora/redo1b 1 CURRENT NO 50 1
/u01/app/oradata/csora/redo2a 2 UNUSED YES 50 1
/u01/app/oradata/csora/redo2b 2 UNUSED YES 50 1
4 rows selected.
17、删除多余的UNDO表空间
SQL> select name from v$tablespace where name like 'UNDO%';
NAME
------------------------------
UNDOTBS1
UNDOTBS2
SQL> drop tablespace undotbs2 including contents and datafiles;
Tablespace dropped.