Recovering Table in Non-Container Database and Pluggable Database (PDB) in Container Database (CDB)

Oracle Community

Recovering Table in Non-Container Database and Pluggable Database (PDB) in Container Database (CDB)

 

Table Recovery in Pluggable Database/Non-Container Database:

 

With Oracle Database 12c, Recover Manager (RMAN) enables you to recover one or more tables or your table partitions to a specified point in time without effecting the remaining database objects either for Pluggable database and Non-Container Database. This feature will enabled through Recover Manager (RMAN), reduces time and disk space compared to earlier Oracle Database versions.

 

In earlier Oracle database versions, recovering table will involve the functionality of recovering the entire tablespace containing the table in a separate disk location and export the desired table and import into the original database location (originally dropped location)

 

Creating Table in Pluggable Database (PDB) in Container Database (CDB)

 

[oracle@12cdb ~]$ sqlplus /nolog

 

SQL> conn scott/scott@12cdb:1521/pdb1

Connected.

 

SQL> create table case (name varchar2(10));

Table created.

 

SQL> insert into case values('ORACLE');

1 row created.

 

SQL> insert into case values('MYSQL');

1 row created.

 

SQL> commit;

Commit complete.

 

Check Current SCN from Pluggable Database (PDB)

 

SQL> conn sys/oracle@12cdb:1521/pdb1 as sysdba

Connected.

 

SQL> select current_scn from v$database;

 

CURRENT_SCN

--------------------

2326559

 

Check Current SCN from Container Database (CDB)

 

SQL> select current_scn,name from v$database;

 

CURRENT_SCN NAME

-------------------- -------

2326563 CDB1

 

SQL> exit

 

Login into ‘Recover Manager (RMAN)’ prompt. Once connected, we have to make sure that when we backup the container database, the control file will be backed up as well.

Therefore, issue the following command:

 

[oracle@12cdb ~]$ rman target /

connected to target database: CDB1 (DBID=838297997)

 

ü  RMAN> configure controlfile autobackup on;

ü  RMAN> backup as compressed backupset pluggable database pdb1;

 

 

Starting backup at 28-NOV-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=69 device type=DISK

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00021 name=/u01/app/oracle/oradata/cdb2/pdb_plug_move/example01.dbf

input datafile file number=00019 name=/u01/app/oracle/oradata/cdb2/pdb_plug_move/sysaux01.dbf

input datafile file number=00018 name=/u01/app/oracle/oradata/cdb2/pdb_plug_move/system01.dbf

input datafile file number=00037 name=/u01/app/oracle/oradata/cdb1/pdb1/scott1.dbf

input datafile file number=00020 name=/u01/app/oracle/oradata/cdb2/pdb_plug_move/SAMPLE_SCHEMA_users01.dbf

channel ORA_DISK_1: starting piece 1 at 28-NOV-14

channel ORA_DISK_1: finished piece 1 at 28-NOV-14

piece handle=/u01/app/oracle/fast_recovery_area/CDB1/08D1916DA8ED7561E0536538A8C05650/backupset/2014_11_28/o1_mf_nnndf_TAG20141128T105623_b7j1w040_.bkp tag=TAG20141128T105623 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55

Finished backup at 28-NOV-14

 

Starting Control File and SPFILE Autobackup at 28-NOV-14

piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2014_11_28/o1_mf_s_864817039_b7j1xqky_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 28-NOV-14

 

RMAN> list backup of pluggable database 'pdb1';

 

List of Backup Sets

==============

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

31 Full 171.67M DISK 00:00:58 27-NOV-14

BP Key: 31 Status: AVAILABLE Compressed: YES Tag: TAG20141127T165157

Piece Name: /u01/app/oracle/fast_recovery_area/CDB1/08D1916DA8ED7561E0536538A8C05650/backupset/2014_

……Output Truncated………….

 

RMAN> exit

Recovery Manager complete.

 

Dropping Table from Pluggable Database (PDB)

 

[oracle@12cdb ~]$ sqlplus /nolog

 

SQL> conn scott/scott@12cdb:1521/pdb1

