Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Now you have a chance to edit the standby database init parameters from in pfile stored in  /u02/app/oracle/dbvisit_backup/initMEGA.ora - for example memory allocation, etc ...

...

Code Block
...
...

Starting recover at 29-AUG-23
using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:00
Finished recover at 29-AUG-23

RMAN>

3. Standby database creation is now complete

RMAN has started the standby database in mount standby mode which is correct for Dbvisit Standby to continue. 

...

3. Create corresponding configuration in dbvcontrol GUI

Now you can create the DDC file in the dbvcontrol GUI (in detail described in: Create Oracle Configuration ):

...

Once created, DDC in the dashboard will look like so:

...

4. Backup & send archivelog to verify that standby database can be correctly recovered.

We need to perform this via command line. On primary run:

...

Code Block
[oracle@czlin0212 oracle]$ /usr/dbvisit/standbymp/oracle/dbvctl -d MEGA
=============================================================
Dbvisit Standby Database Technology (11.4.0) (pid 928715)
dbvctl started on czlin0212: Tue Aug 29 13:09:45 2023
=============================================================


>>> Applying Log file(s) from czlin0211 to MEGA on czlin0212:

thread 1 sequence 116 (1_116_1145654994.arc)... done
thread 1 sequence 117 (1_117_1145654994.arc)... done
Last applied log(s):
thread 1 sequence 117

Next SCN required for recovery 135844738 generated at 2023-08-29:12:26:30 +02:00.
Next required log thread 1 sequence 118

=============================================================
dbvctl ended on czlin0212: Tue Aug 29 13:09:48 2023
=============================================================

...

5. Final step is to enable the automated standby update.

On primary run:

Code Block
[oracle@czlin0211 oracle]$ /usr/dbvisit/standbymp/bin/dbvagentmanager auto-update modify --enable --set-interval-seconds 300 --noconfirm

...