2025. 11. 10. 15:56 오라클

ORA-00392 에러조치


Clone 해서 Retore/Recover 하다가 건드려서 상태 이상해 졌을 떄 복구 방법..

RMAN> ALTER DATABASE OPEN RESETLOGS;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 11/10/2025 15:30:19
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1: '/oradata/TEST/redo01.log'

SQL> select GROUP#,THREAD#,SEQUENCE#,MEMBERS,ARCHIVED,STATUS,FIRST_CHANGE# from v$log order by first_change# ;

    GROUP#    THREAD#  SEQUENCE#    MEMBERS ARC STATUS           FIRST_CHANGE#
---------- ---------- ---------- ---------- --- ---------------- -------------
         6          1          0          1 YES UNUSED                       0
         4          1          0          1 YES UNUSED                       0
         5          1          0          1 YES UNUSED                       0
         1          1          0          1 NO  CLEARING_CURRENT       1901592
 

방법 1) 이걸로 되면 Happy 하게 작업완료
SQL> alter database clear unarchived logfile group 1 ;
SQL> alter database clear unarchived logfile group 2 ;
SQL> alter database clear unarchived logfile group 3 ;
SQL> alter database open resetlogs;

하지만 방법1로 안될시 방법2)

1.  RESETLOGS 옵션과 함께 Contolfile 재생성
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/control.sql' resetlogs ;

2. 편집해서 Online Redo log 생성위치 바르게 수정반영 후 저장
vi /tmp/control.sql

 GROUP 1 '/oradata/TEST/redo01.log'  SIZE 100M BLOCKSIZE 512 <--- old 위치 또는 잘못된 위치 제거

3. nomount 로 기동

SQL> STARTUP FORCE NOMOUNT
SQL> @/tmp/control.sql

4. 가짜로 복구시도

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL ;

5. RESETLOGS 로 OPEN
SQL> ALTER DATABASE OPEN RESETLOGS ;

Posted by pat98

오라클 EM 은 과연 무료인가?

결론부터 말하면 무료이다.

 

(좀더 정확하게는 EM 에는 Repository DB 와만 함께 사용할수 있수 있는 제한된 사용 라이센스가 포함되어 있다고 한다. 하지만 EM이 Targeting 하게 되는 대상을 모니터링 하거나 튜닝작업을 하게 되면 이에 상응하는 라이센스가 필요하다.)

 

EM 관련한 라이센스 정책이 세분화 되어 있어 EM내에 포함된 라이센스 정보를 찾아보았다. (왜 이런지는 모르겠지만 EM 메뉴내에 아주 꼼꼼히 숨겨놓았다 -_-;) 

 

- 관련 MOS 문서

EM 12c, EM 13c: Does the Cloud Control Repository Database Require Additional Oracle Database License? (Doc ID 2337138.1)

 

- Enterprise Manager Cloud Control 라이센스 문서 URL

 

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/oemli/introduction-oracle-enterprise-manager-licensing.html#GUID-7B2095D3-4E88-4346-9566-638219FF1130

=======================================================================

내용 발췌...

 

Oracle Enterprise Manager Restricted-use License

  Oracle Enterprise Manager includes a restricted-use license of the Oracle Database Enterprise Edition for use only with the Oracle Management Repository as well as with the following complementary repositories used by Oracle Enterprise Manager: Always-on Monitoring Repository, AWR Warehouse, Ops Center, Real User Experience Insight, Load Testing, and Test Manager.

Any use of Oracle Database options by Oracle Enterprise Manager's SYSMAN schema is included with the restricted-use license and does not require a separate license.

Additional database options or additional servers for disaster recovery require separate licensing. Customers receive one single-nstance database with the Cloud Control, or RMAN, repository. To protect the repository with Data Guard, customers need to purchase a license for the standby site. To protect the repository with Oracle Real Application Clusters, customers must license the second node for the database, and both nodes require an Oracle Real Application Clusters license.

  Oracle Enterprise Manager includes a restricted-se license of the Oracle WebLogic Server for use with Oracle Enterprise Manager functions and interfaces only.

  A restricted-se license for WebLogic clustering is included to support the deployment of a cluster of Oracle Analytics Servers, only when used with Oracle Enterprise Manager.

