Database Software

Hi All--

I started Back up of one of my PDB using RMAN utility following the instructions on the below link.

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_pitr/pdb_pitr.html

--Connect to Oracle RMAN.
rman> Connect target /
--Set the Oracle RMAN backup device type and backup file location.
rman> configure channel device type disk format '/stage/db_backup_files/cdb1/%U';
--Turn on automatic backup of control files.
rman> configure controlfile autobackup on;
--Back up the database and archive logs.
rman>backup database plus archivelog;
rman> exit

Back up was done successfully but when I started with the Recovery  process it gave me error on the recovery statement.

run {
set until SCN = 2263440 ;
restore pluggable database pdb2;
recover pluggable database pdb2 auxiliary destination='/stage/db_backup_files/cdb1';
alter pluggable database pdb2 open resetlogs;
}

Below is the trace of RMAN

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Aug 22 12:22:44 2015


Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


RMAN> connect target /


connected to target database: RELIABLE (DBID=1028507357)


RMAN> run {
2> ALTER PLUGGABLE DATABASE MultiPlay CLOSE;
3> set until SCN = 14899894 ;
4> restore pluggable database MultiPlay;
5> recover pluggable database MultiPlay;
6> alter pluggable database MultiPlay open resetlogs;
7> }


using target database control file instead of recovery catalog
Statement processed


executing command: SET until clause


Starting restore at 22-AUG-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK


channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00035 to E:\APP\ORADATA\RELIABLE\MULTIPLAY\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00036 to E:\APP\ORADATA\RELIABLE\MULTIPLAY\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00037 to E:\APP\ORADATA\RELIABLE\MULTIPLAY\MULTIPLAY_USERS01.DBF
channel ORA_DISK_1: reading from backup piece E:\APP\RECOVERY_AREA\RELIABLE\40A433F530464F3BBF2E7C0B1553ECE8\BACKUPSET\2015_08_22\O1_MF_NNNDF_TAG20150
822T115328_BXJ5C182_.BKP
channel ORA_DISK_1: piece handle=E:\APP\RECOVERY_AREA\RELIABLE\40A433F530464F3BBF2E7C0B1553ECE8\BACKUPSET\2015_08_22\O1_MF_NNNDF_TAG20150822T115328_BX
J5C182_.BKP tag=TAG20150822T115328
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 22-AUG-15


Starting recover at 22-AUG-15
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time


List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1


Creating automatic instance, with SID='zbnt'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/22/2015 12:24:56
ORA-19852: error creating services for auxiliary instance zbnt (error 0)
ORA-27302: failure occurred at:
ORA-27303: additional information: failed to start instance

Thanks

Sayam