还原种子数据库练习(五)
============================
RMAN-03002: failure of alter db command at 09/05/2013 14:08:25
ORA-00349: failure obtaining block size for '/ade/b/385031636/oracle/oradata/seeddata/redo01.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9
---------缺少redo文件，添加3个redo log文件，并且要修改位置
RMAN> ALTER DATABASE OPEN RESETLOGS;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/05/2013 14:10:02
ORA-00349: failure obtaining block size for '/ade/b/385031636/oracle/oradata/seeddata/redo03.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9
------上述缺少redolog文件，需要建立redo log文件
[oracle@elvis-desktop dbs]$ export ORACLE_SID=ORCL
[oracle@elvis-desktop dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 5 14:08:51 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database rename file '/ade/b/385031636/oracle/oradata/seeddata/redo01.log' to '/oracle/oradata/ORCL/redo01.log';
Database altered.
SQL> alter database rename file '/ade/b/385031636/oracle/oradata/seeddata/redo02.log' to '/oracle/oradata/ORCL/redo02.log';
Database altered.
SQL>
alter database rename file '/ade/b/385031636/oracle/oradata/seeddata/redo03.log' to '/oracle/oradata/ORCL/redo03.log';
Database altered.
RMAN> ALTER DATABASE OPEN RESETLOGS;
database opened
---------->>>>>>数据库成功打开，需要做一次全备
[oracle@elvis-desktop dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 5 14:10:52 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
OPEN
------------------->>>>为新数据库创建spfile，并且重启数据库
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 238034944 bytes
Fixed Size 2227136 bytes
Variable Size 180356160 bytes
Database Buffers 50331648 bytes
Redo Buffers 5120000 bytes
Database mounted.
Database opened.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/product/11.2.0/dbhome_1/dbs/spfileORCL.ora
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string SEEDDATA
db_unique_name string SEEDDATA
global_names boolean FALSE
instance_name string ORCL
lock_name_space string
log_file_name_convert string
processor_