處理undo tablespace損環_rman-06054_一則

此文是在測試上篇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)