plsql查看oracle归档日志,使用logminer分析归档日志案例

原因：

由于某生产系统db_sc用户模式下t_sc表数据丢失，需要分析丢失的原因，下面是整个恢复步骤！

过程：

1、必须运行以下脚本，建立相应的包和表

SQL> @$ORACLE_HOME/rdbms/admin/dbmslm.sql

Package created.

Grant succeeded.

Synonym created.

SQL> @$ORACLE_HOME/rdbms/admin/dbmslmd.sql

Package created.

Synonym created.

SQL> @$ORACLE_HOME/rdbms/admin/dbmslms.sql

Package created.

No errors.

Grant succeeded.

2、指出数据字典存放的位置(先建好目录)，并重启数据库

SQL> alter system set utl_file_dir='/tmp/hfsc' scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  701485056 bytes

Fixed Size                  2216664 b