Oracle Enterprise Manager includes restricted use of Oracle Analytics Server and Oracle Analytics Server for mobile web for use with Oracle Enterprise Manager functions and interfaces only. This restricted Oracle Analytics Sever license will allow reporting only against the Oracle Enterprise Manager repository and against data dictionary (including AWR and AWR Warehousing data) of target databases. The restricted-use license covers the monitoring of the FMW domain of OAS through Oracle Enterprise Manager. In order to report against other data sources, it is necessary to have Oracle Analytics Server license.

=======================================================================

 

- EM 에 접속해서 

Setup ->  Management Packs -> Management Packs Access 메뉴로 가면 해당되는 라이센스를 활성화/비활성화 할수 있다.

 

 

또한 세부적인 기능에 대한 내용은 

Setup ->  Management Packs -> License Information  메뉴로 가면 아래와 같이 해당 내용을 확인 할수 있다.

 

Licensing Information

Enterprise Manager provides central management and monitoring for your data center. Some premium functionality contained within this release is part of management packs that require separate Oracle license. These management packs are outlined below.

 

Abbreviation Pack Name Description
AMPFA Application Management Pack for Fusion Applications Application Management Pack for Fusion Applications provides comprehensive management capabilities to monitor and manage Oracle Fusion Applications.
CMDB Oracle Cloud Management Pack for Oracle Database Oracle Cloud Management Pack for Oracle Database helps enable a DevOps model of database management by creating on-demand database provisioning and management within your Hybrid Multicloud environment.
Out-of-box Self Service Portal for self-service users to access Cloud services.
Self-service database provisioning support on physical, virtual, Engineered Systems, an
    d Oracle Compute Cloud Service.

Deployment of Database-as-a-Service (DBaaS) and Pluggable Database-as-a-Service 
    (PDBaaS) models.

Data Refresh for Full Clones - the ability to refresh the data contained in full clones. Not
    e: Create 'new' full clones is licensed under DBLM, but the additional 'refresh' function
    requires CMP.

Create snap clones of source databases, including the ability to refresh the database.
Snap Clone using TestMaster Snapshots.
Grouping of Cloud Infrastructure under the umbrella of 'paas zone' and creation of Hom
     ogeneous Cloud Pool(s).

Resource control through quotas and retirement policies
Chargeback and Metering based on database utilization
Programmatic access to the Self Service Portal through REST APIs and EMCLIs.
CMPA Configuration Management Pack for Applications Automates the time-consuming and often error prone process of software and hardware configuration and deployments on systems not running Oracle software. This pack provides capabilities such as search and compare across all systems, configuration monitoring, policy management and compliance support, security configuration scoring and dashboards, and comprehensive reporting. The Configuration Management Pack includes:
 View and analyze configuration
 View and analyze deployments/installations
 Search configuration
 • Compare configurations And Drift Management
 Client System Analyzer
 Manage policies and policy notifications
 Security at a Glance
 Configuration reports
 Configuration change tracking
 Real time change detection
 Manage Application configuration across the deployment lifecycle
 Repository tables/views that store/expose the above data
COHMP Management Pack for Oracle Coherence Provides a comprehensive solution for monitoring, configuring, and deploying a Coherence cluster. This pack simplifies management of the Coherence clusters by providing automatic discovery of an entire cluster and all its components such as nodes, services, caches, connections, and connection managers. The Management Pack for Oracle Coherence includes:
Topology views showing target associations, highlighting dependencies and performanc
    e hotspots

Customizable performance views with advanced features such as overlays, time select
    or, etc. - create and save your own charts set

Proactive monitoring using performance Alerts and notifications
Monitor log alerts in context of a node
Centralized query based cache data management for important operations such as vie
    w, import, export, purge, etc.

Complete cluster provisioning with node update capabilities
Enhanced caches and nodes monitoring for reap sessions, transactional caches, push r
    eplication, etc.

Advanced configuration management with runtime configuration change capabilities
DBLM Oracle Database Lifecycle Management Pack Compliance management
Configuration management
Fleet Maintenance
Fleet Maintenance Hub
Integration of Fleet Patching and Provision with Fleet Maintenance
Exadata Engineered System Compliance with AHF EXAchk
Provisioning: Ability to provision single instance, RAC, and Multitenant databases
Cloning: Clone to create a copy of an existing single instance, RAC, and Multitenant dat
   abase

Database Change Management: End-to-end management of schemas and data change
   s

