处理undo tablespace损环_rman-06054_一则

此文是在测试上篇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)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-659754/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-659754/