Steps to Start and Stop Oracle Standby Database
Syntax to Start a Oracle Standby Database
startup nomount;
ORACLE instance started.
Total System Global Area 3206836224 bytes
Fixed Size 2257520 bytes
Variable Size 1191185808 bytes
Database Buffers 1979711488 bytes
Redo Buffers 33681408 bytes
alter database mount standby database;
Database altered.
alter database recover managed standby database disconnect from session;
Database altered.
Syntax to Stop a running Oracle Standby Database
alter database recover managed standby database cancel;
Database altered.
shut immediate;
The commands will stop the recover process which is identified as the MRP0 process, followed by the “shutdown immediate” – a clean shutdown of the database.
No comments:
Post a Comment