Oracle 11g闪回flashback - 数据库编程

unt--打开数据库到mount状态
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area? 400846848 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2213776 bytes
Variable Size? ? ? ? ? ? 276826224 bytes
Database Buffers? ? ? ? ? 117440512 bytes
Redo Buffers? ? ? ? ? ? ? ? 4366336 bytes
Database mounted.
SQL> alter database noarchivelog--修改为非归档模式
? 2? ;

Database altered.

SQL> alter database open--打开数据库
? 2? ;

------------------------------------前面是修改数据库为非归档模式------------------
Database altered.

SQL> archive log list;--查看是否归档
Database log mode? ? ? ? ? ? ? No Archive Mode
Automatic archival? ? ? ? ? ? Disabled
Archive destination? ? ? ? ? ? /u01/app/oracle/archive/archive02/
Oldest online log sequence? ? 362
Current log sequence? ? ? ? ? 365
SQL> clear
SQL> !clear

SQL> archive log list;
Database log mode? ? ? ? ? ? ? No Archive Mode
Automatic archival? ? ? ? ? ? Disabled
Archive destination? ? ? ? ? ? /u01/app/oracle/archive/archive02/
Oldest online log sequence? ? 362
Current log sequence? ? ? ? ? 365
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode? ? ? ? ? ? ? Archive Mode
Automatic archival? ? ? ? ? ? Enabled
Archive destination? ? ? ? ? ? /u01/app/oracle/archive/archive02/--归档区，默认是在闪回区
Oldest online log sequence? ? 362
Next log sequence to archive? 365
Current log sequence? ? ? ? ? 365
SQL> show parameter db_rec

NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest? ? ? ? ? ? ? ? string? ? ? /u01/app/oracle/flash_recovery
--闪回区配置? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? _area
db_recovery_file_dest_size? ? ? ? ? big integer 3882M
db_recycle_cache_size? ? ? ? ? ? ? ? big integer 0
SQL> show parameter db_flashback_retent

NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target? ? ? ? integer? ? 1440--闪回保留时间默认是24小时，也就是1440分钟
SQL> !ls /u01/app/oracle/flash_recovery_area
jiagulun? JIAGULUN——里面是空的

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

SQL> alter database flashback on;--启动数据库闪回

Database altered.

SQL> !ls /u01/app/oracle/flash_recovery_area
jiagulun? JIAGULUN

[oracle@localhost flashback]$ pwd
/u01/app/oracle/flash_recovery_area/JIAGULUN/flashback
[oracle@localhost JIAGULUN]$ cd flashback/
[oracle@localhost flashback]$ ls
o1_mf_bd97qnhk_.flb? o1_mf_bd987hyb_.flb
SQL> alter database open;

Database altered.

SQL> select to_char(sysdate,'yyyymmdd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'
-----------------
20150124 23:47:01

SQL> select n

Oracle 11g闪回flashback(七)