2
DG
1
DG
host_name ip oracle_sid
active 192.168.162.22 prod1
standby 192.168.162.33 test1
DB_NAME DB_UNIQUE_NAME GLOBAL_DBNAME SERVICE_NAME SID_NAME
prod1 prod1 prod1 prod1 prod1
prod1 test1 test1 test1 test1
SERVICE_NAME tnsnames.ora
GLOBAL_DBNAME listener.ora
GLOBAL_DBNAME
GLOBAL_DBNAME SERVICE_NAME
SID Oracle GLOBAL_DBNAME SID_NAME
[oracle@active:/home/oracle]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
if [ -t 0 ]; then
stty intr ^C
fi
DG
2
PS1="[`whoami`@`hostname`:"'$PWD]$ '
export PS1
export ORACLE_SID=prod1
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=/u02/app/oracle/product/19.0.0/db_1
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORACLE
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/r
export LANG=C
umask 022
mkdir -p /u02/arch
alter system set log_archive_dest_1='location=/u02/arch';
System altered.
show parameter log_archive_dest_1;
NAME TYPE VALUE
------------------------------------ ----------- -----------------
log_archive_dest_1 string location=/u02/arc
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
DG
3
startup mount;
ORACLE instance started.
Total System Global Area 1593831928 bytes
Fixed Size 8897016 bytes
Variable Size 1241513984 bytes
Database Buffers 335544320 bytes
Redo Buffers 7876608 bytes
Database mounted.
alter database archivelog;
Database altered.
alter database open;
Database altered.
archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/arch
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
FORCE LOGGING
select log_mode,force_logging from v$database;
LOG_MODE FORCE_LOGGING
------------ ---------------------------------------
ARCHIVELOG NO
ALTER DATABASE FORCE LOGGING;
Database altered.
select log_mode,force_logging from v$database;
LOG_MODE FORCE_LOGGING
of 20
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
1
2
9-数据库人的进阶之路：从PG分区、SQL优化到拥抱AI未来（罗敏）.pptx
3
1-PG版本兼容性案例（彭冲）.pptx
4
2-TDSQL PG在复杂查询场景中的挑战与实践-opensource.pdf
5
6-PostgreSQL 哈希索引原理浅析（文一）.pdf
6
3-AI时代的变革者-面向机器的接口语言(MOQL)_吕海波.pptx
7
8-基于PG向量和RAG技术的开源知识库问答系统MaxKB.pptx
8
4-IvorySQL V4：双解析器架构下的兼容性创新实践.pptx
9
7-拉起PG好伙伴DifySupaOdoo.pdf
10
《云原生安全攻防启示录》李帅臻.pdf
相关文档
评论