主页 / user-185791

lear1's questions

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

使用命令同时修补 GI Home 和 DB Home 后：

.oraenv
+ASM1
opatchauto apply /patchlocation

我应该从 DB home 还是 GI home 运行 ./datapatch？或者不管来自哪个家庭？谢谢

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

D B：

Oracle RAC Database Release 11.2.0.4.0

我想缩小 SYS.AUD$ 表。一些记录被删除，但表仍有大约 25GB。我读到有必要使用 dbms_audit_mgmt 包将 AUD$ 段移动到另一个表空间。

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

然后：

alter table sys.aud$ enable row movement;

alter table sys.aud$ shrink space cascade;

alter table sys.aud$ disable row movement;

我的问题是：

  1. 这个“dbms_audit_mgmt.set_audit_trail_location”是在线操作吗？
  2. 之后，我应该将 aud$ 表移回 SYSTEM 表空间吗？

感谢你们

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

系统：

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

数据库：

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

补丁

OPatch Version: 12.2.0.1.21

我发现，GRID/DB home 中的 .patch_storage 文件夹在文件系统上占用了很多空间。我尝试使用 opatch util cleanup 实用程序（此实用程序应该清理此文件夹）但没有任何反应。这是输出：

[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

日志输出：

[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 :

这是一个错误吗？还是我做错了什么？最新版本的 opatch 是否不再支持此命令？感谢你们

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

NetBackup 每天备份一次数据库（下午 6 点完全备份到磁带 + 每天 3/4 倍的日志备份）。数据库处于完全恢复模式。应用程序供应商具有远程访问权限，他将自己的完整备份安排到文件系统（在午夜，可能直接在应用程序中）。

POINT IN TIME恢复会有问题吗？他的备份是否打破了我们的链条？

在这张图片中，黄色是供应商对文件系统的完整备份。感谢你们

在此处输入图像描述

sql-server sql-server-2008