Início / user-185791

lear1's questions

Martin Hope
lear1
Asked: 2021-03-15 11:07:12 +0800 CST
  • 0

Depois de corrigir o GI Home e o DB Home simultaneamente usando o comando:

.oraenv
+ASM1
opatchauto apply /patchlocation

Devo executar ./datapatch da casa do DB ou da casa do GI? Ou não importa de qual casa? Obrigado

oracle rac
Martin Hope
lear1
Asked: 2020-11-25 04:20:07 +0800 CST
  • 0

DB:

Oracle RAC Database Release 11.2.0.4.0

Eu quero reduzir a tabela SYS.AUD$. Alguns registros foram deletados mas a tabela ainda tem cerca de 25GB. Li que é necessário mover o segmento AUD$ para outro tablespace usando o pacote dbms_audit_mgmt.

begin
dbms_audit_mgmt.set_audit_trail_location(
audit_trail_type => dbms_audit_mgmt.audit_trail_aud_std,
audit_trail_location_value => 'AUDTBS');
end;

Então:

alter table sys.aud$ enable row movement;

alter table sys.aud$ shrink space cascade;

alter table sys.aud$ disable row movement;

Minhas perguntas são:

  1. Este "dbms_audit_mgmt.set_audit_trail_location" é uma operação ONLINE?
  2. Depois disso, devo mover a tabela aud$ de volta para o espaço de tabela SYSTEM?

Obrigado pessoal

oracle
Martin Hope
lear1
Asked: 2020-09-14 04:56:58 +0800 CST
  • 0

Sistema:

[oracle@hostname:/opt/oraclegrid/18]$ uname -a
SunOS hostname 5.11 11.4.24.75.2 sun4v sparc sun4v

Base de dados:

Oracle 18c 18.10 (April 2020 patch), RacOneNode setup

Opatch

OPatch Version: 12.2.0.1.21

Descobri que uma pasta .patch_storage em casas GRID/DB ocupa muito espaço no sistema de arquivos. Tentei usar o utilitário de limpeza opatch util (este utilitário deve limpar esta pasta), mas nada aconteceu. Aqui está a saída:

[oracle@hostname:/opt/oraclegrid/18]$ du -hs .patch_storage/
 4.1G   .patch_storage
[oracle@hostname:/opt/oraclegrid/18]$ opatch util cleanup
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oraclegrid/18
Central Inventory : /opt/oraInventory
   from           : /opt/oraclegrid/18/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.4.0
Log file location : /opt/oraclegrid/18/cfgtoollogs/opatch/opatch2020-09-13_14-47-13PM_1.log

Invoking utility "cleanup"
OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
You will be still able to rollback patches after this cleanup.
Do you want to proceed? [y|n]
y
User Responded with: Y

Backup area for restore has been cleaned up. For a complete list of files/directories
deleted, Please refer log file.

OPatch succeeded.
[oracle@hostname:/opt/oraclegrid/18]$ du -hs .patch_storage/
 4.1G   .patch_storage

Saída de registro:

[Sep 13, 2020 2:47:14 PM] [INFO]    CUP_LOG: Trying to load HomeOperations object
[Sep 13, 2020 2:47:14 PM] [INFO]    CUP_LOG: HomeOperations provider not available
[Sep 13, 2020 2:47:14 PM] [INFO]    CUP_LOG: This is unusual state. HomeOperations object is null, but it should not be null if HomeOperations create went thru. CUP is not available
[Sep 13, 2020 2:47:14 PM] [INFO]    OPatch invoked as follows: 'util cleanup -invPtrLoc /opt/oraclegrid/18/oraInst.loc '
[Sep 13, 2020 2:47:14 PM] [INFO]    Runtime args: [-Xmx1536m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/opt/oraclegrid/18/cfgtoollogs/opatch, -DCommonLog.LOG_SESSION_ID=, -DCommonLog.COMMAND_NAME=ut
il, -DOPatch.ORACLE_HOME=/opt/oraclegrid/18, -DOPatch.DEBUG=false, -DOPatch.MAKE=false, -DOPatch.RUNNING_DIR=/opt/oracle/18/OPatch, -DOPatch.MW_HOME=, -DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -DO
Patch.OUI_LOCATION=/opt/oraclegrid/18/oui, -DOPatch.FMW_COMPONENT_HOME=, -DOPatch.OPATCH_CLASSPATH=, -DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.SKIP_OUI_VERSION_CHECK=, -DOPatch.NEXTGEN_HOME_CHECK=false, -DOPatc
h.PARALLEL_ON_FMW_OH=]
[Sep 13, 2020 2:47:14 PM] [INFO]    Heap in use : 24 MB
                                    Total memory: 307 MB
                                    Free memory : 282 MB
                                    Max memory  : 1365 MB
[Sep 13, 2020 2:47:14 PM] [INFO]    Oracle Home       : /opt/oraclegrid/18
                                    Central Inventory : /opt/oraInventory
                                       from           : /opt/oraclegrid/18/oraInst.loc
                                    OPatch version    : 12.2.0.1.21
                                    OUI version       : 12.2.0.4.0
                                    OUI location      : /opt/oraclegrid/18/oui
                                    Log file location : /opt/oraclegrid/18/cfgtoollogs/opatch/opatch2020-09-13_14-47-13PM_1.log
[Sep 13, 2020 2:47:14 PM] [INFO]    Patch history file: /opt/oraclegrid/18/cfgtoollogs/opatch/opatch_history.txt
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-TIME] Loading raw inventory
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 54 (MB)
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 54 (MB)
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-TIME] Raw inventory loaded successfully
[Sep 13, 2020 2:47:16 PM] [INFO]    Invoking utility "cleanup"
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-TIME] Cleaning up backup
[Sep 13, 2020 2:47:16 PM] [INFO]    OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
                                    You will be still able to rollback patches after this cleanup.
                                    Do you want to proceed? [y|n]
[Sep 13, 2020 2:47:16 PM] [INFO]    Start to wait for user-input at Sun Sep 13 14:47:16 CEST 2020
[Sep 13, 2020 2:47:19 PM] [INFO]    Finish waiting for user-input at Sun Sep 13 14:47:19 CEST 2020
[Sep 13, 2020 2:47:19 PM] [INFO]    User Responded with: Y
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :

Isso é um inseto? Ou estou fazendo algo errado? Este comando não é mais suportado nas versões mais recentes do opatch? Obrigado pessoal

oracle rac
Martin Hope
lear1
Asked: 2020-04-21 05:11:33 +0800 CST
  • 1

Há um banco de dados com backup do NetBackup uma vez por dia (backup completo às 18h para fita + backup de log 3/4x por dia). O banco de dados está no modo de recuperação COMPLETO. O fornecedor do aplicativo tem acesso remoto e agendou seu próprio backup COMPLETO para o sistema de arquivos (à meia-noite, provavelmente diretamente no aplicativo).

Haveria algum problema com a recuperação POINT IN TIME? O backup dele quebrou nossa corrente?

Nesta imagem, amarelo são os backups COMPLETOS do fornecedor para o sistema de arquivos. Obrigado pessoal

insira a descrição da imagem aqui

sql-server sql-server-2008