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.