ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 启用oracle10g Flashback闪回功能

启用oracle10g Flashback闪回功能

原创 Linux操作系统 作者:liu_qingwei2008 时间:2011-05-18 10:09:22 0 删除 编辑

[oracle@ocmdb1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 18 08:46:00 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
 
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
NO

SQL> show parameter db_recover;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0

SQL> show parameter db_flashback;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     1440
 
SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' scope=both;
alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01261: Parameter db_recovery_file_dest destination string cannot be
translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory

SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' scope=spfile;
System altered.

SQL> alter system set db_recovery_file_dest_size=1g scope=both;
System altered.

SQL> alter system set db_flashback_retention_target=2880 scope=both;
System altered.
 
SQL> show parameter db_recovery;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 1G

SQL> show parameter db_flash
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     2880

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory
 
SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
 

SQL> !

[oracle@ocmdb1 ~]$ cd /u01/app/oracle
[oracle@ocmdb1 oracle]$ ls -rtl
total 40
drwxr-xr-x  3 oracle oinstall 4096 May 15 11:29 product
drwxrwx---  6 oracle oinstall 4096 May 15 20:36 oraInventory
drwxr-xr-x  3 oracle oinstall 4096 May 18 07:59 admin
drwxr-xr-x  3 oracle oinstall 4096 May 18 08:00 oradata
drwxr-xr-x  2 oracle oinstall 4096 May 18 08:42 rmanbak
 
[oracle@ocmdb1 oracle]$ mkdir flash_recovery_area
[oracle@ocmdb1 oracle]$ ls -rtl
total 48
drwxr-xr-x  3 oracle oinstall 4096 May 15 11:29 product
drwxrwx---  6 oracle oinstall 4096 May 15 20:36 oraInventory
drwxr-xr-x  3 oracle oinstall 4096 May 18 07:59 admin
drwxr-xr-x  3 oracle oinstall 4096 May 18 08:00 oradata
drwxr-xr-x  2 oracle oinstall 4096 May 18 08:42 rmanbak
drwxr-xr-x  2 oracle oinstall 4096 May 18 08:58 flash_recovery_area

SQL> startup mount;
ORACLE instance started.
Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             100664720 bytes
Database Buffers          209715200 bytes
Redo Buffers                2973696 bytes
Database mounted.
 
 
SQL> alter database flashback on;
Database altered.

 
SQL> alter database open;
Database altered.

SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
 
SQL> show parameter db_recovery;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/flash_recovery
                                                 _area
db_recovery_file_dest_size           big integer 1G
 
SQL> show parameter db_flash;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     2880

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

请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    86408