For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Dear Gents
Kindly help with upgrade weblogic 12c to weblogic 14c steps document
Platform: Oracle Enterprise linux - latest
Regards
Hi,
I didn't understand your process, but anyway why don't you just open the standby database in read only mode (active data guard) ?
hi,
You use active DataGuard? Secondary Database (Standby database) in read only mode?
Can you please paste here: (Standby Database)
SQL>select open_mode from v$database;
And
SQL> set linesize 1000
SQL> set pagesize 100
SQL>
SQL> select name, value from v$dataguard_Stats;
Thank you
you database version information is important.
yes you can do this. some important points to remeber.
1. before shutdown of the dr defer the log_archive_dest for standby to stop archive shipping to the standby.
2. after shuttting down the DR copy the datafile and controlfile as well.
3. After your testing is completed.
4. REMANE PROD_bak to PROD and then start the standby dataabse. The database which you have open if not required then delete all the file before renaming.
You can open a standby database read only, no issues there keep in mind that archive log apply will stop while the database is read only unless you use the active dataguard option, but depending on version of the database it may not be available.
See Oracle documentation I got all this from there:
http://docs.oracle.com/cd/B10501_01/server.920/a96653/manage_ps.htm
SQL> STARTUP NOMOUNT;
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> ALTER DATABASE OPEN READ ONLY;
Cancel log apply services:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Open the database for read-only access:
Now to put the database back to physical standby and apply the logs
Terminate all active user sessions on the standby database, a shutdown works very well here
SQL> shutdown immediate;
Restart log apply services:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
HI again,
Please check step by step in Secondary (Standby Database)
SQL> select name, value from v$dataguard_Stats; -- is ok then check below step:
For example: in Standby database:
NAME VALUE
------------------------- --------------------------------------------------
transport lag +00 00:00:00
apply lag +00 00:00:00
apply finish time +00 00:00:00.000
estimated startup time 21
------------------------------------------------------------------------------
Next Step in Secondary database:
And starying again MRP process in Secondary database:
STARTUP NOMOUNT
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Thanks ALL,
DB 11.2.0.1
Supposing I will not hold-off or disrupt the standby db process since I am afraid that disaster strikes while it is paused off.
But instead I will create another reporting db out of the standby because the standby server has not so much load on it.
Is this possible with RMAN? Creating a duplicate db out of the standby?
Why not - You can create duplicate db - Till now you haven't posted your db version..?
My db is 11.2.0.1
As your database is of 11g version. You can take advantage of snapshot standby.
I searched google about snapshot db but it so complicated.
It says I need to configure DGBROKER which also complicated by its name.
Can I create snapshot db without using dgbroker?
Thanks,
It's not complusory to configure dgbroker. You can configure snapshot standby without dgbroker. Following are the link for the same.
http://satya-dba.blogspot.in/2012/06/snapshot-standby-databases-oracle.html
http://shivanandarao-oracle.com/2013/02/04/snapshot-standby-database-convert-physical-standby-database-to-snapshot-standby-database-read-write-mode-and-viceversa/
Thanks Saur