Inventory tracking: Ability to track inventory utilization and growth over a period of time
DD Database Diagnostics Pack Offers a complete, cost-effective, and easy to use solution for managing the performance of Oracle Database environments by providing unique functionality such as automatic identification of performance bottlenecks, guided problem resolution, and comprehensive system monitoring. The Diagnostics Pack includes:
Historical performance monitoring and trending (Database, RAC, Host and Cluster target)
RAC/Cluster Interconnect monitoring
ADDM (Automated Database Diagnostic Monitor)
Automatic Workload Repository
Event/Alert Notifications: Notification Methods, Rules and Schedules
Event/Alert history/metric history (Database, RAC, Host and Cluster target)
User-defined metrics
Blackouts/Planned Outages
Monitoring templates
Corrective actions (including response actions)
Memory Access Mode
Diagnostic, Performance and Event reports
Database and repository tables/views/api's that store/expose the above data
Database and Host Consolidation Planner
Automatic Workload Repository (AWR) Warehouse
DMS Oracle Data Masking and Subsetting Pack Oracle Data Masking and Subsetting (DMS) Pack for Oracle and non-Oracle Databases.
DMS helps to model, subset and mask Databases. This pack includes the following components and features:

Application Data Modeling (ADM)
ADM helps to automatically discover columns with sensitive data in Oracle Database.

Data Masking Format Library
Data Masking Definitions
Help to define, generate and execute masking rules by leveraging ADMs, data masking formats, primitives and templates (available for select versions of E-business suite and Fusion Applications).

