-
编辑 删除
Oracle standby的ORA-01578 ORA-01110 ORA-26040 坑爹的NOLOGGING
异常：DB: Oracle 11.2.0.1 --版本够low的五一假期时给用户DB做了switch over主备切换后，用了发现切换后新的主库DB中报错如下：Wed May 08 09:44:14 2019Errors in file /u01/product/diag/rdbms/new/orcl/trace/orcl_ora_100843.trc (incident=50865)
-
编辑 删除
通过RMAN备份standby database成功恢复还原
前言：为了提高升系统安全，通常会在primary DB+standby DB之外再做一份备份。但直接对primary DB备份可能会带来性能问题，所以决定在standby DB(open_mode:
-
编辑 删除
Controlfile和system01數據文件丟失的恢復(通过standby)
問題巴西時間：FriNov 16 21:00:02 2012,北京時間:週六早上7點DELL 2950 server + Oracle 9.2.0.7 / ,/u01(ORACLE_HOME,ORACLE_BASE)相關一塊硬盤RAID1 (76G) 與磁盤陣列卡 同時壞掉/data(大部份datafile,redo logfile) RAID5 (146G) 沒有損壞 分析如果備份激活的話，需要變...
-
编辑 删除
Rman-10038: Database Session For Channel D1 Terminated Unexpectedly
ID 399395.1)转到底部In this DocumentSymptomsSolutionApp...
-
编辑 删除
incremental from scn for gap standby 实验
环境：Red Hat Enterprise Linux AS release 4 (Nahant) Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod备库中：SELECT current_scn+1 FROM V$DATAFILE主库中...
-
编辑 删除
Rman Backups When The Directory Structures Are Different
10) Now restore the datafiles to new locations and recover. Since we are recovering the database here till the archivelog sequence 50 the sequence number in the SET UNTIL SEQUENCE clause should be &nb...
