Make backup available to Rman

When you first do the backup, these files that represent the backup are of course already available to the db that made it.
But if you want, by instance, put theses files to another computer, you have to tell to rman that these files are present, and that it can use them.
Let's say that we got some files backuped with rman in the directory :


and that the files are :

-rw-r----- 1 oracle oinstall    1000448 2008-09-02 09:35 bkp_664364115_39_1
-rw-r----- 1 oracle oinstall 2972377088 2008-09-02 10:27 bkp_664364117_40_1
-rw-r----- 1 oracle oinstall     778752 2008-09-02 10:28 bkp_664367284_41_1

Make sure that these files aren't already present in rman :

RMAN> list backup;

and check there in the ouput, if you can see the files that you want to make available to rman.

Make one file available

You can make file, one by one, available to rman with this command :

RMAN> catalog start with '/mnt/backup-rman/backup/bkp_664364115_39_1';

and rman will ask you if you want to make the file available to him. This solution is only if you want to make available only some files and not all file in a directory and sub-directory.

Make all files in a directory and his sub-directory available

If you want to make available all files in a directory and all his sub-directory, you only have to specify the root directory, like that in our case :

RMAN> catalog start with '/mnt/backup-rman/backup/';

Answer YES, and all the file in the directory/sub-directory will be available to rman to do a restore or whatever you want.
Note that you cannot choose only some file and not the other, it's all or nothing.

Make file(s) unavailable to rman

Making unavailable the backup that report/list rman
Let's say, that you got two file ( that are backup piece ) that are available to rman :


and that we want to make these 2 files unavailable to rman, this can be simply done with this command :

RMAN> change backuppiece '/mnt/backup-rman/file-1-rman.bkp','/mnt/backup-rman/file-2-rman.bkp' uncatalog;

After that you won't see them anymore, when you run a :

RMAN> list backup;

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License