Dataguard How to restore to management recovery mode from library downtime

First, Sys landing

Instance:

$ sqlplus/as SYSDBA

Sql*plus:release 10.2.0.4.0-production on Wed Nov 3 07:35:34 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to a idle instance.

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

Second, prepare the library to boot to the management recovery mode

Sql>startup Nomount;

Sql>alter database mount standby database;

Sql>alter database recover managed standby database disconnect from session;

Instance:

sql> startup Nomount;

ORACLE instance started.

Total System Global area 8187281408 bytes

Fixed Size 2097024 bytes

Variable Size 1308622976 bytes

Database buffers 6861881344 bytes

Redo buffers 14680064 bytes

Sql> ALTER DATABASE mount standby database;

Database altered.

sql> ALTER DATABASE recover managed standby database disconnect from session;

Database altered.

Sql> exit

Disconnected from Oracle Database 10g Enterprise Edition release 10.2.0.4.0-64bit Production

With the partitioning, OLAP, Data Mining and real application testing options

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

Third, start listening

$ lsnrctl Start

Lsnrctl for Ibm/aix RISC system/6000:version 10.2.0.4.0-production on 03-nov-2010 07:36:39

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting/home/oracle/database/bin/tnslsnr:please wait ...

Tnslsnr for Ibm/aix RISC system/6000:version 10.2.0.4.0-production

System parameter File Is/home/oracle/database/network/admin/listener.ora

Log messages Written To/home/oracle/database/network/log/listener.log

Listening on: (Description= (Address= (protocol=tcp) (host=172.16.128.26) (port=1521))

Connecting to (description= address= (protocol=tcp) (host=172.16.128.26) (port=1521))

STATUS of the LISTENER

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

Alias LISTENER

Version Tnslsnr for Ibm/aix RISC system/6000:version 10.2.0.4.0-production

Start Date 03-nov-2010 07:36:40

Uptime 0 days 0 hr. 0 min. 2 sec

Trace level off

Security On:local OS Authentication

SNMP on

Listener Parameter File/home/oracle/database/network/admin/listener.ora

Listener Log File/home/oracle/database/network/log/listener.log

Listening Endpoints Summary ...

(Description= (address= (protocol=tcp) (host=172.16.128.26) (port=1521))

Services Summary ...

Service "Plsextproc" has 1 instance (s).

Instance "Plsextproc", Status UNKNOWN, has 1 handler (s) for the This service ...

Service "Standby" has 1 instance (s).

Instance "standby", status UNKNOWN, has 1 handler (s) for the This service ...

The command completed successfully

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