########################### # Begin initialize()..... # ########################### Initial SQL_PATH Initial CTL_PATH Initial VAR_PATH Initial ps option Initial Storage Unit Type ######################### # End initialize()..... # ######################### ########################### # Begin end_backup()..... # ########################### select distinct(t.name), b.status from v$backup b, v$datafile d, v$tablespace t where d.ts# = t.ts# and d.file# = b.file# and b.status = 'ACTIVE'; exit SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 26 23:59:10 2023 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options no rows selected Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ######################### # End end_backup()..... # ######################### ############################## # Begin datafile_list()..... # ############################## SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 26 23:59:10 2023 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options 'DATAFILE'||FILE_NAME -------------------------------------------------------------------------------- Datafile /oracle/EPP/sapdata1/system_1/system.data1 Datafile /oracle/EPP/sapdata1/sysaux_1/sysaux.data1 Datafile /oracle/EPP/sapdata2/undo_1/undo.data1 Datafile /oracle/EPP/sapdata4/sr3db_1/sr3db.data1 Datafile /oracle/EPP/sapdata4/sr3db_2/sr3db.data2 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ############################ # End datafile_list()..... # ############################ ############################# # Begin begin_backup()..... # ############################# alter tablespace SYSTEM begin backup; alter tablespace SYSAUX begin backup; alter tablespace PSAPUNDO begin backup; alter tablespace PSAPSR3DB begin backup; exit ########################### # End begin_backup()..... # ########################### ############################### # Begin bpbackup_start()..... # ############################### /usr/openv/netbackup/bin/bpbackup -p epprda_ORA_EPP -s onback -h epprda -t 0 -w 0 -f /usr/openv/script/vars/backuplist1.txt -L /usr/openv/script/logs/hot_backup.log.20230126 Backup started 01/26/2023 23:59:11 23:59:14 Initiating backup 23:59:17 INF - Starting bpbrm 23:59:19 INF - Processing /oracle/EPP/sapdata1/system_1/system.data1 23:59:19 / 23:59:19 /oracle/ 23:59:19 /oracle/EPP/ 23:59:19 /oracle/EPP/sapdata1/ 23:59:19 /oracle/EPP/sapdata1/system_1/ 23:59:31 INF - Beginning backup on server nbuapp of client epprda 23:59:38 /oracle/EPP/sapdata1/system_1/system.data1 23:59:38 INF - Processing /oracle/EPP/sapdata1/sysaux_1/sysaux.data1 23:59:38 /oracle/EPP/sapdata1/sysaux_1/ 23:59:56 /oracle/EPP/sapdata1/sysaux_1/sysaux.data1 23:59:56 INF - Processing /oracle/EPP/sapdata2/undo_1/undo.data1 23:59:56 /oracle/EPP/sapdata2/ 23:59:56 /oracle/EPP/sapdata2/undo_1/ 00:00:54 /oracle/EPP/sapdata2/undo_1/undo.data1 00:00:54 INF - Processing /oracle/EPP/sapdata4/sr3db_1/sr3db.data1 00:00:54 /oracle/EPP/sapdata4/ 00:00:54 /oracle/EPP/sapdata4/sr3db_1/ 00:02:09 /oracle/EPP/sapdata4/sr3db_1/sr3db.data1 00:02:09 INF - Processing /oracle/EPP/sapdata4/sr3db_2/sr3db.data2 00:02:09 /oracle/EPP/sapdata4/sr3db_2/ 00:03:08 /oracle/EPP/sapdata4/sr3db_2/sr3db.data2 00:03:08 /VRTS_IMAGE_SIZE_RECORD 00:03:08 INF - Client completed sending data for backup 00:03:29 INF - Server status = 0 ############################# # End bpbackup_start()..... # ############################# ################################ # Begin chk_backup_stat()..... # ################################ Backup Job is running !!! 00:03:31 INF - Backup by oraepp on client epprda using policy epprda_ORA_EPP, sched onback:the requested operation was successfully completed Backup Job is running !!! Backup Job is running !!! Backup Job was Completed !!! ############################## # End chk_backup_stat()..... # ############################## ########################### # Begin end_backup()..... # ########################### select distinct(t.name), b.status from v$backup b, v$datafile d, v$tablespace t where d.ts# = t.ts# and d.file# = b.file# and b.status = 'ACTIVE'; exit SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 27 00:04:16 2023 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options NAME STATUS ------------------------------ ------------------ SYSAUX ACTIVE PSAPSR3DB ACTIVE SYSTEM ACTIVE PSAPUNDO ACTIVE Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYSAUX PSAPSR3DB SYSTEM PSAPUNDO Begin Tablespace end backup marking..... alter tablespace SYSAUX end backup; alter tablespace PSAPSR3DB end backup; alter tablespace SYSTEM end backup; alter tablespace PSAPUNDO end backup; exit SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 27 00:04:16 2023 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Tablespace altered. Tablespace altered. Tablespace altered. Tablespace altered. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options End Tablespace end backup marking..... ######################### # End end_backup()..... # ######################### ############################### # Begin switch_logfile()..... # ############################### alter system archive log current; exit SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 27 00:04:16 2023 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options System altered. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ############################# # End switch_logfile()..... # ############################# ################################### # Begin backup_controlfile()..... # ################################### alter database backup controlfile to '/usr/openv/script/ctls/controlfile.20230126-23:59:10'; alter database backup controlfile to trace as '/usr/openv/script/ctls/tracefile.20230126-23:59:10'; alter database backup controlfile to trace; exit SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 27 00:04:27 2023 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Database altered. Database altered. Database altered. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options /usr/openv/netbackup/bin/bpbackup -p epprda_ORA_EPP -s ctls -h epprda -t 0 -w 0 -L /usr/openv/script/logs/hot_backup.log.20230126 /usr/openv/script/ctls Backup started 01/27/2023 00:04:27 00:04:29 Initiating backup 00:04:31 INF - Starting bpbrm 00:04:34 INF - Processing /usr/openv/script/ctls 00:04:34 / 00:04:34 /usr/ 00:04:34 /usr/openv/ 00:04:34 /usr/openv/script/ 00:04:34 /usr/openv/script/ctls/ 00:04:40 /usr/openv/script/ctls/controlfile.20230119-23:59:05 00:04:40 INF - Beginning backup on server nbuapp of client epprda 00:04:40 /usr/openv/script/ctls/controlfile.20230120-23:59:05 00:04:40 /usr/openv/script/ctls/controlfile.20230121-23:59:05 00:04:41 /usr/openv/script/ctls/controlfile.20230122-23:59:06 00:04:41 /usr/openv/script/ctls/controlfile.20230123-23:59:06 00:04:41 /usr/openv/script/ctls/controlfile.20230124-23:59:07 00:04:41 /usr/openv/script/ctls/controlfile.20230125-23:59:09 00:04:41 /usr/openv/script/ctls/controlfile.20230126-23:59:10 00:04:41 /usr/openv/script/ctls/tracefile.20230119-23:59:05 00:04:41 /usr/openv/script/ctls/tracefile.20230120-23:59:05 00:04:41 /usr/openv/script/ctls/tracefile.20230121-23:59:05 00:04:41 /usr/openv/script/ctls/tracefile.20230122-23:59:06 00:04:41 /usr/openv/script/ctls/tracefile.20230123-23:59:06 00:04:41 /usr/openv/script/ctls/tracefile.20230124-23:59:07 00:04:41 /usr/openv/script/ctls/tracefile.20230125-23:59:09 00:04:41 /usr/openv/script/ctls/tracefile.20230126-23:59:10 00:04:41 /VRTS_IMAGE_SIZE_RECORD 00:04:41 INF - Client completed sending data for backup 00:04:46 INF - Server status = 0 ################################# # End backup_controlfile()..... # ################################# 00:04:48 INF - Backup by oraepp on client epprda using policy epprda_ORA_EPP, sched ctls:the requested operation was successfully completed