在线咨询
阅读：32
查看日志目录
show parameter dump;
副服务器日志路径
tail -f /data/oracle/diag/rdbms/standby/orcl/trace/alert_orcl.log
数据库帐号密码
oracle
oracle123
查看日志目录
show parameter dump;
副服务器日志路径
tail -f /data/oracle/diag/rdbms/standby/orcl/trace/alert_orcl.log
show parameter archive_dest_2;
2：在备库查看归档路径
archive log list;
3把所有归档日志 复制到 副机目录
4 注册每个日志文件
alter database register logfile '/data/oracle/flash_recovery_area/arch1_117_1198521494.arc';
注册数据库
alter system register;
/etc/hostname
/etc/hosts
chown -R oracle:oinstall /apps/oracle
日志目录
/data/oracle/diag/rdbms/standby/orcl/trace/alert_orcl.log
主
tail -f /data/oracle/diag/rdbms/cdlp/cdlp/trace/alert_cdlp.log
CREATE SPFILE from PFILE='/data/oracle/admin/cdlp/pfile';
开启备份
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
关闭
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
实例名
orcl
数据库ming
CDLP
sqlplus -s system/ora1234@primary
启动oracle监听
lsnrctl start
lsnrctl stop
lsnrctl status;
lsnrctl reload;
查询错误日志
select status,error from v$archive_dest;
chown -R oracle:oinstall /apps/oracle
chmod 775 /apps/oracle
开启数据库
ALTER DATABASE OPEN;
进入sql
sqlplus / as sysdba
创建用户
CREATE USER cdby IDENTIFIED BY cdby123;
GRANT CONNECT, RESOURCE TO cdby;
GRANT CREATE SESSION TO cdby;
查询数据库
SELECT name FROM v$database;
查看 oracle 实例名
SELECT INSTANCE_NAME FROM V$INSTANCE;
连接数据库
connect cdlp/cdlp123
关闭数据库
SHUTDOWN IMMEDIATE;
//不经常使用 尽量少用
shutdown abort;
STARTUP MOUNT;
主机日志
tail -f /data/oracle/diag/rdbms/primary/orcl/trace/alert_orcl.log
root abc@1234
sqlplus system/oracle123@//192.168.1.90:1521/orcl as sysdba
//回复数据
recover datafile '/data/oracle/oradata/cdlp/system01.dbf' ;
show parameter spfile;
错误：ORA-32001:write to spfile requested but no spfile is in use请
那么就创建spfile
create spfile from pfile;
alter system set control_files='/data/oracle/oradata/cdlp/control01.ctl','/data/oracle/oradata/cdlp/control01.ct2' scope=spfile;
alter system set control_files='/data/oracle/oradata/cdlp/control01.ctl' scope=spfile;
alter system set control_files='/data/oracle/bak2.ctl' scope=spfile;
alter database backup controlfile to trace as '/data/oracle/oradata/control01_bak.ctl';
alter database backup controlfile to '/data/oracle/control.bak';
系统用户
sys/system/sysman/dbsnmp
测试
cdlp ora1234
启动数据库
STARTUP pfile='/data/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
STARTUP MOUNT pfile='/data/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
startup nomount pfile='/data/oracle/product/11.2.0/db_1/dbs/spfilecdlp.ora';
STARTUP NOMOUNT pfile='/data/oracle/product/11.2.0/db_1/dbs/spfilecdlp.ora';
startup pfile='/data/oracle/pfile.ora';
startup MOUNT pfile='/data/oracle/pfile.ora';
STARTUP NOMOUNT pfile='/data/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
//创建启动文件 并复制到次服务器
alter database create standby controlfile as '/data/oracle/oradata/cdlp/control03.ctl'
alter database create standby controlfile as '/data/oracle/bak2.ctl';
次服务器指定启动文件
alter system set control_files='/data/oracle/bak.ctl' scope=spfile;
启用同步服务
alter database recover managed standby database using current logfile disconnect from session;
ALTER DATABASE MOUNT pfile='/data/oracle/product/11.2.0/db_1/dbs/spfilecdlp.ora';
设置游标数量
alter system set open_cursors=3000 scope=both;
设置连接数
alter system set processes =500 scope =spfile;
启动出错
cp /data/oracle/product/11.2.0/db_1/dbs/spfilecdlp.ora /data/oracle/product/11.2.0/db_1/dbs/initorcl.ora
恢复数据
ALTER DATABASE OPEN RESETLOGS;
查看字符集
SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
日志目录
/data/oracle/diag/rdbms/cdlp/orcl/trace
查看ORACLE最大游标数：
SQL> show parameter open_cursors;
查看当前打开的游标数目：
SQL> select count(*) from v$open_cursor;
设置数据库最大游标数量：
SQL>alter system set open_cursors=3000 scope=both;
groupadd oinstall # 创建oinstall组
groupadd dba # 创建dba组
useradd -g oinstall -G dba oracle # 创建oracle用户并将其加入到两个组中
passwd oracle # 设置oracle用户的密码
安装数据库
./runInstaller
文件配置 db_install.rsp
创建密码文件
/data/oracle/product/11.2.0/db_1/bin/orapwd file=/data/oracle/product/11.2.0/db_1/dbs/orapworcl password=ora1234 entries=10 force=y
日志目录
tail -f /data/oracle/diag/rdbms/standby/orcl/trace/alert_orcl.log
tail -f /data/oracle/diag/rdbms/cdlp/cdlp/trace/alert_cdlp.log
show parameter archive_dest_2
alter system set log_archive_dest_2 = 'SERVICE=standby ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby';
删除没用 GROUP
ALTER DATABASE DROP LOGFILE GROUP 20;
alter database drop standby logfile group 20 ;
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SELECT dest_id, recovery_mode FROM v$archive_dest_status;
alter database create standby controlfile as '/data/oracle/bak2.ctl';
