nomount 状态 编录也能查看备份信息--控制文件丢失也是nomount状态？

[oracle@Slave1Hadoop51 ~]$ rman target sys/ml123456@db01 catalog rcowner/rcowner@db02


Recovery Manager: Release 10.2.0.1.0 - Production on Sat Feb 7 00:06:24 2015


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


connected to target database: DB01 (DBID=1467107934)
connected to recovery catalog database


RMAN> show snapshot controlfile name;


RMAN configuration parameters are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f';


RMAN> configure snapshot controlfile name to '/u01/oracle/11G/dbs/catalg/snapcf_db01.f';


snapshot control file name set to: /u01/oracle/11G/dbs/catalg/snapcf_db01.f
new RMAN configuration parameters are successfully stored


RMAN> backup spfile;


Starting backup at 07-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 07-FEB-15
channel ORA_DISK_1: finished piece 1 at 07-FEB-15
piece handle=/u01/oracle/11G/dbs/17pukph7_1_1 tag=TAG20150207T001950 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 07-FEB-15

RMAN> list backup;-- 有备份文件


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
351     Full    80.00K     DISK        00:00:02     07-FEB-15      
        BP Key: 352   Status: AVAILABLE  Compressed: NO  Tag: TAG20150207T001950
        Piece Name: /u01/oracle/11G/dbs/17pukph7_1_1
  SPFILE Included: Modification time: 02-FEB-15


RMAN> exit;

Recovery Manager complete.

-------------------------

[oracle@Slave1Hadoop51 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Feb 7 00:21:57 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> alter database nomount;
alter database nomount
                     *
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1107296256 bytes
Fixed Size    2020192 bytes
Variable Size  989858976 bytes
Database Buffers  100663296 bytes
Redo Buffers   14753792 bytes
SQL> 

---------------登录目标数据库------------

[oracle@Slave1Hadoop51 ~]$ rman target /


Recovery Manager: Release 10.2.0.1.0 - Production on Sat Feb 7 00:26:11 2015


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


connected to target database: db01 (not mounted)


RMAN> list copy;


using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 02/07/2015 00:26:16
ORA-01507: database not mounted


RMAN> list backup;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 02/07/2015 00:26:27
ORA-01507: database not mounted

RMAN> exit

Recovery Manager complete.
[oracle@Slave1Hadoop51 ~]$ rman target sys/ml123456@db01 catalog rcowner/rcowner@db02

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Feb 7 00:26:50 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: db01 (not mounted)
connected to recovery catalog database

RMAN> list backup;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
351     Full    80.00K     DISK        00:00:02     07-FEB-15      
        BP Key: 352   Status: AVAILABLE  Compressed: NO  Tag: TAG20150207T001950
        Piece Name: /u01/oracle/11G/dbs/17pukph7_1_1
  SPFILE Included: Modification time: 02-FEB-15

RMAN> 

RMAN> list backup summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
351     B  F  A DISK        07-FEB-15       1       1       NO         TAG20150207T001950


RMAN>