11 Replies Latest reply: Sep 11, 2013 11:54 AM by Eduardo Legatti RSS

    tablespace restore


      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 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:
      ORA-12528: TNS:listener: all appropriate instances are blocking new connections