Databases Reference
In-Depth Information
2.
From the previous output, you can see that the backup piece with the name
+FRA/prodb2/backupset/2012_08_02/o1_mf_nnndf_
TAG20061110T175734_2ob0yzgp_.bkp is in the old place. Move it to the right directory
using the appropriate tool. Here is an example in ASMCMD:
ASMCMD> cp
+fra/prodb2/backupset/2012_07_21/nnndn0_TAG20120721T183841_0.262.789244721 +fra/prod2/bs1.rmb
copying
+fra/prodb2/backupset/2012_07_21/nnndn0_TAG20120721T183841_0.262.789244721 -> +fra/prod2/bs1.rmb
3.
Now that the backup piece is in the right directory, you must tell that fact to RMAN. First
you need to remove the identity of the backup piece from the RMAN repository using a
process generally known as uncataloging:
RMAN> change backuppiece
'+FRA/prodb2/backupset/2012_08_02/o1_mf_nnndf_TAG20061110T175734_2ob0yzgp_.bkp' uncatalog;
uncataloged backuppiece
backup piece handle=+FRA/cdb1/backupset/2012_08_02/o1_mf_nnndf_TA G20061110T175734_2ob0yzgp_.bkp
recid=153 stamp=606160655
Uncataloged 1 objects
4.
Then catalog the piece again with the correct file:
RMAN> catalog backuppiece '+FRA/prod2/backupset/2012_08_02/o1_mf_nnndf_TA
G20061110T175734_2ob0yzgp_.bkp';
cataloged backuppiece
backup piece handle+FRA/PROD2/backupset/2012_08_02/o1_mf_nnndf_TAG20061110T175734_2ob0yzgp_.bkp
recid=157 stamp=606163369
Note there is no need to tell what type of file you are cataloging. RMAN queries the file header and gets that
information. If you have a lot of files in this directory, instead of issuing the command once per file, you can use the
following command:
RMAN> catalog start with '+FRA/prod2/backupset/2012_08_02';
It will automatically scan the headers of each file in that directory and catalog them with proper types.
5.
Test whether RMAN knows this file is a backup piece of the database:
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
159 Full 796.63M DISK 00:01:57 02-AUG-12
BP Key: 157 Status: AVAILABLE Compressed: NO Tag:TAG20061110T175734
Piece Name: +FRA/PROD2/backupset/2012_08_02/o1_mf_nnndf_TAG20061110T175734_2ob0yzgp_.bkp
List of Datafiles in backup set 159
