Rman备份中常见的问题
来源:互联网 发布:华泰证券软件下载 编辑:程序博客网 时间:2024/06/10 00:07
1:ORA-01031insufficient privileges
gpasswd -d oracle dba --将oracle移除出dba组
查看oracle属性
uid=500(oracle) gid=500(oinstall) groups=500(oinstall)
[oracle@oracle10g ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 21 14:07:11 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
解决:
usermod -d /home/oracle/ -G dba oracle --将oracle用户加入dba组
[root@oracle10g ~]# usermod -d /home/oracle/ -G dba oracle
[root@oracle10g ~]# su - oracle
[oracle@oracle10g ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 21 14:08:34 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PURPLE (DBID=2860377939)
2:Handling Disk Space Issues
ORA-19504: failed to create file "/oraback/BRDSTN/bsi2phe7_1_1"
ORA-27004: unable to write the header block of file
解决:
• Change the backup location to an area that has more space.
•Add disk space to the backup location.
•If using a flash recovery area (FRA), then either move the FRA or increase its size.
• Change the retention policy to fewer days or fewer backups.
•Delete old backup files that are no longer required
alter system set db_recovery_file_dest='/oraback02/FRA';
alter system set db_recovery_file_dest_size=100g;
3:RMAN-06059 Error
RMAN> backup database plus archivelog;
Starting backup at 21-JAN-13
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 01/21/2013 14:14:52
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /oracle/archivelog/1_1_805026198.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
解决:
RMAN> crosscheck archivelog all;
4:Terminating RMAN Processes
•Pre ss Ctrl+C from the RMAN interface. This approach, of course, works only if per-formed from the online session responsible for the process you want to terminate.
•Manually kill the OS process.
kill -9 4123
•Terminate the server session corresponding to an RMAN channel using an alter system kill SQL statement
SQL>SELECT s.sid ,s.serial# ,p.spid ,s.client_info FROM v$process p, v$session s WHERE p.addr = s.paddr AND client_info LIKE '%rman%';
SQL>alter system kill session '158,122';
5:Diagnosing NLS Character Set Issues
ORA-12705: Cannot access NLS data files or invalid environment specified
• There’s a mismatch between the NLS character set of the client and that of the database server.
•You have an NLS-related operating system variable that has been set incorrectly.
SQL> conn /as sysdba
Connected.
SQL> select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET';
VALUE
----------------------------------------------------------------
ZHS16GBK
rman target / log=rman_output.log--操作系统级别
RMAN> spool log to rman_output.log --Rman命令行
RMAN> set echo on
RMAN> backup database;
RMAN> spool log off;
7:Viewing RMAN Command History
SQL>select sid, recid, output from v$rman_output order by recid
8:Enabling RMAN’s Debug Output
--OS
rman target / debug=all log=rman_output.log
rman target / debug=io --
--Fr om Within RMAN
RMAN> spool log to rman_output.log
RMAN> debug on
RMAN> set echo on
RMAN> backup database;
RMAN> debug off
RMAN> spool log off
--W hen Configuring a Channel
RMAN> configure channel device type disk debug=5 trace=5;
9:Enabling Granular Time Reporting
export NLS_DATE_FORMAT 'dd-mon-yyyy hh24:mi:ss'
NLS_DATE_FORMAT 'dd-mon-yyyy hh24:mi:ss'
10:RMAN-03009 ORA-19804
输入数据文件: 文件号=00050 名称=+ORADATA/purple/datafile/undotbs202.dbf
输入数据文件: 文件号=00051 名称=+ORADATA/purple/datafile/user01.dbf
输入数据文件: 文件号=00052 名称=+ORADATA/purple/datafile/users02.dbf
输入数据文件: 文件号=00001 名称=+ORADATA/purple/datafile/system.256.762094681
输入数据文件: 文件号=00002 名称=+ORADATA/purple/datafile/sysaux.257.762094681
输入数据文件: 文件号=00046 名称=+ORADATA/purple/datafile/system02.dbf
输入数据文件: 文件号=00003 名称=+ORADATA/purple/datafile/undotbs1.258.762094683
输入数据文件: 文件号=00005 名称=+ORADATA/purple/datafile/undotbs2.267.762094901
输入数据文件: 文件号=00004 名称=+ORADATA/purple/datafile/users.259.762094683
通道4 正在启动段 1与23-1月-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: backup 命令(t4 通道上,在01/23/2013 17:18:42上)失败
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收53477376字节磁盘空间(从4196401152限制中)
- Rman备份中常见的问题
- 解决rman备份脚本中密码明文的问题--wallet
- RMAN备份FORMAT格式中%的含义
- RMAN备份FORMAT格式中%的含义
- RMAN备份FORMAT格式中%的含义
- RMAN备份FORMAT格式中%的含义
- rman的备份
- RMAN的备份加密
- RMAN备份的特性
- RMAN备份的概念
- rman的自动备份
- RMAN备份保存策略为天数引起的问题
- [Rman]Rman增量备份level012的区别
- rman备份中差异增量和累积增量的区别
- rman备份中obsolete和expired的区别
- RMAN备份FORMAT格式中%a的含义
- fishcat论 RMAN备份中加filesperset的重要性
- fishcat论 RMAN备份中加filesperset的重要性续
- Hibernate Annotations
- Mysql命令
- ARC 和 非ARC 之间的转换方法
- 【给数学不好的人的KMP】字符匹配教程(二)简化运算是为了什么如何移位
- 输入WIFI密码,连接按钮显示为灰色
- Rman备份中常见的问题
- redhat/centos-6.3上opennebula-3.8部署
- 将16进制的颜色值变成UIColor
- 关键段,事件,互斥量,信号量的“遗弃”问题
- Quartz 各种绘制图形用法 Quartz 实现画图片、写文字、画线、椭圆、矩形、棱形等。
- DataGridView图像文本单元格
- 肖特基二极管
- Cocos2d触摸分发原理
- 献给不知道自己该干什么的朋友—值得一看