【Oracle】日常运维手册（上）

查看数据库版本

SELECT * FROM V$VERSION;

查看数据库语言环境

SELECT USERENV('LANGUAGE') FROM DUAL;

**查看ORACLE实例状态 **

SELECT INSTANCE_NAME,HOST_NAME,STARTUP_TIME,STATUS,DATABASE_STATUS
FROM V$INSTANCE;

查看ORACLE监听状态

lsnrctl status

查看数据库归档模式

SELECT NAME,LOG_MODE,OPEN_MODE FROM V$DATABASE;

查看回收站中对象

SELECT OBJECT_NAME,ORIGINAL_NAME,TYPE FROM RECYCLEBIN;

清空回收站中对象

PURGE RECYCLEBIN;

还原回收站中的对象

FLASHBACK TABLE "BIN$GOZUQZ6GS222JZDCCTFLHQ==$0" TO BEFORE DROP RENAME TO TEST;

闪回误删除的表

FLASHBACK TABLE AAA TO BEFORE DROP;

闪回表中记录到某一时间点

ALTER TABLE TEST ENABLE ROW MOVEMENT;

FLASHBACK TABLE TEST TO TIMESTAMP
21:17:47','YYYY-MM-DD HH24:MI:SS');