Mark an Oracle backup piece status as available in the recovery catalog and control file metadata, so you can use the backup piece in restores.
Procedure
-
Execute the following SQL query to retrieve the backup piece name. For additional information on building custom queries, see Build Your Own Reports.
SELECT AF.jobId, AF.name 'backuppeice_name' FROM archFile AF INNER JOIN APP_Application A ON AF.appId = A.id INNER JOIN APP_Client C ON A.clientId = C.id INNER JOIN APP_InstanceName I ON A.instance = I.id WHERE A.appTypeId = 22 AND C.name = 'clientname' AND I.name = 'instancename'
-
Export the results to a csv file. For information on exporting a file, see Exporting and Saving Reports.
-
On the RMAN command line, connect to the target database.
-
On the RMAN command line, type the following command, after substituting the backup piece with the value from the SQL query.
UNIX
allocate channel for maintenance device type 'sbt_tape' PARMS="SBT_LIBRARY=<software_installation_path>, ENV=(CvClientName=clientname,CvInstanceName=Instancename)"; change backuppiece ‘backuppiece _name’ available;
Windows
allocate channel for maintenance device type 'sbt_tape; change backuppiece ‘backuppiece _name’ available;