Connected.

 

SQL> drop table scott.case purge;

Table dropped.

 

SQL> exit

 

[oracle@12cdb ~]$ rman target /

connected to target database: CDB1 (DBID=838297997)

 

Recovering Table for Pluggable Database (PDB1)

 

We will now recover the dropped table to the SCN displayed right before the table drop, using the UNTIL SCN clause. If we didn’t know this SCN, we could’ve recovered the table using the UNTIL TIME clause.

 

The recovery will be made by using an auxiliary destination, under '/u01/app/oracle/stage'.

 

ü  RMAN> recover table scott.case of pluggable database pdb1 until scn 2326559 auxiliary destination '/u01/app/oracle/stage';

 

Note: In Case of you want to recover table from Non-Container Database check the syntax below

 

ü  RMAN> RECOVER TABLE "USER1".USER_TABLE UNTIL SCN 2116818 AUXILIARY DESTINATION '/u01/app/oracle/orcl_backup';

Once the table recovery begins, RMAN creates an automatic instance.

 

Starting recover at 28-NOV-14

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='AFlC'

 

initialization parameters used for automatic instance:

db_name=CDB1

db_unique_name=AFlC_pitr_pdb1_CDB1

compatible=12.1.0.2.0

db_block_size=8192

db_files=200

diagnostic_dest=/u01/app/oracle

_system_trig_enabled=FALSE

sga_target=2560M

processes=200

db_create_file_dest=/u01/app/oracle/stage

log_archive_dest_1='location=/u01/app/oracle/stage'

enable_pluggable_database=true

_clone_one_pdb_recovery=true

#No auxiliary parameter file used

 

Once the instance is started, RMAN finds the appropriate backup pieces and loads them into this instance.

 

starting up automatic instance CDB1

Oracle instance started

Total System Global Area 2684354560 bytes

 

Fixed Size 2928008 bytes

Variable Size 587203192 bytes

Database Buffers 2080374784 bytes

Redo Buffers 13848576 bytes

Automatic instance created

 

contents of Memory Script:

{

# set requested point in time

set until scn 2326559;

# restore the controlfile

restore clone controlfile;

 

# mount the controlfile

sql clone 'alter database mount clone database';

 

# archive current online log

sql 'alter system archive log current';

}

executing Memory Script

 

executing command: SET until clause

 

Starting restore at 28-NOV-14

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=22 device type=DISK

 

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/autobackup/2014_11_28/o1_mf_s_864816848_b7j1qrq6_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2014_11_28/o1_mf_s_864816848_b7j1qrq6_.bkp tag=TAG20141128T105408

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/stage/CDB1/controlfile/o1_mf_b7j31vrk_.ctl

Finished restore at 28-NOV-14

 

sql statement: alter database mount clone database

sql statement: alter system archive log current

contents of Memory Script:

{

# set requested point in time

set until scn 2326559;

# set destinations for recovery set and auxiliary set datafiles

set newname for clone datafile 1 to new;

set newname for clone datafile 4 to new;

set newname for clone datafile 3 to new;

set newname for clone datafile 18 to new;

set newname for clone datafile 19 to new;

set newname for clone tempfile 1 to new;

set newname for clone tempfile 3 to new;

# switch all tempfiles

switch clone tempfile all;

# restore the tablespaces in the recovery set and the auxiliary set

restore clone datafile 1, 4, 3, 18, 19;

 

switch clone datafile all;

}

executing Memory Script

 

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

 

renamed tempfile 1 to /u01/app/oracle/stage/CDB1/datafile/o1_mf_temp_%u_.tmp in control file

renamed tempfile 3 to /u01/app/oracle/stage/CDB1/datafile/o1_mf_temp_%u_.tmp in control file

 

RMAN proceeds to restore and recover objects into the auxiliary instance.

 

Starting restore at 28-NOV-14

