-
I created a database and I don't know where I missed (DBassist) that it created 3 groups with 1 member in each..
How can I make that to atleast 2 members in each grp?
Do I have to create redolog 4a,4b to 6a,6b and then drop the redolog 1,2,3 or how?? Please be detailed..
Thanks, ST
-
I am not gonmna be detailed because it is explain in detail in the DOCs on technet. All I can say is you dont need to drop, you can simply add a member to each group
Check administration guide: managing redo logs in the DOCs
-
Try
ALTER DATABASE ADD LOGFILE MEMBER [ 'filename' [REUSE], 'filename' [REUSE]] ...
TO { GROUP integer,}
]
ALTER DATABASE ADD LOGFILE MEMBER
'/DISK4/log1b.redo' TO GROUP 1,
'/DISK4/log2b.redo' TO GROUP 2;
Sam
Thanx
Sam
Life is a journey, not a destination!
-
IF I could remember all the commands by hard
-
Then why the books are for
Sam
Thanx
Sam
Life is a journey, not a destination!
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
|