Database Software

Hello Everyone, Table not found even after tablespace restored and recovered. Please loot at this if you got a minute.
SQL> conn reddy/reddy
Connected.
SQL> select table_name from user_tables where tablespace_name='REDDY';

TABLE_NAME
------------------------------
RECORDS
EMP

SQL> select * from emp;

ENAME E_NUM ESAL E_ID
-------------------- ---------- ---------- ----------
jim 1001 40000 25
sam 1002 30000 27
kim 1003 35000 30
phil 1005 25000 37
sam 1006 32000 40
james 1009 43000 45

6 rows selected.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@RHELSRV ~]$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 4 21:05:37 2012

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

RMAN> connect target/

connected to target database: ORCL (DBID=1314955841)

RMAN> backup tablespace reddy;

Starting backup at 04-JUL-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=115 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00008 name=/u01/app/oracle/oradata/orcl/reddy01.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUL-12
channel ORA_DISK_1: finished piece 1 at 04-JUL-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_07_04/o1_mf_nnndf_TAG20120704T210605_7z8rq6pb_.bkp tag=TAG20120704T210605 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 04-JUL-12

Starting Control File and SPFILE Autobackup at 04-JUL-12
piece handle=/u01/orabackup/c-1314955841-20120704-01 comment=NONE
Finished Control File and SPFILE Autobackup at 04-JUL-12

RMAN> exit


Recovery Manager complete.
[oracle@RHELSRV ~]$ expdp dumpfile=emp.dmp logfile=emp.log directory=dpump tables=emp

Export: Release 10.2.0.1.0 - Production on Wednesday, 04 July, 2012 21:07:21

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

Username: reddy
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "REDDY"."SYS_EXPORT_TABLE_01": reddy/******** dumpfile=emp.dmp logfile=emp.log directory=dpump tables=emp
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
. . exported "REDDY"."EMP" 6.070 KB 6 rows
Master table "REDDY"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for REDDY.SYS_EXPORT_TABLE_01 is:
/u01/orabackup/emp.dmp
Job "REDDY"."SYS_EXPORT_TABLE_01" successfully completed at 21:08:07

[oracle@RHELSRV ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 4 21:08:21 2012

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

Enter user-name: reddy
Enter password:

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

SQL> drop table emp;

Table dropped.

SQL> select table_name from user_tables where tablespace_name='REDDY';

TABLE_NAME
------------------------------
RECORDS

SQL> conn /as sysdba
Connected.
SQL> alter tablespace reddy offline;

Tablespace altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@RHELSRV ~]$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 4 21:09:39 2012

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

RMAN> restore tablespace reddy;

Starting restore at 04-JUL-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/04/2012 21:09:56
RMAN-12010: automatic channel allocation initialization failed
RMAN-06171: not connected to target database

RMAN> connect target/

connected to target database: ORCL (DBID=1314955841)

RMAN> restore tablespace reddy;

Starting restore at 04-JUL-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=109 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00008 to /u01/app/oracle/oradata/orcl/reddy01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_07_04/o1_mf_nnndf_TAG20120704T210605_7z8rq6pb_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_07_04/o1_mf_nnndf_TAG20120704T210605_7z8rq6pb_.bkp tag=TAG20120704T210605
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 04-JUL-12

RMAN> recover tablespace reddy;

Starting recover at 04-JUL-12
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 04-JUL-12

RMAN> exit


Recovery Manager complete.
[oracle@RHELSRV ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 4 21:10:42 2012

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> alter tablespace reddy online;

Tablespace altered.

SQL> conn reddy/reddy
Connected.
SQL> select table_name from user_tables where tablespace_name='REDDY';

TABLE_NAME
------------------------------
RECORDS


Thanks in Advance!!!!