Data Subsetting Definitions
Help to define, generate and execute subsetting rules by leveraging ADMs and data masking definitions.
DNOM Management Pack for Non-Oracle Middleware Offers a complete, cost-effective, and easy to use solution for managing the performance of non-Oracle middleware environments and applications running on them, by providing unique functionality such as low overhead in-flight monitoring of all Java activity, memory leak analysis, end-to-end tracing of java requests to Oracle database activity, and comprehensive system monitoring. It also includes:
Real-time monitoring of JVM provides a summary view of resource bottlenecks affecting performance, such as the database, I/O, CPU, and locks.
Trace in-flight transactions to view request performance problems in real time. Analyze time spent in each resource bottleneck (extend to each Java method).
DT Database Tuning Pack Offers a set of new, groundbreaking technologies that automate the entire application tuning process, thereby significantly lowering database management costs while enhancing performance and reliability. The Tuning Pack includes:
SQL Access Advisor
SQL Tuning Advisor
SQL Tuning Sets
Reorganize Objects
Note: Tuning Pack requires license for Diagnostics Pack for Oracle Database.
EXMP Exadata Management Pack The Exadata Management Pack offers advanced fleet-level Exadata management, monitoring, patching, performance analysis, and capacity analysis functionality, including:
Exadata Database Impact Advisor
Exadata I/O Resource Management Advisor
Exadata Exascale Advanced Performance Monitoring
Exadata Cloud Advanced Performance Monitoring
Exadata Infrastructure Patching using Fleet Maintenance
•  Advanced Dashboards for Capacity, Inventory, and Performance Analysis
Autonomous Health Framework (AHF) Management
IDM Management Pack Plus for Identity Management Enables enterprises to proactively monitor the availability, performance, load, and security metrics of Identity Management deployments. The pack includes:
Monitor the Identity Management environment from both a systems-oriented view and an end-user perspective. Out-of-box collection of key performance metrics for monitored components facilitates rapid time to value. This enables administrators to set up alerts based on warning and critical thresholds, view current and historical performance information using graphs and reports, and diagnose performance problems by identifying bottlenecks in any of the monitored targets. Administrators can also monitor the Identity Management environment from an end-user perspective using synthetic service tests. These tests simulate key end-user activities, such as logging into an application with single sign-on. The tests are run through beacons from locations within the enterprise network to actively measure the performance and availability of Identity and Access services.
Model Identity and Access services down to the key components they rely on, define service levels based on business requirements, and report against clearly defined Service Level Objectives (SLOs).
Track configuration metrics, take configuration snapshots, and compare configurations for Oracle Access Manager components, as well as Oracle Internet Directory, Oracle Directory Integration Platform, Oracle Virtual Directory, and Oracle Identity Federation.
Please refer to the EM licensing documentation for the features licensed for WebLogic-based containers included in the Identity Management product restricted-use licensing that are licensed and managed by the Management Pack Plus for Identity Management.
MPWCS Oracle WebCenter Portal Management Pack The Oracle WebCenter Portal Management Pack provides monitoring and management for the WebCenter Content: Server, WebCenter Portal: Spaces, WebCenter Portal: Services, and WebCenter Portal: Framework. The Oracle WebCenter Portal Management Pack includes:
Availability and monitoring of all components
Performance monitoring of all components
Historical analysis and reporting
Thresholds and events
Dashboard monitoring
OBIM Oracle BI Management Pack Provides monitoring and management of Oracle BI and OAS Components (Presentation Server, Cluster Controller, Analytics Server, Scheduler and DAC Server). The Oracle BI Management Pack includes:
Availability and monitoring of all components
Process control
Dashboard monitoring
Configuration Management
SLM Service Level Management Pack Delivers functionality to actively monitor and report on availability and performance of critical applications (services and web applications), sites, and infrastructure components using synthetic transactions executed from remote sites (beacons). The Service Level Management Pack includes:
Automated creation of system and service for deployed applications
Change tracking history of system membership
Service availability, performance and usage tests (for all test types)
Beacons for running tests
Service Level Rules
Service Monitoring: Historical performance and Events/Alerts
Metric Snapshots
Metric Baselines
Monitoring Templates
Monitor Forms application availability, performance, usage, and service level compliance
Service Level Reports
Repository tables/views that store/expose the above data
SOAM SOA Management Pack EE Delivers comprehensive management capabilities for a SOA environment. Enterprise Manager makes it easy for the IT administrator to manage SOA runtime environments by discovering Oracle SOA Suite, Oracle BPEL Processes and Oracle Service Bus instances.
The SOA Management Pack EE includes:
Centralized Management Console
Discovery and Service Modeling
Oracle SOA Suite Infrastructure
Oracle SOA Suite Composite
Oracle BPEL Process Manager
Oracle BPEL Processes
Oracle BPEL Partner Links
Oracle Service Bus
Oracle Service Bus Business Services
Oracle Service Bus Proxy Services
Web Services Monitoring
SOAP Tests
Request-Based Monitoring
End Point URI Monitoring
Proxy Service Flow
Infrastructure Management
Application Server
Dehydration Store
Business-IT Alignment
BAM-EM integration
Service Level Management for BPEL Business Processes and Partner Links
SOA Diagnostics
Fault Management
Fault Search
Fault Recovery
Error Hospital Integration
SOA Instance Tracing
Dehydration Store Monitoring
Historical Analysis and Reporting
Performance Monitoring
Thresholds and Metrics
Event/Alert Notifications
WLSEE WLS Management Pack EE WebLogic Server Management Pack Enterprise Edition provides comprehensive management capabilities for Oracle Fusion Middleware, Oracle WebLogic Server, Oracle GlassFish Server, and Oracle Application Server environments. This pack also includes Oracle Coherence and Oracle Exalogic Elastic Cloud engineered systems management. Key functional areas provided by this pack include:

Performance Management and Diagnostics that enable you to:

Track availability and performance data over time
Receive notifications of potential problems
Suspend monitoring during scheduled maintenance periods
Gain real-time visibility into a JVM and application state without instrumentation overhead
View response time breakdowns in each layer of a JVM (servlet, JSP, EJB, JDBC, SQL)
Isolate problems between Java and the database
View the impact of database problems on all associated applications and JVMs
Discover, record and correlate transactions as they flow across components
Search and monitor across log files for messages
Service Level Management that enables you to:
Measure availability and performance from representative key user locations
Monitor service availability, performance, usage and service level compliance
Model critical business functions based on a wide range of supported protocols
Lifecycle Management that enables you to:
Manage configurations via comparisons, change tracking, synchronizations, and compliance rules
Clone a WebLogic Domain or scale out a WebLogic Cluster (12c)
Deploy a Java EE application
Receive patch recommendations from My Oracle Support
Apply patches to multiple WebLogic Domains
Perform disaster recovery operations such as site failover or switchover
Posted by pat98

11-27 06:17
Flag Counter
Yesterday
Today
Total

글 보관함

최근에 올라온 글

달력

 « |  » 2025.11
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30

최근에 달린 댓글