channel ORA_DISK_2: restore complete, elapsed time: 00:01:04
Finished restore at 23-JAN-14
RMAN> recover database;
Starting recover at 23-JAN-14
using channel ORA_DISK_1
using channel ORA_DISK_2
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 23-JAN-14
RMAN> alter database open;
database opened
AMY@PROD>conn / as sysdba
Connected.
SYS@PROD>conn amy/amy
ERROR:
ORA-03135: connection lost contact
ERROR:
ORA-24315: illegal attribute type
Warning: You are no longer connected to ORACLE.
@>conn / as sysdba
ERROR:
ORA-24313: user already authenticated
@>exit
[oracle@odd-oelr4u8 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 23 14:41:14 2014
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, Oracle Label Security, OLAP and Data Mining options
SYS@PROD>conn amy/amy
Connected.
AMY@PROD>select * from t_amy02;
select * from t_amy02
*
ERROR at line 1:
ORA-00376: file 10 cannot be read at this time
ORA-01110: data file 10: '/u01/app/oracle/oradata/PROD/disk1/tbs_amy01.dbf'
SYS@PROD>alter tablespace tbs_amy begin backup;
alter tablespace tbs_amy begin backup
*
ERROR at line 1:
ORA-01128: cannot start online backup - file 10 is offline
ORA-01110: data file 10: '/u01/app/oracle/oradata/PROD/disk1/tbs_amy01.dbf'
SYS@PROD>alter database datafile 10 online;
Database altered.
SYS@PROD>alter tablespace tbs_amy begin backup;
Tablespace altered.
SYS@PROD>alter tablespace tbs_amy end backup;
Tablespace altered.
SYS@PROD>conn amy/amy
Connected.
AMY@PROD>select * from t_amy02;
B
----------
11
12
13