1.RMAN-04006 ORA-12528，将备库启动到nomoun 用RMAN复制物理备库时，容易出错，并且出错很诡异笔者在下边总结了所遇到的几点。1.RMAN-04006 ORA-12528将备库启动到nomount状态下SQL> startup nomount Oracle 例程已经启动。Total System Global Area 751595520 bytesFixed Size 2292912 bytesVariable Size...
connected to target database: ORA11G (DBID=4026820313) connected to auxiliary database: ORA11G (not mounted) RMAN> 第二种方法为AUXILIARY数据库设置静态监听,在$ORACLE_HOME/network/admin目录下的listener.ora中添加下面的内容: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ora11g) (...
通道ORA_AUX_DISK_1: 正在开始恢复数据文件备份集 通道ORA_AUX_DISK_1: 正在指定从备份集还原的数据文件 正将数据文件00001还原到/u01/soft/oradata/standby/system01.dbf 正将数据文件00002还原到/u01/soft/oradata/standby/undotbs01.dbf 正将数据文件00003还原到/u01/soft/oradata/standby/sysaux01.dbf 正将...
*.log_file_name_convert=‘/u01/app/oradata/yunhaip’,‘/u01/app/oradata/yunhaip’ EOF6.2、拷贝主库的pfile到从库,并修改如下内容:[oracle@oraclep dbs]$ pwd /u01/app/oracle/product/11.2.0/db_1/dbs [oracle@oraclep dbs]$ scp inityunhaip.ora 192.168.56.117:/u01/app/oracle/product/11.2...
rman连接AUXILIARY报错ORA-12528 2013-05-30 23:11 −rman连接AUXILIARY报错ORA-12528 === 作者: yangtingkun(http://yangtingkun.itpub.net) 发表于: 2007.12.05 2... wilson.han 0 697 使用RMAN Active duplicate创建异地auxiliary Database 2018-06-08 10:...
6 STANDBY /u01/app/oracle/oradata/JASON/standby03.log 7 STANDBY/u01/app/oracle/oradata/JASON/standby04.log 7 rows selected. 4.主库参数文件配置 在主库上修改dataguard配置相关的各个参数,各参数的具体含义可以参考oracle在线文档。 SQL> alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(JASON1,JASON...
orapwmydb 100% 1536 1.5KB/s 00:00 3、配置target db 和auxiliary db的监听 --auxiliary db必须使用静态监听,否则报错RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
piece handle=/u01/app/oracle/flash_recovery_area/ORATEST/autobackup/2014_03_05/o1_mf_s_841404247_9kf66qvs_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 05-MAR-14 在进行duplicate操作过程中,target数据库最好维持mount状态!
RMAN-04006: errorfromauxiliarydatabase: ORA-12528: TNS:listener:allappropriate instances are blocking new connections 造成这个问题的原因是,实例虽然启动,但是没有注册到监听。实例是通过PMON进程注册到监听上的,而PMON进程需要在MOUNT状态下才会启动。因此造成了上面的错误。
SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/JASON/standby04.log')SIZE 50M; Database altered. SQL> select group#,status,type,member from v$logfile; GROUP# STATUS TYPE MEMBER --- 3 ONLINE /u01/app/oracle/oradata/JASON/redo03.log 2 ONLINE /u01/app/oracle/oradata/...