[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
------------------
NO
SQL> show parameter db_recover;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer 0
------------------------------------ ----------- ------------------------------
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
------------------------------------ ----------- ------------------------------
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
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
------------------------------------ ----------- ------------------------------
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
------------------------------------ ----------- ------------------------------
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
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
[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.
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
------------------
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
------------------------------------ ----------- ------------------------------
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
------------------------------------ ----------- ------------------------------
db_flashback_retention_target integer 2880
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23898243/viewspace-695641/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23898243/viewspace-695641/