log_archive_dest_n和standby_archive_dest-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

log_archive_dest_n和standby_archive_dest

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:58 PM

archive log standby Check

今天查看资料，对log_archive_dest_n和standby_archive_dest的关系有点模糊了，做个简单的测试，缕清关系、加深记忆。首先看一下我们的实验环境，10grac，双节点:node1和node2 SQL host hostnamenode1SQL select * from v$version;BANNER------------------

今天查看资料，对log_archive_dest_n和standby_archive_dest的关系有点模糊了，做个简单的测试，缕清关系、加深记忆。

首先看一下我们的实验环境，10grac，双节点:node1和node2

SQL> host hostname
node1
 
SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0  Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
 
SQL> show parameter archvie;
SQL> show parameter archvie
SQL> show parameter archive
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target           integer     0
log_archive_config           string
log_archive_dest             string
log_archive_dest_1           string  location=/home/oracle/11
log_archive_dest_10          string
log_archive_dest_2           string  service=racdb2
log_archive_dest_3           string
log_archive_dest_4           string
log_archive_dest_5           string
log_archive_dest_6           string
log_archive_dest_7           string
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8           string
log_archive_dest_9           string
log_archive_dest_state_1         string  enable
log_archive_dest_state_10        string  enable
log_archive_dest_state_2         string  enable
log_archive_dest_state_3         string  enable
log_archive_dest_state_4         string  enable
log_archive_dest_state_5         string  enable
log_archive_dest_state_6         string  enable
log_archive_dest_state_7         string  enable
log_archive_dest_state_8         string  enable
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9         string  enable
log_archive_duplex_dest          string
log_archive_format           string  %t_%s_%r.dbf
log_archive_local_first          boolean     TRUE
log_archive_max_processes        integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start            boolean     FALSE
log_archive_trace            integer     0
remote_archive_enable            string  true
standby_archive_dest             string  ?/dbs/arch

Copy after login

SQL> host clear
 
SQL> host hostname
node2
 
SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0  Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
 
SQL> show parameter archive
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target           integer     0
log_archive_config           string
log_archive_dest             string
log_archive_dest_1           string  location=/home/oracle/21
log_archive_dest_10          string
log_archive_dest_2           string  service=racdb1
log_archive_dest_3           string  LOCATION=/home/oracle/22 VALID
                         _FOR=(standby_logfiles, all_ro
                         les)
log_archive_dest_4           string
log_archive_dest_5           string
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_6           string
log_archive_dest_7           string
log_archive_dest_8           string
log_archive_dest_9           string
log_archive_dest_state_1         string  enable
log_archive_dest_state_10        string  enable
log_archive_dest_state_2         string  enable
log_archive_dest_state_3         string  enable
log_archive_dest_state_4         string  enable
log_archive_dest_state_5         string  enable
log_archive_dest_state_6         string  enable
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_7         string  enable
log_archive_dest_state_8         string  enable
log_archive_dest_state_9         string  enable
log_archive_duplex_dest          string
log_archive_format           string  %t_%s_%r.dbf
log_archive_local_first          boolean     TRUE
log_archive_max_processes        integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start            boolean     FALSE
log_archive_trace            integer     0
remote_archive_enable            string  true
 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest             string  ?/dbs/arch

Copy after login

在node1下执行如下命令：alter system archive log current;

SQL> alter system archive log current;
 
System altered.
 
SQL>

Copy after login

在节点2下，查看

[oracle@node2 ~]$ cd 22
[oracle@node2 22]$ ll
total 852
-rw-r----- 1 oracle oinstall 854528 Jul  7 15:09 1_70_790532232.dbf
-rw-r----- 1 oracle oinstall   8704 Jul  7 15:11 1_71_790532232.dbf
[oracle@node2 22]$ cd ..
[oracle@node2 ~]$ cd 21
[oracle@node2 21]$ ll
total 836
-rw-r----- 1 oracle oinstall 846848 Jul  7 15:09 2_52_790532232.dbf
-rw-r----- 1 oracle oinstall   3072 Jul  7 15:11 2_53_790532232.dbf
[oracle@node2 21]$ cd $ORACLE_HOME/dbs
[oracle@node2 dbs]$ ll
total 44
-rw-rw---- 1 oracle oinstall  1552 Jul  7 15:07 hc_racdb2.dat
-rw-r----- 1 oracle oinstall 12920 May  3  2001 initdw.ora
-rw-r----- 1 oracle oinstall  8385 Sep 11  1998 init.ora
-rw-r----- 1 oracle oinstall    24 Aug  5  2012 initracdb2.ora
-rw-r----- 1 oracle oinstall  1536 Aug  5  2012 orapwracdb2
-rw-r----- 1 oracle oinstall  1536 Jul  7 15:07 spfileracdb2.ora

Copy after login

在节点2上设置standby_archvie_dest

SQL> alter system set standby_archive_dest=&#39;/home/oracle/33&#39; sid=&#39;racdb2&#39;;
 
System altered.

Copy after login

在节点1，归档

SQL> alter system archive log current;
 
System altered.

Copy after login

查看节点2

[oracle@node2 ~]$ cd 33
[oracle@node2 33]$ ll
total 4
-rw-r----- 1 oracle oinstall 2048 Jul  7 15:14 1_72_790532232.dbf
[oracle@node2 33]$ cd ../22
[oracle@node2 22]$ ll
total 852
-rw-r----- 1 oracle oinstall 854528 Jul  7 15:09 1_70_790532232.dbf
-rw-r----- 1 oracle oinstall   8704 Jul  7 15:11 1_71_790532232.dbf
[oracle@node2 22]$

