看我的,好像catalog 恢复,碰到问题了:
[oracle@aoracle ezhou]$ mv *.ctl ./bak
[oracle@aoracle ezhou]$ ls -l *.ctl
ls: *.ctl: No such file or directory
[oracle@aoracle ezhou]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 21:00:41 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ezhou (not mounted)
RMAN> run {
2> restore controlfile;
3> recover database;
4> }
Starting restore at 08-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/08/2011 21:01:06
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
RMAN> exit
Recovery Manager complete.
[oracle@aoracle ezhou]$ sqlplus / as sysdba;
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 8 21:01:54 2011
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, OLAP and Data Mining options
SQL> !
[oracle@aoracle ezhou]$ rman target / catalog rman_user/rman_user@prd
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 21:02:21 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ezhou (not mounted)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-01033: ORACLE initialization or shutdown in progress
[oracle@aoracle ezhou]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-DEC-2011 21:03:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=aoracle.domain.com)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-DEC-2011 14:56:19
Uptime 0 days 6 hr. 6 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/pp/oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File /u01/pp/oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aoracle.domain.com)(PORT=1521)))
Services Summary...
Service "ezhou" has 2 instance(s).
Instance "ezhou", status UNKNOWN, has 1 handler(s) for this service...
Instance "ezhou", status BLOCKED, has 1 handler(s) for this service...
Service "ezhou_XPT" has 1 instance(s).
Instance "ezhou", status BLOCKED, has 1 handler(s) for this service...
Service "ezhoudg" has 1 instance(s).
Instance "ezhoudg", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
现在的问题是 怎么到mount 状态,因为目的是恢复control 文件,现在又不能到。