Thursday 1 August 2019

Rman Catalog script for Tablespace backup

RMAN> CREATE SCRIPT TBS_FULL_SCRIPT { BACKUP TABLESPACE &1 TAG &2 ;}

Enter value for 1: IDATA

Enter value for 2: SOETBS

created script TBS_FULL_SCRIPT

RMAN> RUN { EXECUTE SCRIPT TBS_FULL_SCRIPT USING IDATA'IDATA102018';}

executing script: TBS_FULL_SCRIPT

Starting backup at 01-AUG-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=52 instance=rac1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/RAC/DATAFILE/idata.269.1014653909
channel ORA_DISK_1: starting piece 1 at 01-AUG-19
channel ORA_DISK_1: finished piece 1 at 01-AUG-19
piece handle=/u01/Backup/ora_df1015161939_s191_s1 tag=IDATA102018 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:55
Finished backup at 01-AUG-19

RMAN> list backup tag 'IDATA102018';


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1430    Full    2.14G      DISK        00:02:50     01-AUG-19
        BP Key: 1433   Status: AVAILABLE  Compressed: NO  Tag: IDATA102018
        Piece Name: /u01/Backup/ora_df1015161939_s191_s1
  List of Datafiles in backup set 1430
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 14593371   01-AUG-19 +DATA/RAC/DATAFILE/idata.269.1014653909

RMAN>

Recovery Manager complete.
[oracle@srv1 ~]$ rman target /  catalog rcowner/rcowner@smr2 script=TBS_FULL_SCRIPT USING IDATA  'IDATA2019'

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Aug 1 13:34:31 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RAC (DBID=2599942250)
connected to recovery catalog database

executing script: TBS_FULL_SCRIPT

Starting backup at 01-AUG-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=53 instance=rac1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/RAC/DATAFILE/idata.269.1014653909
channel ORA_DISK_1: starting piece 1 at 01-AUG-19
channel ORA_DISK_1: finished piece 1 at 01-AUG-19
piece handle=/u01/Backup/ora_df1015162475_s192_s1 tag=IDATA2019 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:16
Finished backup at 01-AUG-19

Recovery Manager complete.
[oracle@srv1 ~]$

[oracle@srv2 admin]$ rman target / catalog rcowner/rcowner@smr2 script=TBS_FULL_SCRIPT USING IDATA  'IDATA2019'

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Aug 1 13:44:04 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RAC (DBID=2599942250)
connected to recovery catalog database

executing script: TBS_FULL_SCRIPT

Starting backup at 01-AUG-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=107 instance=rac2 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/RAC/DATAFILE/idata.269.1014653909
channel ORA_DISK_1: starting piece 1 at 01-AUG-19
channel ORA_DISK_1: finished piece 1 at 01-AUG-19
piece handle=/u01/Backup/ora_df1015163050_s193_s1 tag=IDATA2019 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:42
Finished backup at 01-AUG-19

Recovery Manager complete.
[oracle@srv2 admin]$


No comments:

Post a Comment