-
redo log groups
Hi All,
Thanks for helping.
Actually i have doubt. Please find my enivronment.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
PRLT0 READ WRITE
SQL> select MEMBER from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DG_01/PRLT0/onlinelog/redo02.log
+DG_01/PRLT0/onlinelog/redo01.log
+DG_01/PRLT0/onlinelog/redo03.log
+DG_01/PRLT0/onlinelog/redo04.log
SQL> select instance_number, instance_name, thread# from gv$instance;
INSTANCE_NUMBER INSTANCE_NAME THREAD#
--------------- ---------------- ----------
2 PRLT02 2
1 PRLT01 1
SQL> select group#, thread#, members ,status from v$log;
GROUP# THREAD# MEMBERS STATUS
---------- ---------- ---------- ----------------
1 1 1 INACTIVE
2 1 1 CURRENT
3 2 1 INACTIVE
4 2 1 CURRENT
I want to add four redo log groups per instance.
Totally have to add 8 redo log groups for two node cluster.
Please command to add the redo log groups:-
=========================================
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 ('+DG_01') SIZE 256M;
My question when have to add this one?
whether i have change anything before adding?
Thanks & Regards,
Indira Shyamsundar
-
Indra -
check it in your test database and post if you have any issue.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|