Posted in Forgotten themes

Restoring a PDB causes problems

I am reading the documentation again and I don’t understand why I cannot restore a tablespace in a PDB

[oracle@hackbook ~]$ rman target sys@"(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=rcat))(ADDRESS=(PROTOCOL=TCP)(HOST="

Recovery Manager: Release - Production on Tue Jul 5 14:56:13 2016

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

target database Password: 
connected to target database: CCLOUD1 (DBID=1191441626, not open)

RMAN> report schema ;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CLOUDDB1

List of Permanent Datafiles
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
7    260      SYSTEM               NO      /u01/app/oradata/CLOUDDB1/36994AC799462E62E0530F02000AFF86/datafile/o1_mf_system_cqfldc9b_.dbf
8    605      SYSAUX               NO      /u01/app/oradata/CLOUDDB1/36994AC799462E62E0530F02000AFF86/datafile/o1_mf_sysaux_cqfldcrv_.dbf
9    5        USERS                NO      /u01/app/oradata/CLOUDDB1/36994AC799462E62E0530F02000AFF86/datafile/o1_mf_users_cqfljdqg_.dbf
10   10       CORRUPTION           NO      /u01/app/oradata/CLOUDDB1/36994AC799462E62E0530F02000AFF86/datafile/o1_mf_corrupti_cqnms1yb_.dbf

List of Temporary Files
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
3    20       TEMP                 32767       /u01/app/oradata/CLOUDDB1/36994AC799462E62E0530F02000AFF86/datafile/o1_mf_temp_cqfldctf_.dbf

RMAN> restore tablespace CORRUPTION ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "corruption": expecting one of: "root, double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 1 column 20 file: standard input

RMAN> restore datafile 10 ;

Starting restore at 05-JUL-16
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 00010 to /u01/app/oradata/CLOUDDB1/36994AC799462E62E0530F02000AFF86/datafile/o1_mf_corrupti_cqnms1yb_.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oradata/fra/CLOUDDB1/36994AC799462E62E0530F02000AFF86/backupset/2016_07_04/o1_mf_nnndf_TAG20160704T140801_cqnnh3n8_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oradata/fra/CLOUDDB1/36994AC799462E62E0530F02000AFF86/backupset/2016_07_04/o1_mf_nnndf_TAG20160704T140801_cqnnh3n8_.bkp tag=TAG20160704T140801
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 05-JUL-16

RMAN> recover datafile 10 ;

Starting recover at 05-JUL-16
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 171 is already on disk as file /u01/app/oradata/fra/CLOUDDB1/archivelog/2016_07_05/o1_mf_1_171_cqpyfdmo_.arc
archived log for thread 1 with sequence 172 is already on disk as file /u01/app/oradata/fra/CLOUDDB1/archivelog/2016_07_05/o1_mf_1_172_cqpyfdcm_.arc
archived log for thread 1 with sequence 173 is already on disk as file /u01/app/oradata/fra/CLOUDDB1/archivelog/2016_07_05/o1_mf_1_173_cqpyfdk7_.arc
archived log for thread 1 with sequence 1 is already on disk as file /u01/app/oradata/fra/CLOUDDB1/archivelog/2016_07_05/o1_mf_1_1_cqq9x4j3_.arc
archived log file name=/u01/app/oradata/fra/CLOUDDB1/archivelog/2016_07_05/o1_mf_1_171_cqpyfdmo_.arc thread=1 sequence=171
archived log file name=/u01/app/oradata/fra/CLOUDDB1/archivelog/2016_07_05/o1_mf_1_172_cqpyfdcm_.arc thread=1 sequence=172
archived log file name=/u01/app/oradata/fra/CLOUDDB1/archivelog/2016_07_05/o1_mf_1_173_cqpyfdk7_.arc thread=1 sequence=173
media recovery complete, elapsed time: 00:00:01
Finished recover at 05-JUL-16



Database administrator who loves to work with Oracle software. (Sometimes not)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s