using channel ORA_AUX_DISK_1

 

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/stage/CDB1/datafile/o1_mf_system_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/stage/CDB1/datafile/o1_mf_undotbs1_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/stage/CDB1/datafile/o1_mf_sysaux_%u_.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/backupset/2014_11_27/o1_mf_nnndf_TAG20141127T180141_b7g6fg17_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2014_11_27/o1_mf_nnndf_TAG20141127T180141_b7g6fg17_.bkp tag=TAG20141127T180141

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:05

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00018 to /u01/app/oracle/stage/CDB1/datafile/o1_mf_system_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00019 to /u01/app/oracle/stage/CDB1/datafile/o1_mf_sysaux_%u_.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/08D1916DA8ED7561E0536538A8C05650/backupset/2014_11_28/o1_mf_nnndf_TAG20141128T105303_b7j1oqc9_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/08D1916DA8ED7561E0536538A8C05650/backupset/2014_11_28/o1_mf_nnndf_TAG20141128T105303_b7j1oqc9_.bkp tag=TAG20141128T105303

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45

Finished restore at 28-NOV-14

 

datafile 1 switched to datafile copy

input datafile copy RECID=12 STAMP=864818372 file name=/u01/app/oracle/stage/CDB1/datafile/o1_mf_system_b7j3228c_.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=13 STAMP=864818372 file name=/u01/app/oracle/stage/CDB1/datafile/o1_mf_undotbs1_b7j322bt_.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=14 STAMP=864818372 file name=/u01/app/oracle/stage/CDB1/datafile/o1_mf_sysaux_b7j322c3_.dbf

datafile 18 switched to datafile copy

input datafile copy RECID=15 STAMP=864818372 file name=/u01/app/oracle/stage/CDB1/datafile/o1_mf_system_b7j35zfx_.dbf

datafile 19 switched to datafile copy

input datafile copy RECID=16 STAMP=864818372 file name=/u01/app/oracle/stage/CDB1/datafile/o1_mf_sysaux_b7j35zfg_.dbf

 

contents of Memory Script:

{

# set requested point in time

set until scn 2326559;

# online the datafiles restored or switched

sql clone "alter database datafile 1 online";

sql clone "alter database datafile 4 online";

sql clone "alter database datafile 3 online";

sql clone 'PDB1' "alter database datafile

18 online";

sql clone 'PDB1' "alter database datafile

19 online";

# recover and open database read only

recover clone database tablespace "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB1":"SYSTEM", "PDB1":"SYSAUX";

sql clone 'alter database open read only';

}

executing Memory Script

 

executing command: SET until clause

sql statement: alter database datafile 1 online

sql statement: alter database datafile 4 online

sql statement: alter database datafile 3 online

sql statement: alter database datafile 18 online

sql statement: alter database datafile 19 online

 

Starting recover at 28-NOV-14

using channel ORA_AUX_DISK_1

 

starting media recovery

 

archived log for thread 1 with sequence 3 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_27/o1_mf_1_3_b7g6ofl8_.arc

archived log for thread 1 with sequence 4 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_27/o1_mf_1_4_b7gnsgkh_.arc

archived log for thread 1 with sequence 5 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_5_b7gx6nrv_.arc

archived log for thread 1 with sequence 6 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_6_b7j0cj1f_.arc

archived log for thread 1 with sequence 7 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_7_b7j2yxg8_.arc

archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_27/o1_mf_1_3_b7g6ofl8_.arc thread=1 sequence=3

archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_27/o1_mf_1_4_b7gnsgkh_.arc thread=1 sequence=4

archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_5_b7gx6nrv_.arc thread=1 sequence=5

archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_6_b7j0cj1f_.arc thread=1 sequence=6

archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_7_b7j2yxg8_.arc thread=1 sequence=7

media recovery complete, elapsed time: 00:00:26

Finished recover at 28-NOV-14

 

sql statement: alter database open read only

contents of Memory Script:

{

sql clone 'alter pluggable database PDB1 open read only';

}

executing Memory Script

sql statement: alter pluggable database PDB1 open read only

 

contents of Memory Script:

