DataGuard - MSN Tutorial

xiaoxiao2021-03-06  82

You said: very simple

You said: especially after using RMAN

Catherine (in Beijing): How to do it now?

You said: First stop the database of Standby last night.

Catherine (in Beijing): OK

You said: Stop?

Catherine (in Beijing) said: Already finished, how so slowly

You said: shutdown immediate?

Catherine (in Beijing) said: Yes

You said: I haven't stopped yet?

You said: no matter what he is, Shutdown Abort is ok.

You said: Don't do this anyway.

Catherine (in Beijing) said: stop

Catherine (in Beijing) said: What is it now?

You said: Do you want to change REDO to 1M?

Catherine (in Beijing) said: Yes

Catherine (in Beijing): How to change it?

You said: You make a restore first, and change it later.

You said: on Standby

You said: $ oracle_home / bin / rman target /

Catherine (in Beijing): Continue

You said: sorry

You said: First, you want a mount database

You said: Still you have to change Redo first

Catherine (in Beijing) said: It is a change in the main library.

You said: Change Redo to change to Primary

You said:

Catherine (in Beijing) said: How to change, hurry up?

You said: You simply change it with a graphical interface.

You said: Forget it.

You said: Or ordered it.

You said: Waiting for

You said: You first SELECT * FROM V $ log

Catherine (in Beijing) said: Sun Peng's machine service name is not configured, ordered.

You said: SELECT * from V $ logfile;

You said: Look at the current group # and Member

Catherine (in Beijing) said: The current group is 8 you said: It is 8, 9, 10 three.

You said: The line is added 1, 2, 3 groups of 1M

Catherine (in Beijing): Member: /global/oradata/ctsdb/redo08.log

You said: Waiting, I will tell you SQL

Catherine (in Beijing) said: Yes

You said: Alter Database Add logfile group 1 ('/global/oradata/ctsdb/redo01.log') size 1024k

You said: Alter Database Add logfile group 2 ('/global/oradata/ctsdb/redo02.log') size 1024k

You said: Alter Database Add logfile group 3 ('/global/oradata/ctsdb/redo03.log') Size 1024K

You said: This will add three groups.

Catherine (in Beijing) said: add

Catherine (in Beijing) said: then

You said: The three groups have been added?

Catherine (in Beijing) said: Yes

You said: then make ALTER SYSTEM Archive log current;

You said: Let the new Redo become Current, you can delete the old Redo

You said: SELECT Group #, Status from V $ log;

You said: You can see the status of REDO in each group.

Catherine (in Beijing) said: 8 is Active, 9,10 is inactive

You said: another archive

You said:

Catherine (in Beijing) said: 8, 9.10 is inactive

You said: ok

You said: Delete these three groups

You said: ALTER DATABASE DROP Logfile Group 8;

You said: It should be like this.

You said: ALTER DATABASE DROP Logfile Group 9;

You said: ALTER DATABASE DROP Logfile Group 10;

Catherine (in Beijing) said: Delete you said: Ok, we have to create Standby Redo and change it to 1M

You said: It is also 3M.

Catherine (in Beijing) said: But there is group 4, 5, 6, 7 in V $ logfile.

You said: Oh, this is Standby Redo

Catherine (in Beijing): What is it?

Catherine (in Beijing) said: Oh

You said: Primary is in order to prepare the role switch

Catherine (in Beijing) said: Ah, I have to change, 4, 5.6.7 is changed to 1M?

You said: In fact, Standby Redo only needs to be on Standby.

Catherine (in Beijing): o

You said: These can remove and then recreate

Catherine (in Beijing) said: Can you do it today?

You said:

You said: Anyway, STANDBY is also used there.

Catherine (in Beijing) said: Then delete it first?

You said: ALTER DATABASE DROP Standby Logfile Group 4;

You said: Add a Standby in the grammat

Catherine (in Beijing) said: all deleted, then how to add

You said: Alter Database Add Standby Logfile Group 4 ('/global/oradata/ctsdb/stdby_redo04.log') size 1024k;

You said: the same, that is, add a Standby keyword

You said: Yes, you must first go to the / global / oradata / ctsdb / directory to delete the physical stdby_redo04.log file

You said: First delete the four files from the directory, otherwise the creation should be the existence of the file billion, because the DROP Redo's SQL does not help delete physical files.

Catherine (in Beijing) said: Fortunately, my keyboard is slow.

You said: Nothing is fast, and the most reported is wrong.

Catherine (in Beijing) said:

Catherine (in Beijing) said: Can you restore you: No

Catherine (in Beijing) :(

You said: STANDBY ControlFile now

You said: Alter Database Create Standby ControlFile As '/TMP/s.ctl';

Catherine (in Beijing) said: then

You said: After you finish it, put this /tmp/s.ctl file ftp to Standby.

You said: You can also ftp to the TMP directory, you will have to change your name.

You said: At the same time, FTP is also the new generation of log files.

Catherine (in Beijing): Yes put it in $ oracle_home /

You said: 1, 2, 3, 4, 5, 6, 7

Catherine (in Beijing) said: Is DBS?

You said: No need

You said: You can put all in / global / oradata / ctsdb / below

You said: Isn't it good?

You said: You can take this time, first check the monitoring of Primary and Standby

You said: use lsnrctl status and lsnrctl status listener_dg

You said: To check, if the two listeners on both sides are started.

Catherine (in Beijing) said:

You said: good

You said: You can still recover.

You said: Advanced Standby's SQLPLUS

You said: Is there all of the files you just pass now?

You said: including 1, 2, 3, 4, 5, 6, 7 of these 7 groups of log, there is also a S, CTL

Catherine (in Beijing) said: Yes

You said: Well, change the S.ctl to the normal control file name, overwrite the original

Catherine (in Beijing) said: You can't do it when you demonstrate it.

You said: Should be Control01.ctl, Control02.ctl, Control03.ctl

You said: I will pass forever.

Catherine (in Beijing) said: CP can be

You said:

Catherine (in Beijing) said: Good music you said: into SQLPlus

You said: Startup Nomount;

You said: ALTER DATABASE MOUNT Standby Database;

Catherine (in Beijing) said: Didn't you recover?

You said: Yes

You said: First mount can restore it.

Catherine (in Beijing) said: Ok

Catherine (in Beijing) said: Can I recover now?

You said: Entering RMAN is the initial statement

You said: $ oracle_home / bin / rman target /

You said: Then perform Restore Database;

You said: then wait.

You said: Wait until the end

You said: Execute in SQLPLUS: Alter Database Recover Managed Standby Database Parallel 4 Disconnect from session;

You said: where Parallel 4 can omit

Catherine (in Beijing) said: How long does RESTORE estimates?

You said: Then set the archive_lag_target parameter value to 60 in the peimary side, which is one minute.

You said: 20 minutes is almost

You said: Because this backup is yesterday, it will be completed, and the database is still yesterday.

Catherine (in Beijing) said: That is not consistent with the main library

You said: At this time, you can use the Alertf's AlertLog, you can see that it will automatically get archived to Primary, then recover until the main library is uniform.

Catherine (in Beijing) said: Oh

You said: This is why I said yesterday, I said that I have to build and then make initialization, because this recovery is always time, like this is also transferred in the network today, it may be a long time.

转载请注明原文地址:https://www.9cbs.com/read-121578.html

New Post(0)