How To Start Standby Database In Read Only With Apply
How To Start Standby Database In Read Only With Apply. Starting a physical standby database. Startup nomount alter database mount standby database;
Steps for standby database for read only access when it is mounted and performing. After mounting the database as a standby database, the log apply services are started: Pause ship logs & apply logs on both the primary & standby hosts.
Sql> Alter Database Open Read Only;
(note that for distributed queries, you must first issue the alter. Sql> select open_mode from v$database; 4 /u01/app/oracle/oradata/dbvone/users01.dbf 1702015 online read write.
Alter Database Open Read Only;
Sql> select name,open_mode from v$database; After mounting the database as a standby database, the log apply services are started: Categories 11g, dataguard, oracle tags active data guard in oracle, alter system set log_archive_dest_2, convert physical standby to logical standby, data guard broker.
Steps For Standby Database For Read Only Access When It Is Mounted And Performing.
For this example i am running setup wizard selecting options (single_scn/exp) for schema scott then. 8:42 open the databases and start recovery 8:43 check status from primary shows sequence 75 and to standby for switchover status did log switches at 8:44, 8:45, and 8:46. Pause ship logs & apply logs on both the primary & standby hosts.
Have The Standby Database Open For Querying By Your Team.
Starting a physical standby database. Startup nomount alter database mount standby database; Sql> alter database activate physical standby database;
You Can See The Database Role Is Primary And Start Option Is Open, If You Restart The Host, The Standby Db Will Go To Read Only.
So after the application of archivelog. Bear in mind that by midday it will now be up to four hours behind production. Start a sql*plus session and execute the following statement:
Post a Comment for "How To Start Standby Database In Read Only With Apply"