Hi,
We are using 2 node rac setup. DATA disk was crashed. so i restored database using my RMAN backup and its sucessfully restored. but iam getting below error when switching to pluggable database after that not able to login to CDB also. so confused pls help me.
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 51 and starting SCN of 2565038
RMAN> exit
Recovery Manager complete.
[oracle@rac1 backup]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed May 3 23:42:57 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> alter database open RESETLOGS;
Database altered.
SQL> select name,open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDBPROD MOUNTED
SQL> alter pluggable database PDBPROD open;
Pluggable database altered.
SQL> alter session set container=PDBPROD;
ERROR:
ORA-46362: Could not translate variable ORACLE_BASE.
ORA-46362: Could not translate variable ORACLE_BASE.
SQL> !
[oracle@rac1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed May 3 23:48:03 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected.
SQL> show con_name
ERROR:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0