Shulou(Shulou.com)05/31 Report--

Editor to share with you oracle 11g how to build physical DG, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

Open the main library and create a new pfile. If there is already a pfile, this command will overwrite the previous pfile and become the latest pfile.

[root@slow ~] # su-oracle

[oracle@slow] $! sql

Sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 9 20:15:45 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 521936896 bytes

Fixed Size 2254824 bytes

Variable Size 377489432 bytes

Database Buffers 138412032 bytes

Redo Buffers 3780608 bytes

Database mounted.

Database opened.

SQL > create pfile from spfile

File created.

SQL >

Go to the path of oracle user $ORACLE_HOME/dbs, view the pifle file you just created, and copy a copy of the pfile file of the prepared library.

[root@slow ~] # su-oracle

[oracle@slow ~] $cd $ORACLE_HOME/dbs

[oracle@slow dbs] $ls

Hc_slow.dat init.ora initslow.ora lkSLOW orapwslow spfileslow.ora

[oracle@slow dbs] $ll

Total 24

-rw-rw---- 1 oracle oinstall 1544 Jan 9 20:15 hc_slow.dat

-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora

-rw-r--r-- 1 oracle oinstall 731 Jan 9 20:16 initslow.ora

-rw-r- 1 oracle oinstall 24 Dec 24 23:10 lkSLOW

-rw-r- 1 oracle oinstall 1536 Dec 24 22:31 orapwslow

-rw-r- 1 oracle oinstall 2560 Jan 9 20:15 spfileslow.ora

[oracle@slow dbs] $cp initslow.ora initgotime.ora

[oracle@slow dbs] $ls

Hc_slow.dat initgotime.ora init.ora initslow.ora lkSLOW orapwslow spfileslow.ora

[oracle@slow dbs] $

These are all the contents of the article "how oracle 11g builds physical DG". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.