Oracle 11gR2 归档日志格式/路径修改
Home
> 2016年5月19日发布的文章
- ------------------------------------------------------- Oracle归档日志默认路径为：USR_DB_RECOVERY_FILE_DEST 也就是闪回恢复区($ORACLE_BASE/flash_recovery_area),默认情况下ORACLE对这个路径有限制，且这个路径也是默认备份文件和闪回日志的存储路径，所以尽量去修改一下。 SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVER... 阅读全文 →
Oracle数据库归档模式的查询和开启以及关闭
SQL> startup ORACLE instance started. Total System Global Area 776646656 bytes Fixed Size 2257272 bytes Variable Size 511708808 bytes Database Buffers 255852544 bytes Redo Buffers 6828032 bytes Database mounted. Database opened. SQL> archive log list; -----查询是否归档模式 Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 7 Current log sequence ... 阅读全文 →
Oracle 11gR2 静态监听 listener
[oracle@oracle admin]$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. # the 2 items (DB01/DB02) are static listener info. ADR_BASE_LISTENER_DB01 = /u01/app/oracle ADR_BASE_LISTENER_DB02 = /u01/app/oracle SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB01) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) (SID_NAME =... 阅读全文 →