1. 首页
  2. IT资讯

处理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/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:℅傍ㄖ免沦陷dε鬼,转转请注明出处:http://www.cxybcw.com/192800.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code