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 ~]$
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]$
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