DataGuard configuration step by step

xiaoxiao2021-03-06  121

LINK:

http://www.eygle.com/ha/dataguard-step-book-step.htm

1. Main node back up and generate alternate database control files

Set the primary node for Force Logging mode (for two-way switching, it is recommended to set it to Force Logging mode) alter database force logging;

Set the primary node as archiving mode

Log in to the main node, perform database backup, and generate alternate database control files

Last Login: Mon Aug 9 16:46:47 2004 from 172.16.32.65

[root @ standardby root] # su - oracle

[Oracle @ Standby Oracle] $ SQLPLUS "/ as sysdba"

SQL * Plus: Release 9.2.0.4.0 - Production on Mon Aug 16 10:16:18 2004

CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.

Connected to an iDLE Instance.

SQL> Startup

Oracle Instance Started.

Total System Global Area 135337420 Bytes

Fixed Size 452044 BYTES

Variable size 109051904 bytes

Database buffers 25165824 BYTES

Redo buffers 667648 bytes

Database mounted.

Database opened.

SQL> SELECT NAME FROM V $ datafile;

Name

-------------------------------------------------- ------------

/opt/oracle/oradata/primary/system01.dbf

/opt/oracle/oradata/primary/undotbs01.dbf

/opt/oracle/oradata/primary/Users01.dbf

SQL> Shutdown Immediate

Database closed.

Database dismount.

Oracle Instance Shut Down.

SQL> EXIT

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

WITH THE PartInog Option

JServer Release 9.2.0.4.0 - Production

[Oracle @ Standby Oracle] $ LS

Admin Dictionary.ora Jre ORADATA ORAINVENTORY OUI Product Soft

[Oracle @ Standby Oracle] $ tar -cvf ORADATA.TAR ORADATA

ORADATA /

ORADATA / PRIMARY /

ORADATA / PRIMARY / ARCHIVE /

ORADATA / PRIMARY / Control01.ctl

OraData / Primary / Control02.ctl

ORADATA / PRIMARY / Control03.ctl

ORADATA / PRIMARY / Redo01.log

OraData / primary / redo02.log

ORADATA / PRIMARY / Redo03.log

ORADATA / PRIMARY / System01.dbf

ORADATA / PRIMARY / undotbs01.dbforadata / primary / temp01.dbf

ORADATA / PRIMARY / USERS01.DBF

[Oracle @ Standby Oracle] $ ls -l * .tar

-rw-r - r - 1 Oracle DBA 576512000 AUG 16 10:22 ORADATA.TAR

[Oracle @ Standby Oracle] $ ID

UID = 800 (ORACLE) GID = 800 (DBA) Groups = 800 (DBA)

[Oracle @ Standby Oracle] $ Hostname

STANDBY

[Oracle @ Standby Oracle] $ SQLPLUS "/ as sysdba"

SQL * Plus: Release 9.2.0.4.0 - Production ON MON AUG 16 10:27:54 2004

CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.

Connected to an iDLE Instance.

SQL> Startup

Oracle Instance Started.

Total System Global Area 135337420 Bytes

Fixed Size 452044 BYTES

Variable size 109051904 bytes

Database buffers 25165824 BYTES

Redo buffers 667648 bytes

Database mounted.

Database opened.

SQL> Archive Log List;

Database log mode archive mode

Automatic archival enabled

Archive Destination / Opt / Oracle / ORADATA / PRIMARY / ARCHIVE

Oldest Online Log Sequence 88

Next log sequence to archive 90

Current Log Sequence 90

SQL> ALTER DATABASE CREATE Standby ControlFile As '/opt/oracle/stdcotrl.ctl';

Database altered.

SQL>!

LS [Oracle @ Standby Oracle] $ LS

Admin Dictionary.ora Jre OraData ORADATA.TAR ORAINVENTORY OUI Product Soft stdcotrl.ctl

2. Create a PFILE file from the master node

SQL> CREATE PFILE from SPFILE;

File created.

SQL>!

[Oracle @ Standby Oracle] $ CD $ ORACLE_HOME / DBS [Oracle @ Standby DBS] $ lsinitdw.ora init.ora initprimary.ora lkprimary ORAPWPRIMARY SPFILEPRIMARY.ORA SQLNET.LOG

