duplicate ORA-01405: fetched column value is NULL
DG 用 rman duplicate 恢復standby 的問題及解決。
SQL> startup nomount pfile=/opt/oracle/product/10g/dbs/initorcl.ora
LRM-00123: invalid character 148 found in the input file
ORA-01078: failure in processing system parameters
RMAN> duplicate target database for standby nofilenamecheck dorecover;
Starting Duplicate Db at 28-MAR-12
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/28/2012 12:18:13
ORA-01405: fetched column value is NULL
解決方法主庫: alter system switch logfile;
RMAN> duplicate target database for standby nofilenamecheck dorecover;
Starting Duplicate Db at 28-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK
contents of Memory Script.:
{
set until scn 485861;
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script
executing command: SET until clause
Starting restore at 28-MAR-12
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/dgdb1_02n70jpe_1_1_20120328
ORA-19870: error reading backup piece /u01/backup/dgdb1_02n70jpe_1_1_20120328
ORA-19505: failed to identify file "/u01/backup/dgdb1_02n70jpe_1_1_20120328"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/28/2012 12:20:16
RMAN-03015: error occurred in stored script. Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
RMAN> restore database validate;
Starting restore at 28-MAR-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /u01/backup/dgdb1_07n70li1_1_1_20120328
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/backup/dgdb1_07n70li1_1_1_20120328 tag=TAG20120328T123409
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
Finished restore at 28-MAR-12
驗證控制檔案不可用,是我們備份的指令碼有問題。換了一個資料備份指令碼 OK 了
RMAN> restore controlfile validate;
Starting restore at 28-MAR-12
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/28/2012 12:34:50
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/opt/oracle/oradata/research/redo04.log') size 50M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/opt/oracle/oradata/research/redo04.log') size 50M
*
ERROR at line 1:
ORA-01156: recovery in progress may need access to files
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-767943/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 錯誤:duplicate column name: picstitle
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- use the function_based index to access the null valueFunctionIndexNull
- In V$SESSION, column SQL_ID is not NULL while STATUS is INACTIVESessionSQLNullWhile
- [20230303]sqlplus column new_value old_value.txtSQL
- mysql 主從同步 Error 'Out of range value for column的問題MySql主從同步Error
- Hashtable/HashMap與key/value為null的關係HashMapNull
- [20231103]sqlplus column new_value old_value.txtSQL
- 升級提示 執行SQL發生錯誤!錯誤:duplicate column name: picstitleSQL
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- 解決問題:Variable 'time_zone' can't be set to the value of 'NULL'Null
- [20180808]Null value to Dynamic SQL.txtNullSQL
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- VUE前端打包報錯:TypeError: Class extends value undefined is not a constructor or nullVue前端ErrorUndefinedStructNull
- 異常:java.sql.SQLIntegrityConstraintViolationException: Column 'category' cannot be nullJavaSQLAIExceptionGoNull
- Anti-Join中允許關聯column為空值( null),造成hint失效Null
- pbootcms升級提示 執行SQL發生錯誤!錯誤:duplicate column name: picstitlebootSQL
- MySQL ERROR 1366(HY000):Incorrect string value:''for column''at row 1解決方案MySqlError
- 安裝mysql遇到ERROR: 1136 Column count doesn't match value count at row 1MySqlError
- Variable 'character_set_client' can't be set to the value of Null的解決方法clientNull
- [Err] 1231 - Variable 'sql_mode' can't be set to the value of 'NULLSQLNull
- [mysql] 批量匯入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULLMySqlclientNull
- mysql匯入報錯Variable 'sql_notes' can't be set to the value of 'NULL'MySqlNull
- Not-null property references a transient value - transient instance must be saved before current opeNull
- pymysql.err.OperationalError: (1136, “Column count doesn‘t match value count at row 1“)報錯反省。MySqlError
- Caused by: org.apache.parquet.io.ParquetDecodingException: Can‘t read value in column [result, labelApacheException
- java.sql.BatchUpdateException: Date truncation: Out of range value for column xxxxxJavaSQLBATException
- ((NULL) null).printNULL();((NULL) null).printnull();Null
- ora-30004:when using sys_connect_by_path function,cannot have seperator as part of column valueFunction
- Error: no such columnError
- rman複製 資料庫 ORA-01405 錯誤資料庫
- IS NULL和IS NOT NULLNull
- not null與check is not nullNull
- duplicate databaseDatabase
- Column Monitoring
- 了不起的 “filter(NULL IS NOT NULL)”FilterNull
- MySQL中is not null和!=null和<>null的區別MySqlNull
- 解決:java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\x94‘ for columnJavaSQLException