Monday , September 25 2017
Home / Oracle DBA / Additional commands for Dataguard

Additional commands for Dataguard

Additional commands for Data guard

# Add Standby Redo Log Groups to Standby Database
Create standby redo log groups on standby database (start with next group number; create one more group than current number of groups) after switching out of managed recovery mode:
SQL> sql plus “/ as sysdba”
SQL> alter database recover managed standby database cancel;
SQL> alter database open read only;
SQL> select max(group#) max group from v$log file;
SQL> select max(bytes) / 1024 “size (K)” from v$log;
SQL> alter database add standby logfile group 4 (‘/orcl/ora data/PROD2/st by_log_PROD_4A.rdo’,’/orcl/ora data/PROD2/stby_log_PROD_4B.rdo’) size 4096K; … etc …
SQL> column member format a55
SQL> select vs.group#,vs.bytes,vl.member from v$standby_logvs,v$logfile vl where vs.group# = vl.group# order by vs.group#,vl.member;
# Add Temp fileTo Standby
Add a tempfile to the standby database for switchover or read-only access, then, switch back to managed recovery:
SQL> alter tablespace temp add tempfile ‘/data/oradata/PROD2/temp_PROD_01.dbf’ size 400064K reuse;
SQL> alter database recover managed standby database disconnect from session;
SQL> select * from v$tempfile;
SQL> exit
View More:
Oracle FLASHBACK DATABASE
FLASHBACK TRANSACTION QUERY
FLASHBACK FEATURES

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *