dba-tech

Pruebas de Recovery

RECOVERY DATAFILE

1- mv  pdb_data01.dbf  pdb_data01.dbf.old
2-  rman target sys/manager123@pdb1

3-

RMAN> run

2> {

3> alter tablespace pdb_data offline immediate;

4> restore tablespace pdb_data;

recover tablespace pdb_data;

alter tablespace pdb_data online;

}5> 6> 7> 

Statement processed

Starting restore at 13-DEC-14

using channel ORA_DISK_1

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 00036 to /u09/app/oradata/ORCL12/datafile/PDB/pdb_data01.dbf

channel ORA_DISK_1: reading from backup piece +FRA/ORCL12/0A0DF24AB9DE70B4E0539A00A8C011E3/BACKUPSET/2014_12_13/nnndn0_tag20141213t041241_0.332.866175161

channel ORA_DISK_1: piece handle=+FRA/ORCL12/0A0DF24AB9DE70B4E0539A00A8C011E3/BACKUPSET/2014_12_13/nnndn0_tag20141213t041241_0.332.866175161 tag=TAG20141213T041241

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:07

Finished restore at 13-DEC-14

Starting recover at 13-DEC-14

using channel ORA_DISK_1

starting media recovery

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

Finished recover at 13-DEC-14

Statement processed

RMAN>