In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Main library action master database information standby database information whether to enable redo threads
Alert log
V$thread
Alert log
Show database role, protection mode, protection level, switch status, quick enable, failure conversion information v$databasev$database add and delete redo log filegroup
Alert log
V$log
The status field of v$logfile
Alert log controls the creation of files
Alert log
Alert log
Changes in the state of the tablespace
V$recover_file
Dba_tablespace
Alert log
V$recover_file
Dba_tablespace
Add or delete data files or tablespaces
Dba_data_files
Alert log
V$datafile
Alert log
Rename data file
V$datafile
Alert log
V$datafile
Alert log
Unlogged or unrestored operation
V$datafile
V$database
Alert log
Monitor redo transmission
V$archive_dest_status
V$archived_log
V$archived_dest
Alert log
V$archived_log
Alert log
Issue open resetlogs or clear unarchived logfiles statements
Alert log
Alert log
Modify initialization parameters
Alert log
Alert log
Use the following statement to obtain the current role, protection mode, protection level, switch status, quick enable, and failure transition information of the master and slave database.
Select protection_mode, protection_level, database_role role, switchover_status from v$database
Get fast-start failover statu
Select fs_failover_status "fsfo status", fs_failover_current_target target, fs_failover_threshold threshold, fs_failover_observer_present "observer present" from v$database
Get the redo application and transfer status on the physical repository
Select process, status, thread#, sequence#, block#, blocks from v$managed_standby
Query archive log file information and historical archive information
Select thread#, sequence#, first_change#, next_change# from vested archived logon select thread#, sequence#, first_change#, next_change# from v$log_history
View event information about DG written to alert log
Select message from v$dataguard_status
Check the status of the transfer of the main library redo log to the target side, and SCN represents the system change number of the last redo log applied on the standby library.
Select dest_id, applied_scn from v$archive_dest where target='standby'
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 300
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.