Copy after login

结论：

在没有设置standby_archvie_Dest的情况下，数据库会将归档放置在standby数据库的log_Archive_dest_n指定的目录下，如果指定了STANDBY_ARCHIVE_DEST则存放在standby_archive_Dest指定的目录下。

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055523 fails to install in Windows 11?

3 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

3 weeks ago By DDD

Strength Levels for Every Enemy & Monster in R.E.P.O.

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Roblox: Dead Rails - How To Tame Wolves

3 weeks ago By DDD

Roblox: Grow A Garden - Complete Mutation Guide

2 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1655

CakePHP Tutorial

1413

Laravel Tutorial

1306

PHP Tutorial

1252

C# Tutorial

1226

Related knowledge

Check out the steps to delete a logged-in device on Douyin Mar 26, 2024 am 09:01 AM

1. First, click to open the Douyin app and click [Me]. 2. Click the three-dot icon in the upper right corner. 3. Click to enter [Settings]. 4. Click to open [Account and Security]. 5. Select and click [Log in to device management]. 6. Finally, click to select the device and click [Remove].

How to easily check the installed version of Oracle Mar 07, 2024 am 11:27 AM

How to easily check the installed version of Oracle requires specific code examples. As a software widely used in enterprise-level database management systems, the Oracle database has many versions and different installation methods. In our daily work, we often need to check the installed version of the Oracle database for corresponding operations and maintenance. This article will introduce how to easily check the installed version of Oracle and give specific code examples. Method 1: Through SQL query in the Oracle database, we can

Where to check music rankings on NetEase Cloud Music_How to check music rankings on NetEase Cloud Music Mar 25, 2024 am 11:40 AM

1. After turning on the phone, select NetEase Cloud Music. 2. After entering the homepage, you can see the [Ranking List] and click to enter. 3. In the ranking list, you can select any list and click [New Song List]. 4. Select your favorite song and click on it. 5. Return to the previous page to see more lists.

How to check your own ID on Xianyu_Introduction to how to check your personal nickname on Xianyu Mar 22, 2024 am 08:21 AM

As a trading platform, Xianyu requires you to register and log in to your account before using it. Users can set an ID name for their account. What if they want to check what their ID is? Let’s find out together below! Introduction to how to view personal nicknames on Xianyu. First, start the Xianyu app. After entering the homepage, switch to the page of selling idle, messages, and me, and click the [My] option in the lower right corner. 2. Then on my page we need to click [Avatar] in the upper left corner; 2. Then when we go to the personal homepage page we can see different information, we need to click the [Edit Information] button here; 4. Finally click We can see it later on the page where we edit information;

How to view the hot list of Kuaishou Live Companion videos Mar 29, 2024 pm 08:09 PM

Kuaishou Live Companion is not only a powerful live broadcast auxiliary tool, but also a real-time insight platform for hot topics and trends created for broadcasters. Through this function, anchors can quickly capture the content that audiences are most concerned about, and then adjust the live content to make it more in line with the audience's tastes and interests. So how to check the hot video list in the Kuaishou Live Companion app? This tutorial guide will provide you with a detailed introduction to the steps. I hope it can help you. How to view the hot video list on Kuaishou Live Companion? The second step is to click on the daily video hot list. The third step is to check the daily video hot list.

How to check how many groups you have joined on WeChat: a simple step Mar 26, 2024 am 10:06 AM

Regardless of life or work, many people have long been deeply tied to WeChat and will be pulled into various groups at any time. So how many WeChat groups have you joined? You may immediately want to view the group chats in your address book, but only the WeChat groups you have saved in your address book will appear there, and other groups will not be visible. If you want to see all the WeChat groups you have joined, it is very simple: enter your nickname in the search box on the WeChat homepage, then find the group chat section in the search results, and click "More Group Chats" to view all related group chat information. Anyway, I was shocked. There were more than a hundred of them, and the scroll bar on the right became very small. Unfortunately, there is no specific number statistics... This method is also applicable to checking the QQ groups you have joined. PS: Some netizens also provided a trick:

How do I check which groups I have joined? Apr 01, 2024 pm 05:34 PM

WeChat group chat is not only a simple chat platform, but also a communication circle that brings together elites and enthusiastic friends from all walks of life. So today I will teach you how to see how many groups you have added on WeChat and how to save group chats. Usually Users who use WeChat must not miss it. How to check how many groups you have added to WeChat and how to save group chats To check how many groups you have added to WeChat: 1. You can view your group chat window in the WeChat main interface 2. If you have already saved the group chat, you can tap [ Address Book] - [Group Chat] 3. After entering the group chat, you can view the saved group. Save the WeChat group: 1. Select the group you want to save, top right [...] 2. Open in the chat message [Save to address book] 3. On the main WeChat interface, tap [Address Book]-[Group Chat] to view

How to view the Amap Help Center_How to view the Amap Help Center Apr 01, 2024 pm 05:26 PM

1. We first open the Gaode map. 2. Then click (My) in the lower right corner of the Amap homepage and then click Settings in the upper right corner. 3. Finally, you can see the help center of Amap.

See all articles