{

sql clone "create spfile from memory";

shutdown clone immediate;

startup clone nomount;

sql clone "alter system set control_files =

''/u01/app/oracle/stage/CDB1/controlfile/o1_mf_b7j31vrk_.ctl'' comment=

''RMAN set'' scope=spfile";

shutdown clone immediate;

startup clone nomount;

# mount database

sql clone 'alter database mount clone database';

}

executing Memory Script

sql statement: create spfile from memory

 

database closed

database dismounted

Oracle instance shut down

 

connected to auxiliary database (not started)

Oracle instance started

 

Total System Global Area 2684354560 bytes

 

Fixed Size 2928008 bytes

Variable Size 603980408 bytes

Database Buffers 2063597568 bytes

Redo Buffers 13848576 bytes

 

sql statement: alter system set control_files = ''/u01/app/oracle/stage/CDB1/controlfile/o1_mf_b7j31vrk_.ctl'' comment= ''RMAN set'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

 

Total System Global Area 2684354560 bytes

 

Fixed Size 2928008 bytes

Variable Size 603980408 bytes

Database Buffers 2063597568 bytes

Redo Buffers 13848576 bytes

 

sql statement: alter database mount clone database

 

contents of Memory Script:

{

# set requested point in time

set until scn 2326559;

# set destinations for recovery set and auxiliary set datafiles

set newname for datafile 37 to new;

# restore the tablespaces in the recovery set and the auxiliary set

restore clone datafile 37;

 

switch clone datafile all;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

 

Starting restore at 28-NOV-14

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=22 device type=DISK

 

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00037 to /u01/app/oracle/stage/AFLC_PITR_PDB1_CDB1/datafile/o1_mf_scott_%u_.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/08D1916DA8ED7561E0536538A8C05650/backupset/2014_11_28/o1_mf_nnndf_TAG20141128T105303_b7j1oqc9_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/08D1916DA8ED7561E0536538A8C05650/backupset/2014_11_28/o1_mf_nnndf_TAG20141128T105303_b7j1oqc9_.bkp tag=TAG20141128T105303

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 28-NOV-14

 

datafile 37 switched to datafile copy

input datafile copy RECID=18 STAMP=864818463 file name=/u01/app/oracle/stage/AFLC_PITR_PDB1_CDB1/datafile/o1_mf_scott_b7j3b6gp_.dbf

 

contents of Memory Script:

{

# set requested point in time

set until scn 2326559;

# online the datafiles restored or switched

sql clone 'PDB1' "alter database datafile

37 online";

# recover and open resetlogs

recover clone database tablespace "PDB1":"scott", "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB1":"SYSTEM", "PDB1":"SYSAUX" delete archivelog;

alter clone database open resetlogs;

}

executing Memory Script

 

executing command: SET until clause

sql statement: alter database datafile 37 online

 

Starting recover at 28-NOV-14

using channel ORA_AUX_DISK_1

 

starting media recovery

 

archived log for thread 1 with sequence 7 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_7_b7j2yxg8_.arc

archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_28/o1_mf_1_7_b7j2yxg8_.arc thread=1 sequence=7

media recovery complete, elapsed time: 00:00:00

Finished recover at 28-NOV-14

 

database opened

 

RMAN proceeds to perform an export of the table that needs to be recovered and the appropriate metadata. This export will result in a dump file.

 

contents of Memory Script:

{

sql clone 'alter pluggable database PDB1 open';

}

executing Memory Script

sql statement: alter pluggable database PDB1 open

contents of Memory Script:

{

# create directory for datapump import

sql 'PDB1' "create or replace directory

TSPITR_DIROBJ_DPDIR as ''

/u01/app/oracle/stage''";

# create directory for datapump export

sql clone 'PDB1' "create or replace directory

TSPITR_DIROBJ_DPDIR as ''

/u01/app/oracle/stage''";

}

executing Memory Script

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/stage''

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/stage''

 

Performing export of tables...

EXPDP> Starting "SYS"."TSPITR_EXP_AFlC_nBEi":

EXPDP> Estimate in progress using BLOCKS method...

EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

EXPDP> Total estimation using BLOCKS method: 64 KB

EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE

EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

EXPDP> . . exported "scott"."CASE" 5.070 KB 2 rows

EXPDP> Master table "SYS"."TSPITR_EXP_AFlC_nBEi" successfully loaded/unloaded

EXPDP> ******************************************************************************

EXPDP> Dump file set for SYS.TSPITR_EXP_AFlC_nBEi is:

EXPDP> /u01/app/oracle/stage/tspitr_AFlC_71419.dmp

Export completed

 

contents of Memory Script:

{

# shutdown clone before import

shutdown clone abort

}

executing Memory Script

Oracle instance shut down

 

The exported dump file, containing the recovered table, is then imported into the target database. Once the recovery processed is finished, we should disconnect from RMAN.

 

Performing import of tables...

IMPDP> Master table "SYS"."TSPITR_IMP_AFlC_lfoq" successfully loaded/unloaded

IMPDP> Starting "SYS"."TSPITR_IMP_AFlC_lfoq":

IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE

IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

IMPDP> . . imported "scott"."CASE" 5.070 KB 2 rows

IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

IMPDP> Job "SYS"."TSPITR_IMP_AFlC_lfoq" successfully completed at Fri Nov 28 11:22:30 2014 elapsed 0 00:00:05

Import completed

 

Removing automatic instance

Automatic instance removed

auxiliary instance file /u01/app/oracle/stage/CDB1/datafile/o1_mf_temp_b7j38m84_.tmp deleted

auxiliary instance file /u01/app/oracle/stage/CDB1/datafile/o1_mf_temp_b7j38c16_.tmp deleted

auxiliary instance file /u01/app/oracle/stage/AFLC_PITR_PDB1_CDB1/onlinelog/o1_mf_3_b7j3bb0j_.log deleted

auxiliary instance file /u01/app/oracle/stage/AFLC_PITR_PDB1_CDB1/onlinelog/o1_mf_2_b7j3b9gg_.log deleted

auxiliary instance file /u01/app/oracle/stage/AFLC_PITR_PDB1_CDB1/onlinelog/o1_mf_1_b7j3b8p6_.log deleted

auxiliary instance file /u01/app/oracle/stage/AFLC_PITR_PDB1_CDB1/datafile/o1_mf_scott_b7j3b6gp_.dbf deleted

auxiliary instance file /u01/app/oracle/stage/CDB1/datafile/o1_mf_sysaux_b7j35zfg_.dbf deleted

auxiliary instance file /u01/app/oracle/stage/CDB1/datafile/o1_mf_system_b7j35zfx_.dbf deleted

auxiliary instance file /u01/app/oracle/stage/CDB1/datafile/o1_mf_sysaux_b7j322c3_.dbf deleted

auxiliary instance file /u01/app/oracle/stage/CDB1/datafile/o1_mf_undotbs1_b7j322bt_.dbf deleted

auxiliary instance file /u01/app/oracle/stage/CDB1/datafile/o1_mf_system_b7j3228c_.dbf deleted

auxiliary instance file /u01/app/oracle/stage/CDB1/controlfile/o1_mf_b7j31vrk_.ctl deleted

auxiliary instance file tspitr_AFlC_71419.dmp deleted

Finished recover at 28-NOV-14

 

RMAN> exit

Recovery Manager complete.

 

We will now connect with sqlplus to the Pluggable database (pdb1), with the SCOTT user.

 

Once connected to SQL Plus, we will issue the following command to see if the table was successfully recovered.

 

SQL> conn scott/scott@12cdb:1521/pdb1

Connected.

 

SQL> select * from case;

 

NAME

----------

ORACLE

MYSQL

 

Conclusion: Table has recovered seamlessly for Pluggable Database (PDB) using the option ‘Recover Table” from Recovery Manager (RMAN).

3432 3 /
  • First published by
  • When: 17 Dec 2014 4:17 AM
  • Revisions: 1
  • Comments: 3
Follow / 13 Feb 2015 at 7:30am

awesome, really very good article

Follow / 16 Feb 2015 at 12:36pm

Really a good example . Thanks for the info

Follow / 24 Sep 2015 at 7:11am

very good... now no bother about recover table.........