Vamos simular a execu\u00e7\u00e3o de backup de tablespace em um ambiente Data Guard, tanto do Primary quanto do seu Standby Database.<\/p>\n\n\n\n
Validando configura\u00e7\u00e3o do Data Guard:<\/p>\n\n\n
\n[oracle@fornix1 ~]$ dgmgrl sys\/oracle@CORTEX as sysdba\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 29 04:48:52 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortex"\nConnected as SYSDBA.\nDGMGRL> SHOW CONFIGURATION;\n \nConfiguration - cortex\n \n Protection Mode: MaxPerformance\n Members:\n cortex - Primary database\n cortexdr - Physical standby database\n \nFast-Start Failover: Disabled\n \nConfiguration Status:\nSUCCESS (status updated 46 seconds ago)\n \nDGMGRL> SHOW DATABASE CORTEX;\n \nDatabase - cortex\n \n Role: PRIMARY\n Intended State: TRANSPORT-ON\n Instance(s):\n cortex\n \nDatabase Status:\nSUCCESS\n \nDGMGRL>\n<\/pre><\/div>\n\n\nStandby:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ dgmgrl sys\/oracle@CORTEXDR as sysdba\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 29 04:49:26 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nWelcome to DGMGRL, type "help" for information.\nConnected to "cortexDR"\nConnected as SYSDBA.\nDGMGRL> SHOW DATABASE CORTEXDR;\n \nDatabase - cortexdr\n \n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 1 second ago)\n Apply Lag: 0 seconds (computed 1 second ago)\n Average Apply Rate: 19.00 KByte\/s\n Real Time Query: ON\n Instance(s):\n CORTEXDR\n \nDatabase Status:\nSUCCESS\n \nDGMGRL>\n<\/pre><\/div>\n\n\nNo ambiente que abriga o banco Primary, vou criar um diret\u00f3rio novo para o backup da tablespace:<\/p>\n\n\n
\n[oracle@fornix1 oracle]$ cd \/oracle\/\n[oracle@fornix1 oracle]$ mkdir BACKUP\n[oracle@fornix1 oracle]$ cd BACKUP\/\n[oracle@fornix1 BACKUP]$ pwd\n\/oracle\/BACKUP\n[oracle@fornix1 BACKUP]$\n<\/pre><\/div>\n\n\nRealizando backup da tablespace USERS do banco Primary (CORTEX):<\/p>\n\n\n
\n[oracle@fornix1 BACKUP]$ rman target sys\/oracle@CORTEX CATALOG CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 04:52:02 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> BACKUP TABLESPACE USERS FORMAT '\/oracle\/BACKUP\/users.bak';\n \nStarting backup at 29-JUN-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=99 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00007 name=+DG_DATA\/CORTEX\/DATAFILE\/users.259.1039033555\nchannel ORA_DISK_1: starting piece 1 at 29-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 29-JUN-21\npiece handle=\/oracle\/BACKUP\/users.bak tag=TAG20210629T045255 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 29-JUN-21\n \nStarting Control File and SPFILE Autobackup at 29-JUN-21\npiece handle=+DG_FRA\/CORTEX\/AUTOBACKUP\/2021_06_29\/s_1076475179.272.1076475181 comment=NONE\nFinished Control File and SPFILE Autobackup at 29-JUN-21\n \nRMAN>\n<\/pre><\/div>\n\n\nRealizando o mesmo processo no banco STANDBY:<\/p>\n\n\n
\n[oracle@fornix2 ~]$ cd \/oracle\/\n[oracle@fornix2 oracle]$ mkdir BACKUP\n[oracle@fornix2 oracle]$ cd BACKUP\/\n[oracle@fornix2 BACKUP]$ pwd\n\/oracle\/BACKUP\n[oracle@fornix2 BACKUP]$\n<\/pre><\/div>\n\n\nBackup:<\/p>\n\n\n
\n[oracle@fornix2 BACKUP]$ rman target sys\/oracle@CORTEXDR catalog CAT\/CAT@CORTEX\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 29 04:54:24 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> BACKUP TABLESPACE USERS FORMAT '\/oracle\/BACKUP\/users2.bak';\n \nStarting backup at 29-JUN-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=86 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00007 name=+DG_DATA\/CORTEXDR\/DATAFILE\/users.260.1066479853\nchannel ORA_DISK_1: starting piece 1 at 29-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 29-JUN-21\npiece handle=\/oracle\/BACKUP\/users2.bak tag=TAG20210629T045446 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 29-JUN-21\n \nStarting Control File and SPFILE Autobackup at 29-JUN-21\npiece handle=+DG_FRA\/CORTEXDR\/AUTOBACKUP\/2021_06_29\/s_1076475239.275.1076475293 comment=NONE\nFinished Control File and SPFILE Autobackup at 29-JUN-21\n \nRMAN>\n<\/pre><\/div>\n\n