官方文檔有句話: STANDBY_ARCHIVE_DEST is relevant only for a standby database in managed recovery mode. It specifies the location of archive logs arriving from a primary database 這句話指出了 Standby_archive_dest 的作用
The Grid Control framework includes: ● Oracle Management Repository (OMR) ● One or more Oracle Management Service (OMS) ● One or more Oracle Management Agent (OMA) GC 不僅可以管理任何主流的 Oracle 產品、而且還能偵測自訂(比如:路由器)的目標 OMAs
You can set the default session time zone with the ORA_SDTZ environment variable. When users retrieve TIMESTAMP WITH LOCAL TIME ZONE data, Oracle returns it in the users' session time zone. The session time zone also takes effect when
① 法一[root@Rocky ~]# cat /etc/login.defs # Password aging controls:## PASS_MAX_DAYS Maximum number of days a password may be used.# PASS_MIN_DAYS Minimum number of days allowed between password changes.# PASS_MIN_LEN
在恢複控制檔案之前,必須知道目標資料庫的DBID。身為DBA的你,在接手資料庫時,定要把資料庫的DBID給備份出來! 1)備份控制檔案RMAN> list backup of controlfile; 2)測試資料hr@ORCL> create table t (name varchar2(20));Table created.hr@ORCL> insert into t values('think');1 row created.hr@ORCL>