This discussion is archived
11 Replies Latest reply: Sep 11, 2013 9:54 AM by Eduardo Legatti RSS

tablespace restore

user10890219 Newbie
Currently Being Moderated


Hi all experts,

My environment is 2 node rac 11GR2 in windows 2008. I put the database in no mount mode but when i tried to log in through sqlplus , i am getting following errors,. My purpose is to restore control file from autobackup for dropped tablespace in rman while database in no mount.

C:\Users\bn>SRVCTL start database -d DBTSTLAB -o nomount

C:\Users\bn>sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 08:51:33 2013

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

nolog> connect sys @DBTSTLAB as sysdba
Enter password:
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points