最近2018中文字幕在日韩欧美国产成人片_国产日韩精品一区二区在线_在线观看成年美女黄网色视频_国产精品一区三区五区_国产精彩刺激乱对白_看黄色黄大色黄片免费_人人超碰自拍cao_国产高清av在线_亚洲精品电影av_日韩美女尤物视频网站

一、步驟
1.關(guān)閉節(jié)點(diǎn)二
2.配置相關(guān)參數(shù)
3.關(guān)閉節(jié)點(diǎn)1
4.啟用閃回
5.打開節(jié)點(diǎn)二

創(chuàng)新互聯(lián)是一家專業(yè)的成都網(wǎng)站建設(shè)公司，我們專注網(wǎng)站建設(shè)、成都網(wǎng)站設(shè)計(jì)、網(wǎng)絡(luò)營(yíng)銷、企業(yè)網(wǎng)站建設(shè)，買友情鏈接，1元廣告為企業(yè)客戶提供一站式建站解決方案，能帶給客戶新的互聯(lián)網(wǎng)理念。從網(wǎng)站結(jié)構(gòu)的規(guī)劃UI設(shè)計(jì)到用戶體驗(yàn)提高，創(chuàng)新互聯(lián)力求做到盡善盡美。

二、操作過程

[root@rac01 ~]# su - oracle
Last login: Thu Jan  4 10:33:31 CST 2018 on pts/2
$sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 5 18:52:55 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SYS@orcl1> 
SYS@orcl1> 
SYS@orcl1> 
SYS@orcl1> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
recovery_parallelism                 integer     0
SYS@orcl1> show parameter flashback

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     1440
SYS@orcl1> alter system set db_recovery_file_dest_size=1g;

System altered.

SYS@orcl1> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATADG
Oldest online log sequence     121
Next log sequence to archive   122
Current log sequence           122
SYS@orcl1> alter system set db_recovery_file_dest='+datadg';

System altered.

SYS@orcl1> alter system set db_flashback_retention_target=2880;

System altered.

SYS@orcl1> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl1> startup mount;
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  2923872 bytes
Variable Size             620757664 bytes
Database Buffers          603979776 bytes
Redo Buffers               13852672 bytes
Database mounted.
SYS@orcl1> alter database flashback on;

Database altered.

SYS@orcl1> alter database open;

Database altered.

SYS@orcl1> select flashback_on from v$database;

FLASHBACK_ON
------------------
YES

SYS@orcl1> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +datadg
db_recovery_file_dest_size           big integer 1G
recovery_parallelism                 integer     0
SYS@orcl1> show parameter flashback

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     2880
SYS@orcl1> 

小結(jié)：
生產(chǎn)環(huán)境ADG備庫開閃回解決邏輯錯(cuò)誤。未來再添加一個(gè)備庫，做災(zāi)備，一主兩備哈

當(dāng)前標(biāo)題：12crac開閃回
URL網(wǎng)址：http://fisionsoft.com.cn/article/gcdcog.html