ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关闭闪回即disable flashback的操作步骤

关闭闪回即disable flashback的操作步骤

原创 Linux操作系统 作者:relis_cheng 时间:2012-05-11 16:29:41 0 删除 编辑
1.现有的环境:
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
SQL> show parameter recovery
NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest       string  /u01/app/oracle/FRA
db_recovery_file_dest_size      big integer 8G
recovery_parallelism       integer  0
SQL> archive log list;
Database log mode        Archive Mode
Automatic archival        Enabled
Archive destination        /u01/app/oracle/bak/arch2
Oldest online log sequence     21
Next log sequence to archive   23
Current log sequence        23
 
2. 改变一下环境
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area  159383552 bytes
Fixed Size      1218268 bytes
Variable Size    117442852 bytes
Database Buffers    37748736 bytes
Redo Buffers      2973696 bytes
Database mounted.
SQL> alter database flashback off;
Database altered.
SQL> alter database open;
Database altered.
 
SQL> show parameter recovery
NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest       string
db_recovery_file_dest_size      big integer 8G
recovery_parallelism       integer  0
SQL> alter system reset db_recovery_file_dest  scope=spfile sid='*';
System altered.
SQL> alter system reset db_recovery_file_dest_size scope=spfile sid='*';
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area  159383552 bytes
Fixed Size      1218268 bytes
Variable Size    117442852 bytes
Database Buffers    37748736 bytes
Redo Buffers      2973696 bytes
Database mounted.
Database opened.
SQL> show parameter recovery
NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest       string
db_recovery_file_dest_size      big integer 0
recovery_parallelism       integer  0
 
 
###这里最关键的是用alter system reset的操作来还原参数的默认值的。
 
 
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/119941/viewspace-723366/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-09-16

  • 博文量
    26
  • 访问量
    53621