使用RMAN做duplicate遇到ORA-12514和ORA-01031 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor --这个很明显是监听文件配置的问题,首先查看口令文件,如果没有先建立 orapwd file='$ORACLE_HOME/dbs/orapw$ORACLE_SID' password=oracle entries=10 force=y 再查看 SQL>...
今天在练习书上一个示例时,出现"ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 错误",示例如下: C:\>rman target sys/orcl@demo 恢复管理器: Release 10.2.0.1.0 - Production on 星期三 10月 1 15:04:00 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到目标数据...
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of servic when run rman duplicate from active database, got error as below. Please advice. I followed all required steps such as 1. static Listener, 2. (UR = ...
NOFILENAMECHECK SPFILE PARAMETER_VALUE_CONVERT 'G:\oracle\oradata\provstdb\CONTROL01.CTL', 'E:\Oracle\oradata\ProvSTDB\CONTROL01.CTL' SET DB_CREATE_FILE_DEST 'E:\Oracle\oradata\ProvSTDB\'; Here also is the tnsnames.ora: GIHUB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HS...
1 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/system01.dbf2 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/sysaux01.dbf3 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/undotbs01.dbf4 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/users01.dbf...
使用RMAN做duplicate遇到ORA-12514和ORA-01031 2010-02-05 11:39 −ORA-12514: TNS:listener does not currently know of service requested in connect descriptor--这个很明显是监听文件配置的问题,首先查看口令文件,如果没有先建立orapwd file='$ORACLE_HOME/d... ...
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 //piece handle生成了3个备份片到/u01/app/oracle/flash_recovery_area/DGWH/backupset Finished backup at 22-SEP-13 Starting backup at 22-SEP-13 using channel ORA_DISK_1 ...
在initorcl.ora添加如下内容: *.DB_UNIQUE_NAME='orcl_pd' *.log_archive_dest_1='location=/u02/archivelog' *.log_archive_dest_2='SERVICE=orcl_st' *.LOG_ARCHIVE_DEST_STATE_1=ENABLE *.LOG_ARCHIVE_DEST_STATE_2=ENABLE *.standby_file_management='AUTO' ...
oracle数据库服务和监听服务配置使用此账户的方式登录(而不是默认的本地系统账号) 2.在目标服务器中配置共享 主要两台win服务器登录用户名和密码需要一致,最好也是数据库安装用户 3.数据库备份脚本 备份脚本路径使用\\方式而不能使用别名盘符 4.数据库备份计划任务 运行任务时请使用下列用户选择ORA_DBA发表...
asm mount ORA-03113 asm rm datafile 恢复 asm 加入vg asm 底层扫描 asm 置空 asmdisk 加入vg asmdisk损坏恢复 asm丢失数据文件恢复 asm修复 asm删除数据文件恢复 asm加入vg asm底层数据块恢复 asm无法mount恢复 asm磁盘加入其他磁盘组恢复 asm磁盘组异常恢复 Asp.Net atana@keemail.me...