3. Log in to the standby node, FTP get database files, alternate control files and parameter files

Last login: MON AUG 16 08:47:58 2004 from 172.16.32.65

[root @ Eygle root] # su - Oracle [Oracle @ Eygle Oracle] $ LS

Admin Doc Jre ORADATA ORAINVENTORY OUI PRODUCT

[Oracle @ Eygle Oracle] $ DF -K

FileSystem 1K-block Used Available Use% MOUNTED ON

/ DEV / SDA1 5154852 3360600 1532396 69% /

/ DEV / SDA7 101089 25744 70126 27% / home

/ DEV / SDA5 4127076 2686152 1231280 69% / OPT

NONE 515296 0 515296 0% / dev / shm

/ DEV / SDA2 4127108 2218172 1699288 57% / usr

/ DEV / SDA6 2063504 107744 1850940 6% / var

[Oracle @ Eygle Oracle] $ FTP 172.16.33.58

Connected to 172.16.33.58 (172.16.33.58).

220 (vSFTPD 1.2.0)

Name (172.16.33.58 :root): Oracle

331 Please Specify The Password.

PASSWORD:

230 login surcessful.

FTP> LS

227 Entering Passive Mode (172, 16, 33, 58, 222, 252)

150 Here Comes The Directory Listing.

DRWXR-XR-X 3 800 800 4096 JUN 30 07:02 Admin

-rw-r - r - 1 800 800 5422222 JUL 13 11:58 Dictionary.ora

-rw-r - r - 1 800 800 1165 AUG 16 02:51 Initprimary.ora

DRWXRWXR-X 4 800 800 4096 JUN 30 06:29 JRE

DRWXRWXR-X 12 800 800 4096 Jun 30 06:44 ORAINVENTORY

DRWXR-XR-X 3 800 800 4096 JUL 01 06:15 ORADATA

-rw-r - r - 1 800 800 576512000 AUG 16 02:22 ORADATA.TAR

DRWXRWXR-X 6 800 800 4096 Jun 30 06:29 OUI

DRWXR-XR-X 3 800 800 4096 JUN 30 05:18 Product

DRWXR-XR-X 6 800 800 4096 Jun 30 04:24 Soft

-rw-r ----- 1 800 800 1662976 AUG 16 02:37 stdcotrl.ctl

226 Directory Send OK.

FTP> bin

200 switching to binary mode.

FTP> MGET ORADATA.TAR

Mget ORADATA.TAR? Y227 Entering Passive Mode (172, 16, 33, 58, 238, 132)

150 Opening Binary Mode Data Connection for ORADATA.TAR (576512000 Bytes).

226 File Send OK.

576512000 BYtes Received in 49.2 SECS (1.1e 04 kbytes / sec)

FTP> MGET * .CTL

MGET STDCOTRL.CTL? Y

227 Entering Passive Mode (172, 16, 33, 58, 73, 35)

150 Opening Binary Mode Data Connection for Stdcotrl.ctl (1662976 Bytes).

226 File Send OK.

1662976 BYtes Received in 0.14 SECS (1.2e 04 kbytes / sec)

FTP> MGET INTPRIMARY.ORA

MGET INTPRIMARY.ORA? Y

227 Entering Passive Mode (172, 16, 33, 58, 194, 239)

150 Opening Binary Mode Data Connection for Initprimary.ora (1165 bytes).

226 File Send OK.

1165 BYtes Received in 0.000325 SECS (3.5e 03 kbytes / sec)

FTP> BYE

221 Goodbye.

[Oracle @ Eygle Oracle] $ LS

Admin Doc Initprimary.ora Jre OraData ORADATA.TAR ORAINVENTORY OUI Product stdcotrl.ctl

[Oracle @ Eygle Oracle] $ MV INTPRIMARY.ORA $ ORACLE_HOME / DBS

[Oracle @ Eygle Oracle] $ CD $ ORACLE_HOME / DBS

[Oracle @ Eygle DBS] $ LS

A.sql initdw.ora init.ora initprimary.ora initrac1.ora initrac2.ora initrac.ora ORAPW

ORAPWRAC1 ORAPWRAC2 SPFilerac.ora

Unpacking data file

