此文是在测试上篇oracle10g单实例转换为oracle10g rac碰到一些问题,特此记录
oracle10g单实例转化为oracle10g rac(二)__多灾多难
RMAN> recover database;---恢复数据库时,报如下错误
Starting recover at 13-APR-10
using channel ORA_DISK_1
starting media recovery
unable to find archive log
archive log thread=1 sequence=3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/13/2010 08:09:39
RMAN-06054: media recovery requesting unknown log: thread 1 seq 3 lowscn 504948 --这个错误,具体没去查询
RMAN> sql 'alter database open';---打开数据库,报错,须用resetlogs选项
sql statement: alter database open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/13/2010 08:17:55
RMAN-11003: failure during parse/execution of SQL statement: alter database open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> sql 'alter database open resetlogs';---加上resetlogs选项,仍旧出错
sql statement: alter database open resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/13/2010 08:18:11
RMAN-11003: failure during parse/execution of SQL statement: alter database open resetlogs
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+DATA/centos5/undotbs01.dbf'
RMAN> exit
Recovery Manager complete.
-----通过sqlplus途径,加上如下_allow特定参数强制打开数据库
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:18:32 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+DATA/centos5/undotbs01.dbf'
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/centos5/control01.ctl, +
DATA/centos5/control02.ctl, +D
ATA/centos5/control03.ctl
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/centos5/spfilecentos5.or
a
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> show parameter resetlo
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;----数据库打开了
Database altered.
小结:
1,对于rman的备份与恢复机制掌握太差劲
2,使用了隐含参数,打开数据库,马上对数据库进行一个全备
3,取消隐含参数,把数据库恢复正常
----启动转换后的rac第二个实例出错
-bash-3.00$ srvctl start instance -d centos5 -i centos52
PRKP-1001 : Error starting instance centos52 on node capitek2
CRS-0215: Could not start resource 'ora.centos5.centos52.inst'.
-bash-3.00$ sqlplus '/as sysdba'
-bash-3.00$ env|grep SID
ORACLE_SID=centos52
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:40:38 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/centos5/spfilecentos5.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/centos5/spfilecentos5.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> exit
Disconnected
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA DISMOUNTED
ARCH MOUNTED
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:43:24 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA MOUNTED
ARCH MOUNTED
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
-bash-3.00$ export ORACLE_SID=centos52
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:43:47 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-07446: sdnfy: bad value '/u01/app/oracle/admin/centos5/udump' for parameter user_dump_dest.
SQL> exit
Disconnected
-bash-3.00$ ls
alert_centos52.log
-bash-3.00$ tail -f alert_centos52.log
Tue Apr 13 08:43:10 2010
Starting ORACLE instance (normal)
Tue Apr 13 08:43:49 2010
Starting ORACLE instance (normal)
oracle10g单实例转化为oracle10g rac(二)__多灾多难
RMAN> recover database;---恢复数据库时,报如下错误
Starting recover at 13-APR-10
using channel ORA_DISK_1
starting media recovery
unable to find archive log
archive log thread=1 sequence=3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/13/2010 08:09:39
RMAN-06054: media recovery requesting unknown log: thread 1 seq 3 lowscn 504948 --这个错误,具体没去查询
RMAN> sql 'alter database open';---打开数据库,报错,须用resetlogs选项
sql statement: alter database open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/13/2010 08:17:55
RMAN-11003: failure during parse/execution of SQL statement: alter database open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> sql 'alter database open resetlogs';---加上resetlogs选项,仍旧出错
sql statement: alter database open resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/13/2010 08:18:11
RMAN-11003: failure during parse/execution of SQL statement: alter database open resetlogs
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+DATA/centos5/undotbs01.dbf'
RMAN> exit
Recovery Manager complete.
-----通过sqlplus途径,加上如下_allow特定参数强制打开数据库
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:18:32 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+DATA/centos5/undotbs01.dbf'
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/centos5/control01.ctl, +
DATA/centos5/control02.ctl, +D
ATA/centos5/control03.ctl
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/centos5/spfilecentos5.or
a
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> show parameter resetlo
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;----数据库打开了
Database altered.
小结:
1,对于rman的备份与恢复机制掌握太差劲
2,使用了隐含参数,打开数据库,马上对数据库进行一个全备
3,取消隐含参数,把数据库恢复正常
----启动转换后的rac第二个实例出错
-bash-3.00$ srvctl start instance -d centos5 -i centos52
PRKP-1001 : Error starting instance centos52 on node capitek2
CRS-0215: Could not start resource 'ora.centos5.centos52.inst'.
-bash-3.00$ sqlplus '/as sysdba'
-bash-3.00$ env|grep SID
ORACLE_SID=centos52
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:40:38 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/centos5/spfilecentos5.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/centos5/spfilecentos5.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> exit
Disconnected
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA DISMOUNTED
ARCH MOUNTED
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:43:24 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA MOUNTED
ARCH MOUNTED
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
-bash-3.00$ export ORACLE_SID=centos52
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 13 08:43:47 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-07446: sdnfy: bad value '/u01/app/oracle/admin/centos5/udump' for parameter user_dump_dest.
SQL> exit
Disconnected
-bash-3.00$ ls
alert_centos52.log
-bash-3.00$ tail -f alert_centos52.log
Tue Apr 13 08:43:10 2010
Starting ORACLE instance (normal)
Tue Apr 13 08:43:49 2010
Starting ORACLE instance (normal)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-659754/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-659754/