ORA-12514：RMAN连接报错解决

今天用rman连接数据库报错
[linuxidc@rhel55 ~]$rman target sys/Oracle@orclORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[linuxidc@rhel55 ~]$lsnrctl stop[linuxidc@rhel55 ~]$cd $ORACLE_HOME[linuxidc@rhel55 db_1]$vim listener.ora修改/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora文件
加上
SID_LIST_LISTENER =
（SID_LIST =
（SID_DESC =
（SID_NAME = orcl）
（ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1）
）
）
然后重启lisener服务，就ok了[linuxidc@rhel55 db_1]cd[linuxidc@rhel55 ~]$lsnrctl start[linuxidc@rhel55 ~]$
[linuxidc@rhel55 ~]$ rman target sys/oracle@orclRecovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 3 04:37:05 2012Copyright （c） 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: ORCL （DBID=1302004769, not open）RMAN> show all ;using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "%F"; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM "AES128"; # default
CONFIGURE COMPRESSION ALGORITHM "BASIC" AS OF RELEASE "DEFAULT" OPTIMIZE FOR LOA D TRUE ; # default
CONFIGURE EXCLUDE FOR TABLESPACE "SYSAUX";
CONFIGURE EXCLUDE FOR TABLESPACE "USERS";
CONFIGURE EXCLUDE FOR TABLESPACE "EXAMPLE";
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO "/u01/app/oracle/product/11.0.2/db_1/dbs/ snapcf_orcl.f"; # defaultRMAN>exit
[linuxidc@rhel55 ~]rman help#查看帮助
[linuxidc@rhel55 ~]rman target sys/oracle@orcl log /home/linuxidc/rman_log.txt#记录日志
RMAN>configure device type disk parallelism 4 backup type to compressed backupset;
RMAN>configure device type disk clear;#reset
RMAN>configure device type sbt_tape parallelism 4 backup type to backupset;
RMAN>configure device type disk clear;#reset again
RMAN>configure device type sbt_tape parallelism 4 backup type to compressed backupset;
RMAN>configure device type disk clear;#reset again
RMAN>configure device type disk parallelism 4 backup type to copy;#copy只能是disk类型的
RMAN>configure device type disk clear;#reset again
RMAN>configure retention policy to recovery window of 7 days;#基于恢复窗口的备份保留策略，7天
RMAN>
RMAN> configure retention policy clear;#默认是基于冗余策略，每个文件至少保留一份old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
RMAN configuration parameters are successfully reset to default valueRMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultRMAN> config retention policy to redundancy 2;#基于冗余，每个文件至少保留2份RMAN>configure retention policy to recovery window of 0 days;
RMAN>report obsolete;#查看过时的备份文件
RMAN>delete obsolete;#根据保留策略，删除过时的备份文件
RMAN>configure retention policy to recovery window of 7 days;Oracle数据库的监听器挂起情况Oracle EM 常见问题总结相关资讯 Oracle错误代码

Oracle错误代码大全（02/16/2015 21:31:57）
Oracle中登陆时报ORA-28000: the （03/06/2013 20:06:23）
Oracle 11g startup时报ORA-03113 （02/21/2013 17:25:55）

Oracle Grid Control OUI-25031错（03/09/2013 09:01:36）
ORA-04091:触发器/函数不能读（02/25/2013 08:28:13）
Oracle错误 ORA-12514 解决方法（02/18/2013 08:50:10）

本文评论查看全部评论（0）