Showing posts with label catalog. Show all posts
Showing posts with label catalog. Show all posts

Thursday, May 15, 2014

Catalog backuppiece using RMAN



1. Cataloging the backuppiece

RMAN> catalog
2> device type disk
3> backuppiece "/SHARED/backup1/5ep8avdp_1_1_copy";

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=55 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=47 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=23 device type=DISK
cataloged backup piece
backup piece handle=/SHARED/backup1/5ep8avdp_1_1_copy RECID=150 STAMP=847619187


2.List the status of cataloged backuppiece

RMAN> list backuppiece "/SHARED/backup1/5ep8avdp_1_1_copy";


List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
150     99      1   2   AVAILABLE   DISK        /SHARED/backup1/5ep8avdp_1_1_copy

Cataloging a directory using RMAN



RMAN> catalog start with '/SHARED/backup1/' noprompt
2> ;

searching for all files that match the pattern /SHARED/backup1/

List of Files Unknown to the Database
=====================================
File Name: /SHARED/backup1/system.256.847354793
File Name: /SHARED/backup1/5ep8avdp_1_1_custom_copy
File Name: /SHARED/backup1/system_custom_copy
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /SHARED/backup1/system.256.847354793
File Name: /SHARED/backup1/5ep8avdp_1_1_custom_copy
File Name: /SHARED/backup1/system_custom_copy