oracle指令收集.xlsVIP

Sheet1 配置OEM参数 emca -config dbcontrol db 给用户hr解锁 alter user hr account unlock 更改密码为hr alter user hr identified by hr 启动oem emctl start dbconsole 查看archive状态 archive log list 用户授权 grant connect,resource,dba to business select log_mode from v$database 备注 更改归档日志名称格式 alter system set log_archive_format=%s_%t_%r.log scope=spfile DOC DOC s:日志序列号t:重做线程编号r:RESETLOGS的ID值 更改多路复用归档路径 alter system set log_archive_dest_2=location=F:\flash_recovery_area\ORCL\ARCHIVELOG1 该目录预先必须建立好 更改归档强度 alter system set log_archive_dest_2=location=F:\flash_recovery_area\ORCL\ARCHIVELOG1 mandatory open optional可选归档mandatory强制归档(reopen重新归档时间间隔参数) 功能 指令例子2（更多） 使用环境 禁用归档位置 alter system set log_archive_dest_state_2=defer 如果导致小于最小必须归档数则该指令报错 启用归档位置 alter system set log_archive_dest_state_2=enable 设置本地最小归档成功数 alter system set log_archive_min_succeed_dest=2 查询归档日志详细信息 select name from v$archived_log 当前可用归档目录数不足则报错 显示归档日志位置 select dest_name,destination,status from v$archive_dest 显示日志历史信息 select * from v$loghist 显示归档进程信息 select * from v$archive_processes active活动stopped未启动 查询数据文件和控制文件 select name from v$datafile union select name from v$controlfile open 备份时清楚备份文件位置 冷备份 host copy F:\oradata\orcl\control01.ctl F:\backup closed 冷备份保证数据一致性，但数据库需要暂时关闭 热备份 host copy F:\.. F:\backup alter database begin backup/alter database end backup/alter system archive log current 热备份后确保同步性还需归档当前日志组 host copy F:\.. F:\backup/alter database backup controlfile to F:\backup 脱机备份表空间 select file_name from dba_data_files where tablespace_name=USERS/alter tablespace USERS offline open 表空间联机online 联机备份表空间 alter tablespace users begin backup host copy 记得alter tablespace users end backup 处理联机备份失败 startup force mount/select file# from v$backup where status=ACTIVE/recover datafile n/alter database open 指令例子1(部分包含多步操作) 备份只读表空间 alter tablespace USERS read only/select tablespace_name from dba_tablespaces where status=READ ONLY/select file_name from dba_data_files where tablespace_name=USERS host copy 记得alter tablespace users read write 复用