[Oracle @ Eygle Oracle] $ LS

Admin Doc Jre OraData ORADATA.TAR ORAINVENTORY OUI Product stdcotrl.ctl

[Oracle @ Eygle Oracle] $ TAR -XVF ORADATA.TAR

ORADATA /

ORADATA / PRIMARY /

ORADATA / PRIMARY / ARCHIVE /

ORADATA / PRIMARY / Control01.ctl

OraData / Primary / Control02.ctl

ORADATA / PRIMARY / Control03.ctl

ORADATA / PRIMARY / Redo01.log

OraData / primary / redo02.log

ORADATA / PRIMARY / Redo03.log

ORADATA / PRIMARY / System01.dbf

ORADATA / PRIMARY / undotbs01.dbf

ORADATA / PRIMARY / TEMP01.DBF

ORADATA / PRIMARY / USERS01.DBF

Modify Initprimary.ora file

Modify the control file name and path (if the original configuration is different), add several parameters, then modified as follows:

[Oracle @ Eygle DBS] $ catinitprimary.ora * .aq_tm_processes = 1

* .BACKGROUND_DUMP_DEST = '/ OPT / Oracle / Admin / Primary / BDUMP'

* .compatible = '9.2.0.0.0'

* .control_files = '/ opt / oracle / oradata / primary / stdcotrl.ctl'

* .CORE_DUMP_DEST = '/ OPT / ORACLE / Admin / Primary / CDump'

...

* .log_archive_dest_1 = 'location = / opt / oracle / oradata / primary / archive'

* .log_archive_dest_2 = ''

* .log_archive_format = '% t_% s.dbf'

* .log_archive_start = true

...

* .user_dump_dest = '/ opt / oracle / admin / primary / udump'

* .UTL_FILE_DIR = '/ opt / oracle'

* .standby_archive_dest = '/ opt / oracle / oraData / primary / stdarch'

* .fal_server = 'primary'

* .fal_client = 'standby'

* .standby_file_management = 'auto'

Create the necessary directory

[Oracle @ Eygle Oracle] $ CD $ ORACLE_BASE / Admin

[Oracle @ Eygle Admin] $ MKDIR PRIMARY

[Oracle @ Eygle Admin] $ LS

Primary rac

[Oracle @ Eygle Admin] $ CD PRIMARY /

[Oracle @ Eygle PRIMARY] $ LS

[Oracle @ Eygle PRIMARY] $ mkdir bdump cdump udump

4. Configure the main node listener and Tnsnames.ora file configuration as follows:

[Oracle @ Standby Oracle] $ cd /opt/oracle/product/9.2.0/neetwork/admin/

[Oracle @ Standby Admin] $ Cat Listener.ora

# Listener.ora NetWork configuration file: /opt/oracle/product/9.2.0/neetwork/admin/listener.ora

#Enerated by Oracle Configuration Tools.

Listener =

(Description_List =

(Description =

(Address_list =

(Address = (protocol = IPC) (key = extproc))

)

(Address_list =

(Address = (protocol = tcp) (host = standby) (port = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSEXTPROC)

(Oracle_Home = /opt/oracle/product/9.2.0) (Program = extproc)

)

(SID_DESC =

(Global_dbname = primary)

(Oracle_Home = /opt/oracle/product/9.2.0)

(SID_NAME = primary)

)

)

[Oracle @ Standby Admin] $ Cat Tnsnames.ora

# TNSNAMES.ORA NETWORK Configuration File: /opt/oracle/product/9.2.0/neetwork/admin/tnsnames.ora

#Enerated by Oracle Configuration Tools.

STANDBY =

(Description =

(Address_list =

(Address = (protocol = TCP) (Host = 172.16.33.46) (port = 1521)))

)

(Connect_data =

(Server = DEDICATED)

(Service_name = primary)

)

)

PRIMARY =

(Description =

(Address_list =

(Address = (protocol = tcp) (Host = 172.16.33.58) (port = 1521))))

)

(Connect_data =

(Server = DEDICATED)

(Service_name = primary)

)

)

[Oracle @ Standby Admin] $ LSNRCTL START

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 16-Aug-2004 10:46:31

CopyRight (C) 1991, 2002, Oracle Corporation. All Rights Reserved.

