Friday , July 21 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

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

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