Starting /opt/oracle/Product/9.2.0/bin/tnslsnr: please wait ...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production

System parameter file is /opt/oracle/product/9.2.0/neetwork/admin/listener.ora

Log Messages Written to /opt/oracle/product/9.2.0/neetwork/log/listener.log

Listening on: (Description = (Address = (protocol = ipc))))

Listening ON: (Description = (address = (protocol = tcp) (port = standby)))))))))

Connecting to (deScription = (address = (protocol = ipc))))

Status of the listener

---------------------------------------------------------------------------------------------------------------------------------------

Alias ​​Listener

Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date 16-AUG-2004 10: 46: 31uptime 0 days 0 HR. 0 min. 0 SEC

Trace Level Off

Security off

SNMP OFF

Listener parameter file /opt/oracle/product/9.2.0/neetwork/admin/listener.ora

Listener log file /opt/oracle/product/9.2.0/neetwork/log/listener.log

Listening Endpoints Summary ...

(Description = (Address = (protocol = ipc)))))

(Description = (Address = (protocol = tcp) (port = standby))))))

Services Summary ...

Service "PLSextProc" HAS 1 Instance (s).

Instance "PLSextProc", Status Unknown, HAS 1 Handler (s) for this service ...

Service "Primary" HAS 1 Instance (s).

Instance "Primary", STATUS UNKNOWN, HAS 1 Handler (s) for this service ...

THE Command Complated SuccessFully

5. Configure alternate database listeners and tnsnames.ora files

The file has been configured as follows:

[Oracle @ Eygle Admin] $ CD $ ORACLE_HOME / NETWORK / Admin

[Oracle @ Eygle Admin] $ Cat Listener.ora

# Listener.ora NetWork configuration file: /opt/oracle/product/9.2.0/neetwork/admin/listener.ora

#Enerated by Oracle Configuration Tools.

Listener =

(Description_List =

(Description =

(Address_list =

(Address = (protocol = TCP) (Host = Eygle) (port = 1521)))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(Global_dbname = primary)

(Oracle_Home = /opt/oracle/product/9.2.0)

(SID_NAME = primary)

)

)

[Oracle @ Eygle Admin] $ CAT TNSNAMES. ORA

# TNSNAMES.ORA NETWORK Configuration File: /opt/oracle/product/9.2.0/neetwork/admin/tnsnames.ora

#Enerated by Oracle Configuration Tools.

STANDBY =

(Description =

(Address_list =

(Address = (protocol = tcp) (Host = 172.16.33.46) (port = 1521)))))))

(Connect_data =

(Server = DEDICATED)

(Service_name = primary)

)

)

PRIMARY =

(Description =

(Address_list =

(Address = (protocol = tcp) (Host = 172.16.33.58) (port = 1521))))

)

(Connect_data =

(Server = DEDICATED)

(Service_name = primary)

)

)

[Oracle @ Eygle Admin] $

6. Test network connectivity with TNSPING in the active and standby node

[Oracle @ Standby Admin] $ TNSPING Standby

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production On 16-Aug-2004 10:46:50

Copyright (c) 1997 Oracle Corporation. All Rights Reserved.

Used Parameter Files:

/opt/oracle/product/9.2.0/neetwork/admin/sqlnet.ora

Used tnsnames adapter to resolve the alias

Attempting to contact (deScription = (address = (protocol = tcp) (host = 172.16.33.46))))))))

(Connect_Data = (Server = Dedicated))))))))))

OK (10 msec)

[Oracle @ Standby Admin] $ TNSPING PRIMARY

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production On 16-Aug-2004 10:46:55

Copyright (c) 1997 Oracle Corporation. All Rights Reserved.

Used Parameter Files:

/opt/oracle/product/9.2.0/neetwork/admin/sqlnet.ora

Used tnsnames adapter to resolve the alias

Attempting to contact (deScription = (address = (protocol = tcp) (host = 172.16.33.58))))))

(Connect_Data = (Server = Dedicated))))))))))

OK (0 msec)

[Oracle @ Eygle Admin] $ TNSPING PRIMARY

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production On 16-Aug-2004 10:10:01

Copyright (c) 1997 Oracle Corporation. All Rights Reserved.

Used Parameter Files:

/opt/oracle/product/9.2.0/neetwork/admin/sqlnet.oraused Tnsnames Adapter to Resolve The Alias

Attempting to contact (deScription = (address = (protocol = tcp) (host = 172.16.33.58))))))

(Connect_Data = (Server = Dedicated))))))))))

OK (50 msec)

[Oracle @ Eygle Admin] $ TNSPING STANDBY

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 16-Aug-2004 10:10:06

Copyright (c) 1997 Oracle Corporation. All Rights Reserved.

Used Parameter Files:

/opt/oracle/product/9.2.0/neetwork/admin/sqlnet.ora

Used tnsnames adapter to resolve the alias

Attempting to contact (deScription = (address = (protocol = tcp) (host = 172.16.33.46))))))))

(Connect_Data = (Server = Dedicated))))))))))

OK (10 msec)

7. Start the standby database

[Oracle @ Eygle PRIMARY] $ Hostnameeygle [Oracle @ Eygle Primary] $ SQLPLUS "/ as sysdba"

SQL * PLUS: Release 9.2.0.4.0 - Production on Mon Aug 16 11:09:40 2004

CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.

Connected to an iDLE Instance.

SQL> Startup Nomount; Oracle Instance Started.

Total System Global Area 135337420 Bytesfixed Size 452044 Bytesvariable Size 109051904 Bytesdatabase Buffers 25165824 BYTESREDO BUFFERS 667648 BYTESSQL> ALTER DATABASE MOUNT Standby Database;

Database altered.

SQL> ALTABASE Recover Managed Standby Database Disconnect from Session;

Database altered.

8. Set the archive path in the main node

SQL> ALTER SESTEM SET LOG_ARCHIVE_DEST_2 = 'Service = Standby Mandatory Reopen = 60';

System altered.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> /

SYSTEM altered.

SQL>

Observation on the backup log [oracle @ eygle bdump] $ tail -f alert_primary.log MRP0: Background Managed Standby Recovery process startedStarting datafile 1 recovery in thread 1 sequence 90Datafile 1: '/opt/oracle/oradata/primary/system01.dbf' Starting datafile 2 recovery in thread 1 sequence 90Datafile 2: '/opt/oracle/oradata/primary/undotbs01.dbf'Starting datafile 3 recovery in thread 1 sequence 90Datafile 3:' /opt/oracle/oradata/primary/users01.dbf ' Media Recovery Waiting for thread 1 seq # 90Mon Aug 16 11:10:50 2004Completed: alter database recover managed standby database diMon Aug 16 11:13:34 2004Media Recovery Log /opt/oracle/oradata/primary/stdarch/1_90.dbfMedia Recovery Waiting for thread 1 seq # 91Media Recovery Log /opt/oracle/oradata/primary/stdarch/1_91.dbfMedia Recovery Waiting for thread 1 seq # 92Mon Aug 16 12:09:38 2004Media Recovery Log / opt / oracle / oradata / primary / STDARCH / 1_92.DBF

9. The same configuration is performed in the primary node to switch the log transmission after switching.

[Oracle @ standby oracle] $ lsadmin dictionary.ora initprimary.ora jre oradata oradata.tar oraInventory oui product soft stdcotrl.ctl [oracle @ standby oracle] $ cd oradata [oracle @ standby oradata] $ lsprimary [oracle @ standby oradata] $ cd primary / [oracle @ standby primary] $ lsarchive control02.ctl redo01.log redo03.log temp01.dbf users01.dbfcontrol01.ctl control03.ctl redo02.log system01.dbf undotbs01.dbf [oracle @ standby primary] $ mkdir stdarch [ Oracle @ Standby PRIMARY] $ EXIXIXIT

SQL> ALTER System Set Standby_archive_Dest = '/ OPT / ORACLE / ORADATA / PRIMARY / STDARCH'

System altered.

10. Stop the primary database and enable the standby database

SQL> ALTABASE COMMIT TO SWITCHOVER TO Physical Standby;

Database altered.

SQL> Shutdown Immediate

ORA-01507: Database Not MountedOracle Instance Shut Down.

Enable primary data in standby mode

SQL> Startup Nomount;

Oracle Instance Started.

Total System Global Area 135337420 Bytes

Fixed Size 452044 BYTES

Variable size 109051904 bytes

Database buffers 25165824 BYTES

Redo buffers 667648 bytes

SQL> ALTER DATABASE MOUNT Standby Database;

Database altered.

SQL> SELECT NAME, OPEN_MODE, PROTECTION_MODE, DATABASE_ROLE from V $ Database;

NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE

----------------------------------- -----

Primary Mounted Maximum Performance Physical Standby

SQL> ALTABASE Recover Managed Standby Database Disconnect from Session;

Database altered.

Open alternate database

[Oracle @ Eygle Oracle] $ SQLPLUS "/ as sysdba"

SQL * Plus: Release 9.2.0.4.0 - Production on Mon Aug 16 12:11:11 2004

CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the partitioning, Real Application Clusters, OLAP AND ORACLE DATA MINING OPTIONS

JServer Release 9.2.0.4.0 - Production

SQL> ALTABASE COMMIT TO SWITCHOVER to PRIMARY;

Database altered.

SQL> Shutdown Immediate;

ORA-01507: Database Not Mounted

Oracle Instance Shut Down.

SQL> Startup

Oracle Instance Started.

Total System Global Area 135337420 Bytes

Fixed Size 452044 BYTES

Variable size 109051904 bytes

Database buffers 25165824 BYTES

Redo buffers 667648 bytes

Database mounted.

Database opened.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

Observe the log application on the main library

[Oracle @ Standby Bdump] $ TAIL -F Alert_Primary.logstarting DataFile 2 Recovery in Thread 1 SEQUENCE 93

DataFile 2: '/opt/oracle/oradata/primary/undotbs01.dbf'

Starting DataFile 3 Recovery in Thread 1 SEQUENCE 93

DataFile 3: '/opt/oracle/oradata/primary/users01.dbf'

Media recovery log /opt/oracle/product/9.2.0/dbs/arch1_93.dbf

Mon aug 16 15:08:43 2004

Media recovery log /opt/oracle/oradata/primary/stDarch/1_94.dbf

Media Recovery Waiting for Thread 1 SEQ # 95

Media recovery log /opt/oracle/oradata/primary/stdarch/1_95.dbf

Media Recovery Waiting for Thread 1 SEQ # 96

11. Data modification

SQL> CREATE TABLE T AS SELECT * FROM DBA_USERS;

Table created.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

Open the database with read only on the library, execute the query

SQL> SELECT Username from T;

Select Username from T

*

Error At Line 1:

ORA-01219: Database NOT OPEN: Queries Allowed on Fixed Tables / Views ONLY

SQL> ALTABASE CANAGER DATABASE CANCEL;

Database altered.

SQL> ALTER DATABASE OPEN Read Only

Database altered.

SQL> SELECT Username from T;

Username

------------------------------

SYS

SYSTEM

DBSNMP

Outln

WMSYS

SQL> ALTABASE Recover Managed Standby Database Disconnect from Session;

Database altered.

SQL>

12. Switch the database back to the main node

In the main node

SQL> ALTABASE COMMIT TO SWITCHOVER TO Physical Standby;

Database altered.

SQL> Shutdown Immediate

ORA-01507: Database Not Mounted

Statoracle Instance Shut Down.

SQL> Startup Nomount;

Oracle Instance Started.

Total System Global Area 135337420 Bytes

Fixed Size 452044 BYTES

Variable size 109051904 bytes

Database buffers 25165824 BYTES

Redo buffers 667648 bytes

SQL> ALTABASE MOUNTSADBY Database; Database Altered.

SQL> ALTABASE Recover Managed Standby Database Disconnect from Session;

Database altered.

In standby node

SQL> ALTABASE COMMIT TO SWITCHOVER to PRIMARY;

Database altered.

SQL> Shutdown Immediate;

ORA-01507: Database Not Mounted

Oracle Instance Shut Down.

SQL> Startup

Oracle Instance Started.

Total System Global Area 135337420 Bytes

Fixed Size 452044 BYTES

Variable size 109051904 bytes

Database buffers 25165824 BYTES

Redo buffers 667648 bytes

Database mounted.

Database opened.

Complete free switching

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

New Post(0)